WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Spam Karma 2 Trouble (6 posts)

  1. Bhooshan
    Member
    Posted 8 years ago #

    Hello folks, I have installed Spam Karma 2 (SK2). I have been facing some issues with it now. I get this error message:

    Can't fetch comments.
    Query: SELECT posts_table.post_title, spam_table.karma, spam_table.id as spam_id,spam_table.karma_cmts, comments_table.* FROM wp_comments AS comments_table, wp_posts AS posts_table LEFT JOIN wp_sk2_spams AS spam_table ON spam_table.comment_ID = comments_table.comment_ID WHERE comment_approved != '1' AND posts_table.ID = comments_table.comment_post_ID ORDER BY comments_table.comment_date_gmt DESC LIMIT 30
    SQL error: Table 'bhooshan_wrdp2.wp_sk2_spams' doesn't exist

    Secondly I was surprised to find that SK2 has not created any tables in my database. I just wanted to know the reason behind this and how do I get things back on track.

  2. Mark (podz)
    Support Maven
    Posted 8 years ago #

    I would deactivate, delete and then try reinstalling it.

  3. Bhooshan
    Member
    Posted 8 years ago #

    Thanks Podz. I have done exactly the way you have prescribed. It's not forming the tables in the database. :-(

    Any other ideas on resolving this? think this is a very rare case where it's troubling the user :-(

  4. drdave
    Member
    Posted 8 years ago #

    Bhooshan:

    Have you tried the "Reset All Tables" button under "advanced options". It should re-create these tables that were apparently never created for some reason... If it doesn't, it will at least spit out an error message. Please copy this message and send it to me.

  5. Bhooshan
    Member
    Posted 8 years ago #

    Phew..Dave you're godsent O:-)

    I did as you told me and I have got SK2 running smoothly. I can now recover some comments on my website which were not spam at all :-)

    Thanks for your help and thanks for developing this wonderful plugin O:-)

  6. elmsblog
    Member
    Posted 8 years ago #

    I'm wondering about the order of the spam filters. More specifically, I have a few terms in my "comment moderation" box which is suppost to hold comments for moderation. It seems that these terms are no longer active, as 1 user whose IP I've added into this box is now able to comment freely (the bastard! ;-). Any thoughts? Thanks!

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.