Support » Plugin: Spam protection, AntiSpam, FireWall by CleanTalk » Huge 144 MB “wp_cleantalk_sessions” Table in Database

  • Resolved Yet Another WP User

    (@yet-another-wp-user)


    Today I checked my website database and I found following table of huge size 144 MB:

    wp_cleantalk_sessions

    What the hell this table is doing in my database? This table didn’t exist in past.

    Since which version of CleanTalk plugin, this table was added?

    Why is the size of this table so huge? What this table does?

    Most important question! I have disabled all form protections. I have only enabled Spam Firewall. Then why this table is creating new records in my database?

    • This topic was modified 1 month, 1 week ago by  Jan Dembowski.
Viewing 10 replies - 1 through 10 (of 10 total)
  • Plugin Support amagsumov

    (@amagsumov)

    Hello, @yet-another-wp-user

    Thank you for your questions.

    I’ve passed them to developers. You’ll be contacted within 48 hours.

    Best regards.

    Moderator Jan Dembowski

    (@jdembowski)

    Forum Moderator and Brute Squad

    @yet-another-wp-user I’ve removed the “[URGENT]” from the topic title. These are volunteer support forums and the plugin support here is also from volunteers and are not company supporters here.

    Yet Another WP User

    (@yet-another-wp-user)

    ^^ Ok. Thanks. I’ll remember this.

    @amagsumov
    I’m waiting for the answer and a fix. It is increasing database size a lot.

    Plugin Author Safronik

    (@safronik)

    Hello,

    That’s odd. Looks like you have very popular website!

    We have made the fix for you. Please, install plugin from here: https://downloads.wordpress.org/plugin/cleantalk-spam-protect.zip
    There is no need to perform any additional actions, just install it.

    Contact us if you have questions.

    Yet Another WP User

    (@yet-another-wp-user)

    ^^ I have few questions before installing the plugin you provided:

    1. The plugin version in your link is 5.118 where as the latest official version of the plugin is 5.117.1. What does it mean? If you release 5.118 version officially in coming days, will it be same as the plugin version provided by you in above post?

    2. What fix does the plugin version contain? Will it drop this extra table from database and will not fill it again as I have no form protection enabled? I only have Spam Firewall enabled.

    3. Will I need to remove existing version before installing this new version or just upload it using plugin upload feature?

    Plugin Support amagsumov

    (@amagsumov)

    1. Yes it will be the same version.

    2. We have increased the probability of cleaning the table.

    3. You can just update the plugin, using plugin upload feature.

    Yet Another WP User

    (@yet-another-wp-user)

    I got following error:

    Destination folder already exists. /public_html/wp-content/plugins/cleantalk-spam-protect/

    Btw I have upgraded to the latest official version 5.117.1 which comes with the fix for following bug reported by me:

    https://wordpress.org/support/topic/bug-store-visited-urls-option-always-enabled/

    Now the option “Store visited URLs” can be turned off. I highly doubt that the option was the culprit behind the huge size table.

    Now I have disabled the option. Can I manually empty or drop the table from database?

    If yes, should I empty or drop the table? If I only using Spam Firewall feature, should I drop the table completely or will the plugin re-create the table?

    Plugin Support SergeM

    (@serge00)

    Hello.

    Please, re-install the plugin like this:
    1. Log in to your Hosting Account.
    2. Locate the folder of your website.
    3. Delete the anti-spam plugin folder “cleantalk-spam-protect” here:
    <WordPress-root-folder>/wp-content/plugins/cleantalk-spam-protect

    Then install the plugin from here:
    https://downloads.wordpress.org/plugin/cleantalk-spam-protect.zip

    Use “Manual Update” section of the guide:
    https://cleantalk.org/help/update-wordpress

    New version of the plugin will delete the table itself.

    Thank you.

    Yet Another WP User

    (@yet-another-wp-user)

    I didn’t try the new plugin version provided by you as I was a little worried about using an unofficial release.

    Following fixed the issue for me:

    1. I manually dropped the “wp_cleantalk_sessions” table from database.
    2. Then I uninstalled and reinstalled latest official version 5.117.1 of the plugin and disabled “Store visited URLs” option.

    Now the plugin no longer creating the table again.

    Plugin Support SergeM

    (@serge00)

    I’m glad the issue is gone now.

    Best wishes.

Viewing 10 replies - 1 through 10 (of 10 total)
  • You must be logged in to reply to this topic.