|
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
|
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
|
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
|
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
|
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
|
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.
|
