Comment Page (Database) Errors

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

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.

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.

And I also installed PluginsUsedPlugin and RunPHP Plugin.

Can someone please help?!

Have you UNinstalled everything you put in ??

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

And sorry, I accidently deleted your comment.

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

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.

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

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.

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?

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