Database filled with _yith_ywraq_session_, _yith_ywraq_session_expires_

I just checked one of our other sites and it had the same problem the _options table was filled with over 300,000 lines of _yith_ywraq_session values. The database was HUGE.

Is this problem going to get fixed?

I ran an SQL query to clear the values out, but they keep coming back. Your code should really clean up after itself! A simple wp-cron job would do the trick.

If this doesn’t get fixed this plugin is getting uninstalled and we will definitely NOT be purchasing the premium version!

Hi Peter,
this fix will be released in the next update.
Thank you for your feedback

YITHEMES

Excellent. Thank you. Looking forward to it.

can you provide solution ?

how can we delete that

_yith_ywraq_session_

values from wp_option table

I’ve installed the latest version, waited a couple of days and I still have 88,170 rows of _yith_ywraq_session_ and _yith_ywraq_session_expires in my options table. Can I look forward to your plugin cleaning this up, or will I have to do it manually?

Yes, it doesn’t look like that update ever fixed anything. Our tables still fill up with those garbage values.

Every week we have to go in and clear them out.

In case somebody needs it, here’s the SQL command to clear them out:

DELETE FROM wp_options WHERE option_name LIKE (‘_yith_ywraq_session_%’)

NOTE: You’ll need to change wp_options to whatever that TABLE name is if you’re using a different prefix

Not sure how to get those backticks in there.

wp_options and option_name are supposed to be enclosed in backticks for the proper SQL command

Thanks Peter,

Your answer is greatly appreciated.

I would also love to have this issue resolved in the plugin itself or at the very least be able to setup up regular cron jobs to handle it … doing research into that now … learning as I go.

Seems like the plugin author is filled with empty promises.

I guess there’s not many people that have this plugin installed or at least the people that do don’t realize that the size of their database is constantly increasing at a frightening rate.

I suppose if we’d gone for the paid version of this plugin, the author may actually do something about it.

For one of our sites we decided to scrap this poorly written one and purchase the A3Rev Quotes & Orders plugin – a bit pricey, but an excellent and flexible plugin for managing Quote Requests.

Hi @all,
the version 1.2.3 remove daily the old sessions.

NOT TRUE.

The latest version did NOT fix this. I still have to go in and periodically clean out the tables with those garbage values.

If you make this claim make sure it’s true!

I found that the latest update DID resolve this issue.

Appreciation to the plugin author for this fix.

@peter, I also appreciated your solution to manually clean the database while this was being handled. Thank you.