WordPress.org

Ready to get started?Download WordPress

Forums

Comment on another site causes huge error message (3 posts)

  1. nothoney
    Member
    Posted 7 years 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 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.

  2. idahofallzcom
    Member
    Posted 7 years ago #

    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

  3. nothoney
    Member
    Posted 7 years ago #

    Thanks, yeah, I did send them a note last night and they replied this morning - time difference and all. They're looking into it.

    s.

Topic Closed

This topic has been closed to new replies.

About this Topic