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:


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.


  • 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.


  • 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:

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.

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


  • 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

Joseph Martin

October 3, 2017 at 1:13 pm

I could not find that option in the wp_options table


  • 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:

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, 8 months ago ago

Topic Tags



This topic is: not resolved
Do NOT follow this link or you will be banned from the site!