Support

Home Forums Event Espresso Premium How to delete wrong data table from previous installation?

How to delete wrong data table from previous installation?

Posted: February 5, 2015 at 7:27 am


Lois Wallenhorst

February 5, 2015 at 7:27 am

When I upgrated from the free decaf version to the new 4.6 version something went wrong. Not I get this erros message in all my EE tabs:

Fatal error: Access level to EE_Admin_List_Table::single_row_columns() must be public (as in class WP_List_Table) in /home1/pfbryan/public_html/resilientphilanthropy.net/wp-content/plugins/event-espresso-core-reg/core/admin/EE_Admin_List_Table.core.php on line 680

Then in the dashboard I get this message:

from Database table wp_2i45u8_esp_payment_method 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_2i45u8_esp_payment_method. 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_2i45u8_esp_payment_method manually then restore to the backup again.

I added the code to my config-wp.php file but i dont know how to remove the bad tables, I didnt made a backup before installing the new EE version. Please help! is any way I can manually remove those tables? how? Sorry i am notgood at managing databases


Tony

  • Support Staff

February 5, 2015 at 7:35 am

Hi Lois,

Can you tell me which version number of WordPress are you using?

To note, it is good practice (and often essential) that you backup at least your database, although a full site backup would be recommended, whenever you run ANY updates. This is not just with Event Espresso but all plugins/themes/WP updates.

If/when things go wrong this can sometimes be your besat hope to back up and running quickly.

There are multiple options for WordPress backups however here is one of the plugins I use:

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

So… before going any further, I would highly encourage you to make a full site backup.

The support post ‘How to delete wrong data table from previous installation?’ 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.

Event Espresso