WordPress.org

1. blazey
   Member
   Posted 2 years ago #

   hi, maybe somebody can help me with that. i installed a preview plugin for comments. following error comes up, though the message is previewed when u hit the preview button.

   WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and meta_key =' at line 1]
   SELECT meta_value FROM wp_postmeta WHERE post_id = and meta_key =

2. MichaelH
   moderator
   Posted 2 years ago #

   Do you have a link to that plugin, please.

   If the plugin is deactivated do you have the same problem?

3. blazey
   Member
   Posted 2 years ago #

   hi micheal,

   when i deactivate the plugin there´s no error ofcourse cause there is no preview possibility. the regular posting method works fine. when the plugin is activated i can post comments without any errors. but when i press preview the error message appears.

   the plugin i use is: www.ilfilosofo.com/blog/comments-preview

4. filosofo
   Member
   Posted 2 years ago #

   This is caused by a conflict between my plugin, filosofo-comments-preview, and the WP-AJAX-Edit-Comments Plugin.

   You can fix the problem by patching the wp-ajax-edit-comments.php file like so:

   644a645,646
   >                                       if ( empty( $id ) || empty( $comment ) )
   >                                               return false;

5. steveegg
   Member
   Posted 2 years ago #

   That fix isn't working for me, at least with WP 2.3, but I found another one.

   Put the following just before the line that reads //Checks to see if the admin has allowed comment editing

   //Return false if the comment is a preview (Filosofo Comments Preview only)
   					if (isset($_POST['comment']) && isset($_POST['comment_post_ID']) && isset($_POST['preview'])) { return false; }

Topic Closed

This topic has been closed to new replies.