|
Rob Betz
|
June 4, 2024 at 3:22 am
Our site went down last night and I had to implement a database repair. The error log shows Event Espresso in several entries over the last few days and I’m not sure how to proceed. Any help would be appreciated. Site is up and running now but I’m unsure of any impact as yet.
Error message this morning:
[04-Jun-2024 00:34:13 UTC] WordPress database error Table ‘./mybluek0_dXtBxbD/wp_options’ is marked as crashed and last (automatic?) repair failed for query SELECT option_value FROM wp_options WHERE option_name = ‘ee_pers_admin_notices’ LIMIT 1 made by 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
|
|
Tony
|
June 4, 2024 at 4:30 am
Hi there,
The error log shows Event Espresso in several entries over the last few days and I’m not sure how to proceed.
Are those entries all matching the error you posted above?
There was/is an issue with the option we use to store admin notices on your site, the above doesn’t show what that could be as its likely ‘after’ the issue was caused.
Do you have PHPMyAdmin access or similar?
If so go to the wp_options table, on the search tab in option_name set ee_pers_admin_notices, like this:
https://monosnap.com/file/9orpqRy817cXgj7VoXiWKw2xL0NdbW
What value do you get returned for that?
|
|
Rob Betz
|
June 4, 2024 at 7:05 am
a:13:{s:30:”php_version_5-4-44_recommended”;a:4s{s
then it cuts off. Won’t let me copy.
|
|
Tony
|
June 4, 2024 at 8:41 am
Double click on the field and it’ll open up the value so you can copy it all.
|
|
Rob Betz
|
June 4, 2024 at 10:43 am
Did that come through? It keeps saying “You already said that” but I do not see my copy and paste.
|
|
Rob Betz
|
June 4, 2024 at 10:48 am
It’s not letting me paste the result. Keeps telling me “It looks like you already said that!” and just not updating the thread.
|
|
Rob Betz
|
June 4, 2024 at 11:01 am
I put the full text of the result on this page
https://www.giboardreview.com/event-espresso-error-log-from-myphpadmin/
|
|
Tony
|
June 5, 2024 at 7:51 am
Ok, so those values aren’t needed.
You mentioned you ran a database repair, but your wp_options table is still marked as crashed. Which tables did you previously run repair on?
What I would do here is make a full database backup (export the entire database using PHPMyAdmin).
Then empty the above ee_pers_admin_notices option (just work through the same steps you went through above, double click on the field to edit, hit backspace and then click out of the field to update it).
Export just the wp_option table as a backup (again just to be safe).
Then run a repair on the wp_options table, to do that within PHPMyAdmin, view the Database itself (structure tab show all tables), click the checkbox next to just wp_options and then in the dropdown down the bottom of the list, select Repair table: https://monosnap.com/file/UNAVTrjfYe4xaBLbcIAmjtjJKbCnIQ
|
|
Rob Betz
|
June 5, 2024 at 12:34 pm
Done. Result message was “Your SQL query has been executed successfully.”
mybluek0_dXtBxbD.wp_options
Status OK
|
|
Tony
|
June 5, 2024 at 12:58 pm
Great!
So, now are any errors being thrown?
|
|
Rob Betz
|
June 6, 2024 at 3:21 am
None that I can see
|
|
Tony
|
June 18, 2024 at 9:03 am
Hi there,
Just checking in to confirm if you’ve had any issues since or is it all still working as expected now?
|
|
Rob Betz
|
June 18, 2024 at 9:09 am
Hi Tony,
No issues; your suggestions seem to have worked, thank you. Apologies for not following up sooner, this happened right before a few days off from work.
|
|
Tony
|
June 18, 2024 at 9:11 am
No problem, I just wanted to confirm before our system automatically closed out your ticket 🙂
Let me know if you run into any more issues.
|
