|
Joseph Martin
|
October 2, 2017 at 9:34 am
I’m getting thousands of entries in the wp_options table. All of the loggins options are turned off in the Debug/Logging Options section.
Examples of entries:
_transient_ee_ssn_3b248a4270f6fb5cef7f596a2046da11
_transient_timeout_ee_ssn_58f0555de889a30d95f27e5020a2fbf0
|
|
Joseph Martin
|
October 2, 2017 at 9:42 am
I checked forums and saw mentions of the Shopp plugin. I am not using this plugin.
|
|
Josh
|
October 2, 2017 at 10:07 am
Hi Joseph,
Those entries are actually supposed to be there, but only for a short period of time. They are used as keys to connect the registration data to the current registration session.
|
|
Joseph Martin
|
October 2, 2017 at 10:53 am
It looks like they are staying there permanently. Table currently has 102379 total rows and is growing. This is not a very busy site.
|
|
Josh
|
October 2, 2017 at 11:06 am
If they’re not getting deleted then that’s an indication that wp_cron() is deactivated on your website. If you install the WP Crontrol plugin:
https://wordpress.org/plugins/wp-crontrol/
then go to Tools > Cron Events you can see a list of scheduled tasks. If you can check that page can you see if there are any messages that indicate “WP-Cron spawning is disabled.”?
|
|
Joseph Martin
|
October 2, 2017 at 11:47 am
I installed plugin and everything looked okay. I did see one item set to Non-repeating. Here’s a screen shot of that section also.
https://www.screencast.com/t/vyTzyM38
AHEE__EE_Cron_Tasks__expired_transaction_check [72879] EE_Cron_Tasks::expired_transaction_check() 2017-10-02 14:35:53 (55 minutes 23 seconds) Non-repeating
|
|
Josh
|
October 2, 2017 at 12:12 pm
That particular task is for removing a single transaction item if the registration is abandoned before the registration form is submitted. (in this case, transaction ID 72879). Since a single specific transaction can only be deleted only one time, it’s a non-repeating task.
Does your wp_options table have an option where its option_value is
ee_transient_schedule?
|
|
Joseph Martin
|
October 3, 2017 at 1:13 pm
I could not find that option in the wp_options table
https://www.screencast.com/t/o1DhOrZPUPB3
|
|
Josh
|
October 3, 2017 at 1:28 pm
I think you’d need to search by option_name to find that particular option.
In any case you can install this plugin:
https://wordpress.org/plugins/transients-manager/
Then go to WP > Tools > Transients, then click on the “Delete Expired Transients” button.
|
