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.
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.
Viewing 2 reply threads
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.
Support forum for Event Espresso 3 and Event Espresso 4.