OK, I'm trying to leave a comment, as I often do, in the Gorilla
Protection blog that's linked from my site (nothoney.wordpress.com),
but I got this error page:
WordPress database error: [Table 'wildlqgm.ubq_16_sk2_spams' doesn't exist]
SELECT comment_table.*, posts_table.*, users_table.*,
spam_table.*, spam_table.id AS spam_table_id, NOW() AS
now_sql FROM ubq_16_comments AS comment_table LEFT JOIN
ubq_16_posts AS posts_table ON posts_table.ID =
comment_table.comment_post_ID LEFT JOIN ubq_users AS
users_table ON users_table.ID = comment_table.user_id LEFT
JOIN ubq_16_sk2_spams AS spam_table ON spam_table.comment_ID =
comment_table.comment_ID WHERE comment_table.comment_ID = 3868
sk2_comment: Cannot fetch comment record from table.
SQL error: Table 'wildlqgm.ubq_16_sk2_spams' doesn't exist
Error: Submitted Post_ID variable (152) not matching ours (0).
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 comments.comment_approved = '1' AND
comments.comment_date_gmt < DATE' at line 1]
SELECT COUNT(*) AS cmt_count, AVG(spams.karma) AS karma_avg
FROM ubq_16_comments AS comments LEFT JOIN ubq_16_sk2_spams AS
spams ON spams.comment_ID = comments.comment_ID WHERE
comments.comment_ID != AND comments.comment_approved = '1' AND
comments.comment_date_gmt < DATE_SUB('', INTERVAL 3 DAY) AND
comments.comment_author_IP = ''
get_granularity: query failed.
Query: SELECT COUNT(*) AS cmt_count, AVG(spams.karma) AS
karma_avg FROM ubq_16_comments AS comments LEFT JOIN
ubq_16_sk2_spams AS spams ON spams.comment_ID =
comments.comment_ID WHERE comments.comment_ID != AND
comments.comment_approved = '1' AND comments.comment_date_gmt
< DATE_SUB('', INTERVAL 3 DAY) AND comments.comment_author_IP = ''
SQL 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 comments.comment_approved = '1' AND
comments.comment_date_gmt < DATE' at line 1
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 comment_post_ID = AND comment_approved =
'1' AND comment_date_gmt > D' at line 1]
SELECT COUNT(*) AS cmt_count FROM ubq_16_comments AS comments
WHERE comments.comment_ID != AND comment_post_ID = AND
comment_approved = '1' AND comment_date_gmt > DATE_SUB(NOW() ,
INTERVAL 15 DAY)
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 1]
UPDATE ubq_16_comments SET comment_approved = '0' WHERE comment_ID =
Error: cannot update comment entry ID: 0 to status: moderated.
SQL 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 1
Cannot update sk2_kSpamTable info (no comment ID provided).
I wrote to support and they sent me here. Yes, I searched but couldn't find anything similar. Help.
s.
