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.
Do you admin on the Gorilla site? This looks like their site issue, not your site issue.
They appear to have configured the Spam Karma plugin incorrectly, if you talk to their admin you might recommend deleting the appropriate plugin folder, then reuploading/activating/testing
(@nothoney)
16 years, 10 months ago
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
ASspam_table_id
, NOW() ASnow_sql
FROMubq_16_comments
AScomment_table
LEFT JOINubq_16_posts
ASposts_table
ONposts_table
.ID
=comment_table
.comment_post_ID
LEFT JOINubq_users
ASusers_table
ONusers_table
.ID
=comment_table
.user_id
LEFTJOIN
ubq_16_sk2_spams
ASspam_table
ONspam_table
.comment_ID
=comment_table
.comment_ID
WHEREcomment_table
.comment_ID
= 3868sk2_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’ ANDcomments
.comment_date_gmt
< DATE’ at line 1]SELECT COUNT(*) AS
cmt_count
, AVG(spams
.karma
) ASkarma_avg
FROM
ubq_16_comments
AScomments
LEFT JOINubq_16_sk2_spams
ASspams
ONspams
.comment_ID
=comments
.comment_ID
WHEREcomments
.comment_ID
!= ANDcomments
.comment_approved
= ‘1’ ANDcomments
.comment_date_gmt
< DATE_SUB(”, INTERVAL 3 DAY) ANDcomments
.comment_author_IP
= ”get_granularity: query failed.
Query: SELECT COUNT(*) AS
cmt_count
, AVG(spams
.karma
) ASkarma_avg
FROMubq_16_comments
AScomments
LEFT JOINubq_16_sk2_spams
ASspams
ONspams
.comment_ID
=comments
.comment_ID
WHEREcomments
.comment_ID
!= ANDcomments
.comment_approved
= ‘1’ ANDcomments
.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’ ANDcomments
.comment_date_gmt
< DATE’ at line 1WordPress 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
= ANDcomment_approved
=‘1’ AND
comment_date_gmt
> D’ at line 1]SELECT COUNT(*) AS
cmt_count
FROMubq_16_comments
AScomments
WHERE
comments
.comment_ID
!= ANDcomment_post_ID
= ANDcomment_approved
= ‘1’ ANDcomment_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
SETcomment_approved
= ‘0’ WHEREcomment_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.