Support

Home Forums Event Espresso Premium Thousands of database entries in wp_options

Thousands of database entries in wp_options

Posted: October 2, 2017 at 9:34 am


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

  • Support Staff

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

  • Support Staff

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

  • Support Staff

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

  • Support Staff

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.

The support post ‘Thousands of database entries in wp_options’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Support forum for Event Espresso 3 and Event Espresso 4.
Documentation for EE3 and EE4
Documentation for Event Espresso 3

Documentation for Event Espresso 4

Status: closed

Updated by  Josh 2 years, 1 month ago ago

Topic Tags

Tagged: 

Notifications

This topic is: not resolved
Do NOT follow this link or you will be banned from the site!
[for="input_96_5_3"]
[for="input_96_5_3"]
[gravityform id=96 title=false description=false]
  • This field is for validation purposes and should be left unchanged.
[i]
[i]
[gravityform id=69 title=false description=false]
  • This field is for validation purposes and should be left unchanged.