Support

Home Forums Event Espresso Premium Database crash from event espresso table

Database crash from event espresso table

Posted: April 13, 2015 at 1:00 pm


Stephanie Azaria

April 13, 2015 at 1:00 pm

Hello- My website was crashing until I deactivated event espresso. here is what hours of my host and developer found:

I am very sorry to hear that you continue to experience problems with your WordPress website at http://www.thecosmicpath.com. I’ve been looking into this to see what we can do to help.

What I have found is that the table ‘wp_esp_line_item’ in the database ‘thecosn5_cosmicpath_wp_live’ contains 915,802 rows. This is way, way more than there should be, and is likely what is causing all of these issues you’ve been encountering on your site.

I was able to find the cause of the problem, which is Event Espresso, and pinpoint it to an exact table. This should be enough information for the developers of that plugin to get the problem fixed for you. It is a paid product, so they should be able to figure out why their code is creating a table so large, and get it fixed for you.

Thanks,

Gary S.
Technical Support
Hostnine

FROM MY DEVELOPER:
It might be related to expresso trying to ‘upgrade’ or ‘update’ the database.

[13-Apr-2015 04:53:28 UTC] WordPress database error Incorrect key file for table ‘./thecosn5_cosmicpath_wp_live/wp_options.MYI’; try to repair it for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘espresso_db_update’, ‘a:0:{}’, ‘no’) ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload) made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), call_user_func_array, EE_System->detect_activations_or_upgrades, EE_System->detect_if_activation_or_upgrade, EE_System->fix_espresso_db_upgrade_option, add_option

I have events coming up this weekend and need this tended to imediately. I have purchased a support token to expedite the matter.

Kim, webmaster for thecosmicpath.com


Lorenzo Orlando Caum

  • Support Staff

April 13, 2015 at 1:25 pm

Hi Kim, I’m discussing your issue with a developer and I’ll follow up privately in a few minutes. The next reply will arrive as a separate email.

Thanks


Lorenzo


Josh

  • Support Staff

June 19, 2015 at 10:06 am

Hi Kim,

I haven’t been following the emails from Lorenzo, but I wanted to make sure you and everyone else knows that Event Espresso 4.7.2 adds garbage collection so it will automatically remove the garbage line items.

The support post ‘Database crash from event espresso table’ 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.

Event Espresso