mysql error

  • blazey

    (@blazey)


    16 years, 9 months 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 =

Viewing 4 replies - 1 through 4 (of 4 total)
  • MichaelH

    (@michaelh)

    16 years, 9 months ago

    Do you have a link to that plugin, please.

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

    Thread Starter blazey

    (@blazey)

    16 years, 9 months 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

    Austin Matzko

    (@filosofo)

    16 years, 7 months 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;
    steveegg

    (@steveegg)

    16 years, 6 months 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; }
Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘mysql error’ is closed to new replies.