Support

Home Forums Event Espresso Premium Error Messages galore!

Error Messages galore!

Posted: April 22, 2015 at 11:13 am


Raven Moon Emporium

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


Lorenzo Orlando Caum

  • Support Staff

April 22, 2015 at 2:02 pm

Hi, that may appear shortly after an update when old information is found.

Does it let you dismiss the message?


Lorenzo


Raven Moon Emporium

April 22, 2015 at 2:11 pm

Yes it did – so I don’t have to do anything?


Lorenzo Orlando Caum

  • Support Staff

April 23, 2015 at 12:37 pm

Thanks for the update. Could you also update to the newer version and let us know if it appears?

http://eventespresso.com/wiki/ee4-changelog/


Lorenzo


winuk

April 26, 2015 at 3:02 pm

I am getting this too and have just upgraded to version 4.6.23.p but the error messages still persist… I can dismiss them but was very worried when the whole screen filled up with these…

here’s a screenshot of the scary errors:
DB error messages


winuk

April 26, 2015 at 3:04 pm

Sorry – the URL for the image seems to have copied incorrectly. Here’s the screenshot:

https://www.dropbox.com/s/5zqeca9kivwu2sj/EE%20DB%20errors.png?dl=0


Dean

April 27, 2015 at 5:56 am

Hi Word International,

What version of Event Espresso did you upgrade from? While it’s safe to dismiss those, I’d like to see if there’s a reason so many appeared and if there’s a better way we can handle it going forward.


winuk

April 27, 2015 at 9:41 am

Hi Dean,

Sorry – I didn’t note this down… Is there a way for me to look in the DB maybe to see this?

Thanks

Kenneth


Lorenzo Orlando Caum

  • Support Staff

April 27, 2015 at 10:02 am

Hi Kenneth,

I have an idea on what may have happened but its not definitive.

Did you try Event Espresso 4 (older platform like 4.2.x or 4.4.x) in the past and then switch back to Event Espresso 3 and then you recently upgraded to Event Espresso 4 again?


Lorenzo


Tony

  • Support Staff

April 27, 2015 at 11:15 am

Hi everyone,

There is a way to find all of this information, without looking in the database 🙂

If you go to Event Espresso -> Maintenance -> System Information.

You’ll see a lot of information on display (version history, active add-ons, server config etc)

Here’s an example of one of my test sites – http://take.ms/zPeiy

Could you send us that information? Theres a couple of ways to do that, with that page open can you either, save all of the details within the Raw Data section (right click -> Select All -> Copy)

Paste that within a txt file and email that to us as support[at]eventespresso.com

OR

With that page open do save as within your browser to save the full page, then send us that…

OR

If you prefer for one of us to log in and grab the data, please send temporary log in details using this form:

https://eventespresso.com/send-login-details/


winuk

April 28, 2015 at 4:46 am

Hi Tony,

I have emailed the information just now.

Let me know if there is anything else you need.

Thanks

Kenneth


Tony

  • Support Staff

April 28, 2015 at 6:12 am

Thank you, Kenneth.

I have passed the information over to our developers to see if they can see anything strange for us to investigate further.

I would recommend creating a backup of the database (just to be safe) whilst we investigate this.

There are many plugins available to do this, I use:

https://wordpress.org/plugins/backupwordpress/

Although there are many more, he’s a run down of some of the most popular ones:

http://www.wpbeginner.com/plugins/7-best-wordpress-backup-plugins-compared-pros-and-cons/

The support post ‘Error Messages galore!’ 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.
Documentation for EE3 and EE4
Documentation for Event Espresso 3

Documentation for Event Espresso 4

Status: closed

Updated by  Tony 4 years, 5 months ago ago

Topic Tags

Notifications

This topic is: not resolved
Do NOT follow this link or you will be banned from the site!