WordPress.org

1. bk
   Member
   Posted 6 years ago #

   When your try to post a comment on my site, you get a database error in wp-comments-post.php file. Can someone tell me what's going wrong? :(

2. Mark (podz)
   Support Maven
   Posted 6 years ago #

   When did this start, and what did you change just before it happened ?

3. bk
   Member
   Posted 6 years ago #

   I just added the default gravatar in the comment preview yesterday. After that, I didn't test if the comments were working (How stupid of me!). Just right now, a friend of mine posted a comment and he told me that it's displaying an error.

   The problem could be in the default gravatar that I added in the comment preview.

4. bk
   Member
   Posted 6 years ago #

   I just removed that default gravatar from the comment preview.
   The problem still exists. Do you think I should create a new/repair MySQL Database?

   I am also getting errors when I try to delete a comment.

5. bk
   Member
   Posted 6 years ago #

   And I also installed PluginsUsedPlugin and RunPHP Plugin.

6. bk
   Member
   Posted 6 years ago #

   Can someone please help?!

7. Mark (podz)
   Support Maven
   Posted 6 years ago #

   Have you UNinstalled everything you put in ??

8. bk
   Member
   Posted 6 years ago #

   Yes, podz, I have. Uninstalled everything that I put in last night. Still getting errors. What now? :(

   And sorry, I accidently deleted your comment.

9. James
   Happiness Engineer
   Posted 6 years ago #

   Would you please quote the error? We aren't psychics.

10. bk
    Member
    Posted 6 years ago #

    Sorry. Here's the error when you try to leave 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 '' at line 3]
    SELECT post_id FROM wp_post2cat WHERE category_id =

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

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

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

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

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

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

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

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

    And here's the error when I try to delete 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 '' at line 3]
    SELECT post_id FROM wp_post2cat WHERE category_id =

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

    Thank you, in advance for your help.

11. bk
    Member
    Posted 6 years ago #

    Should I try and repair the MySQL database in my CPanel?

12. James
    Happiness Engineer
    Posted 6 years ago #

    First, disable all of your plugins, then switch to the WordPress Default Theme (or the WordPress Classic Theme if you are already using the Default Theme). Do you see any improvement?

    Yes, try to Repair and Optimize your database too. You can do this by accessing the database via phpmyadmin.

13. bk
    Member
    Posted 6 years ago #

    Disabled all the plugins. Switched to WordPress Classic Theme and it works perfect now.

    So I'm guessing the problem was in one of the plugins?

14. bk
    Member
    Posted 6 years ago #

    Hah, the Extended Live Archive Plugin was causing the problem, I think...

Topic Closed

This topic has been closed to new replies.