Support

Home Forums Event Espresso Premium WPDB Error: EE4upgrade.wp_esp_promotion_object doesnt exist

WPDB Error: EE4upgrade.wp_esp_promotion_object doesnt exist

Posted: January 13, 2020 at 6:28 am


Ian Taylor

January 13, 2020 at 6:28 am

Hi there,

I’m getting this message on Event Espresso when I try to set up a promotional code.

An EE_Error exception was thrown! code: EEM_Base - _do_wpdb_query - 2311
"WPDB Error: "Table 'unrestri_EE4upgrade.wp_esp_promotion_object' doesn't exist""
click to view backtrace and class/method details
/home/unrestri/public_html/wp-content/plugins/event-espresso-core-reg/core/db_models/EEM_Base.model.php ( line no: 2311 )


Josh

  • Support Staff

January 13, 2020 at 7:22 am

Hi Ian,

You can go to your site’s WordPress > Plugins page, then deactivate the Event Espresso > Promotions add-on, then reactivate it. The missing table will then be added back into the database.

If you’ve been using promotions prior to this, you might also want to restore the missing table from a database backup. If you do have a database backup you can extract that table from the backup and import it onto the site using a tool like phpmyadmin.


Ian Taylor

January 14, 2020 at 6:43 am

This reply has been marked as private.


Josh

  • Support Staff

January 14, 2020 at 7:17 am

In this case you’ll need to contact your host and forward the error message. They’ll likely need to delete or rename the wp_esp_promotion_object.ibd file, then restart the database server.

In case they need it, there is more information about the error in this stackoverflow thread:

https://stackoverflow.com/questions/15694168/error-tablespace-for-table-xxx-exists-please-discard-the-tablespace-before-imp


Ian Taylor

January 15, 2020 at 8:26 am

Thanks Josh. The host is seeming quite reluctant to remove the ibd file because it could pose risk to other users on the server – I guess because the file is not within the account’s container.

Is there any other workaround/fix for this?

Joe


Josh

  • Support Staff

January 15, 2020 at 8:47 am

There are other ideas for how to solve in the stackoverflow thread I linked to.


Ian Taylor

January 15, 2020 at 1:37 pm

Hi Josh, we convinced the host to remove the file and then it came back… I think we’re going to have to find the source of the issue and fix that before removing the file…


Josh

  • Support Staff

January 15, 2020 at 1:55 pm

Did they check the database logs? The stackoverflow thread mentions a few possibilities of why the error can happen.


Ian Taylor

January 20, 2020 at 12:00 pm

This reply has been marked as private.


Ian Taylor

January 20, 2020 at 12:55 pm

Hi,

Another few reported issues: A blank error message on successful checkout and e-mails don’t seem to be sending out.


Josh

  • Support Staff

January 20, 2020 at 1:12 pm

Hi,

That’s the same error that was shared here earlier. The promotions add-on should be left deactivated until this can be fixed.

Can you check the version of the database server? That can be found in your site’s Tools > Site Health page.

You must be logged in to reply to this support post. Sign In or Register for an Account

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: publish

Updated by  Josh 12 hours, 7 minutes ago ago

Topic Tags

Notifications

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