Database error when a comment is posted.

  • abohart

    (@abohart)


    21 years ago

    I get the following errors when someone posts a comment:

    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 ‘WHERE comment_ID = 36’ at line 1]

    UPDATE wp_comments SET comment_reply_ID= WHERE comment_ID = 36;

    Warning: Cannot modify header information – headers already sent by (output started at /nfsn/content/philatelictidbits/htdocs/wp-includes/wp-db.php:98) in /nfsn/content/philatelictidbits/htdocs/wp-comments-post.php on line 44

    [Repeat errors]

    Any idea on how to fix this?

Viewing 16 replies (of 16 total)
1 2
  • Ajay

    (@ajay)

    20 years, 11 months ago

    Has not happened in a while, but it is back again!

    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 ‘ve really not written any teachings but just what I learn from ]
    SELECT comment_ID FROM wp_comments WHERE comment_post_ID = ‘318’ AND ( comment_author = ‘Ajay’ OR comment_author_email = ‘me@ajaydsouza.com’ ) AND comment_content = ‘Believer in? If you are talking being a Catholic, yes I am one. I’ve really not written any teachings but just what I learn from others, that too in brief. And, thanks for the compliment :)’ LIMIT 1

    Warning: Cannot modify header information – headers already sent by (output started at /home/ajay82/public_html/wp-includes/wp-db.php:98) in /home/ajay82/public_html/wp-comments-post.php on line 51

    Warning: Cannot modify header information – headers already sent by (output started at /home/ajay82/public_html/wp-includes/wp-db.php:98) in /home/ajay82/public_html/wp-comments-post.php on line 52

    Warning: Cannot modify header information – headers already sent by (output started at /home/ajay82/public_html/wp-includes/wp-db.php:98) in /home/ajay82/public_html/wp-comments-post.php on line 53

    Warning: Cannot modify header information – headers already sent by (output started at /home/ajay82/public_html/wp-includes/wp-db.php:98) in /home/ajay82/public_html/wp-comments-post.php on line 55

    Warning: Cannot modify header information – headers already sent by (output started at /home/ajay82/public_html/wp-includes/wp-db.php:98) in /home/ajay82/public_html/wp-comments-post.php on line 56

    Warning: Cannot modify header information – headers already sent by (output started at /home/ajay82/public_html/wp-includes/wp-db.php:98) in /home/ajay82/public_html/wp-comments-post.php on line 57

    Warning: Cannot modify header information – headers already sent by (output started at /home/ajay82/public_html/wp-includes/wp-db.php:98) in /home/ajay82/public_html/wp-comments-post.php on line 58

    Warning: Cannot modify header information – headers already sent by (output started at /home/ajay82/public_html/wp-includes/wp-db.php:98) in /home/ajay82/public_html/wp-includes/pluggable-functions.php on line 129

    I realized that I wrote the word “I’ve” and the error starts after the apostrophe. Any workaround to this?

Viewing 16 replies (of 16 total)
1 2

The topic ‘Database error when a comment is posted.’ is closed to new replies.