Support

Home Forums Event Espresso Premium update error Database table wp_esp_registration_payment exists when it shouldn't

update error Database table wp_esp_registration_payment exists when it shouldn't

Posted: January 7, 2016 at 11:33 am


Michael

January 7, 2016 at 11:33 am

Hi,
To update from 4.7.4 to 4.8.29, I used WPEngine’s staging environment to test the update. I created a new copy of my site, then disabled EE, then deleted it, then used the WP Plugin installer to upload 4.8.29.

The EE database migration tool completed without errors, but after clicking Next following migration, I encounter this error:

Database table wp_esp_registration_payment 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 );
to your wp-config.php file then restore to that backup again. This will clear out the invalid data from wp_esp_registration_payment. 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_registration_payment manually then restore to the backup again

I’m wondering if I should use these instructions on my live site, then create a copy, then test the update again?

Thanks


Lorenzo Orlando Caum

  • Support Staff

January 7, 2016 at 12:35 pm

Hi Michael,

redacted – Event Espresso support team – LOC


Lorenzo


Michael

January 7, 2016 at 12:45 pm

If I delete the table, then how will it migrate?


Lorenzo Orlando Caum

  • Support Staff

January 7, 2016 at 12:46 pm

Hi Michael,

wp_esp_registration_payment should not actually be there. That is the issue that it is reporting.


Lorenzo


Michael

January 7, 2016 at 12:58 pm

sorry, could you explain a bit more? I have hundreds of rows of data there.


Lorenzo Orlando Caum

  • Support Staff

January 7, 2016 at 1:13 pm

Hey Michael, we made a mistake on the prior steps. Do not delete anything.

Please go ahead and backup your site while I get clarification between 4.7 and 4.8


Lorenzo


Michael

January 11, 2016 at 11:59 am

Hi Lorenzo, and ideas about an upgrade path from 4.7 to 4.8? thanks


Lorenzo Orlando Caum

  • Support Staff

January 11, 2016 at 1:37 pm

Hi Michael,

We corrected the issue last Thursday in a pending maintenance release. We don’t currently release at the end of the week so this will likely go out tomorrow.

A team member will update this support post once that version is out and at that time, you can try your original steps of pull live into staging and then updating with the maintenance release (e.g. 4.8.30).

Thanks again!


Lorenzo


Michael

January 11, 2016 at 1:38 pm

That was impressively fast. Thank you.


Tim Monk

January 12, 2016 at 9:02 am

Just migrated and updated and getting this message so what is the final outcome please? Wait for another release?


Michael

January 12, 2016 at 9:05 am

I’m waiting for the new release, 4.8.30, and will be testing the migration and update before making it live.


Josh

  • Support Staff

January 13, 2016 at 5:12 pm

Hi Michael,

Event Espresso 4.8.30.p was released today and it includes the fix for the wp_esp_registration_payment exists when it shouldn’t issue.


Michael

January 14, 2016 at 6:54 am

works like a charm! thanks


Tony

  • Support Staff

January 14, 2016 at 7:12 am

Thank you keeping us updated, Michael 🙂

If you have any further problems please let us know.

The support post ‘update error Database table wp_esp_registration_payment exists when it shouldn't’ 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