|
Biebob
|
January 31, 2018 at 6:45 am
Hi,
My website is offline and I can’t get it back. I get this error in the log files. I’m running PHP 7. How to solve
site/wp-includes/wp-db.php on line 1924\nPHP message: WordPress database error Commands out of sync; you can’t run this command now bij query SELECT option_value FROM wp_options WHERE option_name = ‘ee_pers_admin_notices’ LIMIT 1 gemaakt door shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, EventEspresso\\core\\services\\notifications\\PersistentAdminNoticeManager->registerAndSaveNotices, EventEspresso\\core\\services\\notifications\\PersistentAdminNoticeManager->getPersistentAdminNoticeCollection, EventEspresso\\core\\services\\notifications\\PersistentAdminNoticeManager->retrieveStoredNotices, get_option\n’
[Wed Jan 31 14:16:57.674959 2018] [error] [pid 3484] mod_proxy_fcgi.c(848): [client 162.158.234.21:30619] AH01071: Got error ‘PHP message: PHP Fatal error: Maximum execution time of 30 seconds exceeded in /data/sites/web/www/site/wp-includes/taxonomy.php on line 211\n’
|
|
Josh
|
January 31, 2018 at 7:56 am
Hi there,
Here’s how to solve:
http://www.wpbeginner.com/wp-tutorials/how-to-fix-fatal-error-maximum-execution-time-exceeded-in-wordpress/
|
|
Biebob
|
January 31, 2018 at 8:26 am
Hi,
We had an execution time of 300, so this was not the fix. The fix is that your database tables/queries are to slow if the site has a lot of visitors. We fixed it by doing this:
alter table wp_esp_line_item add index(LIN_parent);
This makes it a lot faster.
|
|
Josh
|
January 31, 2018 at 8:32 am
You could have avoided having to add the indexes yourself if you had updated to the current version of Event Espresso. You’ll note that in the last update that and other indexes were added to the esp_line_item table:
https://github.com/eventespresso/event-espresso-core/commit/87aa5de9bb799b1fe4bdfba1c233a8a4e401c092
|
|
Biebob
|
January 31, 2018 at 8:36 am
Hi, we don’t update every day and we were unable to access the website, so we had to do this manual. The fix is only 2 days old.
|
|
Josh
|
January 31, 2018 at 8:47 am
You still could have manually updated without accessing the website.
https://eventespresso.com/wiki/how-to-upgrade-event-espresso/#ee4_manual_update
|
