WordPress.org

Ready to get started?Download WordPress

Forums

mysql error (5 posts)

  1. blazey
    Member
    Posted 7 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
    Member
    Posted 7 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 7 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: http://www.ilfilosofo.com/blog/comments-preview

  4. Austin Matzko
    Member
    Posted 6 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 6 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.

About this Topic