|
cvadev
|
July 28, 2016 at 1:03 pm
I have multiple errors which are all similar in that they claim a table shouldn’t exist. We have not tried to update any plugins, wordpress, or tried restoring backing up or migrating the website. So, I’m not exactly sure how these errors occurred.
Coincidentally, I had a backup of this website running on a different server with identical WP version and plugin versions and this site does not have those errors.
The exact error is as follows:
Database table {DB_PREFIX}_esp_answer exists when it shouldn’t, and may contain erroneous data. If you have previously restored your database from a backup that didn’t remove the old tables, then we recommend adding
define( ‘EE_DROP_BAD_TABLES’, TRUE );
Where {DB_PREFIX} is the prefix we’re using for our DB tables.
This message is repeating for the following tables
1. answer
2. meta
3. country
4. currency
5. current_payment_method
6. datetime
7. event_meta
8. event_question_group
9. event_venu
10. extra_meta
11. line_item
12. esp_log
13. message_template
14. message_template_group
15. event_message_template
16. payment
17. payment_method
18. ticket_price
19. datetime_ticket
20. question
21. question_group_question
22. question_option
23. registration
24. registration_payment
25. checking
26. state
27. status
28. transaction
29. venue_meta
30. price
31. price_type
32. ticket
33. question_group
My current version of EE is Version 4.8.38.p
Current version of WP 4.4.4
What would be the best way of fixing this error? Would an update to EE be the first step? or possibly a WP update? I don’t want to corrupt any tables or data, as there are already many tickets we’ve sold across various events.
Thanks, if you’ve made it this far!
|
|
Josh
|
July 28, 2016 at 2:30 pm
The way to deal with that error you saw is you dismiss it. Then you back up the database, then you can run an update to the current version of EE4.
|
|
cvadev
|
July 28, 2016 at 2:31 pm
Thanks Josh, I’ll give it a shot!
|
|
cvadev
|
August 9, 2016 at 9:15 am
For future reference, this was solved by:
1. Dismissing all errors
2. Backed up Database
3. Updated EE4 and all of its plugins
5. Backed up database before using compatibility tool in EE.
6. Ran the compatibility tool that EE4 provides
|
|
Lorenzo Orlando Caum
|
August 9, 2016 at 1:35 pm
Hello,
Thanks for sharing how you got back on track. Note that the Requirements check plugin doesn’t change your existing Event Espresso data.
It runs some quick tests to identify any potential issues such as missing PHP modules that Event Espresso may need to operate.
—
Lorenzo
|
