Comment on another site causes huge error message
-
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]
SELECTcomment_table
.*,posts_table
.*,users_table
.*,
spam_table
.*,spam_table
.id
ASspam_table_id
, NOW() AS
now_sql
FROMubq_16_comments
AScomment_table
LEFT JOIN
ubq_16_posts
ASposts_table
ONposts_table
.ID
=
comment_table
.comment_post_ID
LEFT JOINubq_users
AS
users_table
ONusers_table
.ID
=comment_table
.user_id
LEFT
JOINubq_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 ‘ANDcomments
.comment_approved
= ‘1’ AND
comments
.comment_date_gmt
< DATE’ at line 1]
SELECT COUNT(*) AScmt_count
, AVG(spams
.karma
) ASkarma_avg
FROMubq_16_comments
AScomments
LEFT JOINubq_16_sk2_spams
AS
spams
ONspams
.comment_ID
=comments
.comment_ID
WHERE
comments
.comment_ID
!= ANDcomments
.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(*) AScmt_count
, AVG(spams
.karma
) AS
karma_avg
FROMubq_16_comments
AScomments
LEFT JOIN
ubq_16_sk2_spams
ASspams
ONspams
.comment_ID
=
comments
.comment_ID
WHEREcomments
.comment_ID
!= AND
comments
.comment_approved
= ‘1’ ANDcomments
.comment_date_gmt
< DATE_SUB(”, INTERVAL 3 DAY) ANDcomments
.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 ‘ANDcomments
.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 ‘ANDcomment_post_ID
= ANDcomment_approved
=
‘1’ ANDcomment_date_gmt
> D’ at line 1]
SELECT COUNT(*) AScmt_count
FROMubq_16_comments
AScomments
WHEREcomments
.comment_ID
!= ANDcomment_post_ID
= AND
comment_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]
UPDATEubq_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.
- The topic ‘Comment on another site causes huge error message’ is closed to new replies.