Support

April 22, 2015 at 11:13 am

For some reason, right before I did the update I got a slew of error messages on my dashboard. They look like this:

Database table wp_esp_answer existed when it shouldn't, and probably contained erroneous data. You probably restored to a backup that didn't remove old tables didn't you? We recommend adding

define( 'EE_DROP_BAD_TABLES', TRUE );
to your wp-config.php file then restore to that backup again. This will clear out the invalid data from wp_esp_answer. Afterwards you should undo that change from your wp-config.php file. 
If you cannot edit wp-config.php, you should remove the data from wp_esp_answer manually then restore to the backup again.

They vary by database table name, the names are as follows:

Database table wp_esp_attendee_meta
Database table wp_esp_country
Database table wp_esp_currency
Database table wp_esp_currency_payment_method
Database table wp_esp_datetime
Database table wp_esp_event_meta
Database table wp_esp_event_question_group
Database table wp_esp_event_venue
Database table wp_esp_extra_meta
Database table wp_esp_line_item
Database table wp_esp_log
Database table wp_esp_message_template
Database table wp_esp_message_template_group
Database table wp_esp_event_message_templat
Database table wp_esp_payment
Database table wp_esp_payment_method
Database table wp_esp_ticket_price
Database table wp_esp_datetime_ticket
Database table wp_esp_ticket_template
Database table wp_esp_question
Database table wp_esp_question_group_question
Database table wp_esp_question_option
Database table wp_esp_registration
Database table wp_esp_checkin
Database table wp_esp_state
Database table wp_esp_status
Database table wp_esp_transaction
Database table wp_esp_venue_meta
Database table wp_esp_price
Database table wp_esp_price_type
Database table wp_esp_ticket
Database table wp_esp_question_group

I have not restored anything – so I am not sure why this message is being posted. It doesn’t seem to have affected the functions of EE – as it is still working as it should – so I am not sure what these errors are about. I am afraid to delete anything or add this code in where it says to add it because it seems odd that this would happen out of the blue.

I went ahead this morning and updated the plugin hoping that the error messages would go away but they did not =( Help!

Here is my system info:

WordPress Version: 4.1.2
PHP Version: 5.3.29
MySQL Version: 5.6.17
Event Espresso Version: 4.6.22.p
WordPress Address (URL): http://ravenmoonemporium.com
Site address (URL): http://ravenmoonemporium.com