|
radiusinvestigations
|
October 16, 2019 at 8:44 am
On the front end of my website there is a huge Event Espresso error that shows up. then I on the backend I have a WordPress database error that shows up-WordPress database error: [Tablespace for table ‘site264960_db.wp_esp_event_question_mailchimp_field‘ exists. Please DISCARD the tablespace before IMPORT]
CREATE TABLE wp_esp_event_question_mailchimp_field ( QMC_ID INT UNSIGNED NOT NULL AUTO_INCREMENT , EVT_ID INT UNSIGNED NOT NULL , QST_ID TEXT NOT NULL , QMC_mailchimp_field_id TEXT NOT NULL , PRIMARY KEY (QMC_ID) ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
Follwed by a lot more. How do I resolve this?
Thank you!
|
|
Josh
|
October 16, 2019 at 9:04 am
Hi,
The error you’re seeing looks like something your web host will need to fix. Here’s a related stack exchange thread that explains more:
http://stackoverflow.com/questions/15694168/error-tablespace-for-table-xxx-exists-please-discard-the-tablespace-before-imp
Can you contact your host and ask them to check the database?
|
|
radiusinvestigations
|
October 17, 2019 at 9:24 am
Hi- thank you for the reply. I got in touch with my hosting and they have resolved the issue but now we have lost all of our data. they tried doing a back up but keep getting this error message- ERROR 1005 (HY000) at line 342: Can’t create table site264960_db.wp_esp_event_mailchimp_list_group (errno: 168 “Unknown (generic) error from engine”)
Do you know what this is and how to fix it?
Thank you!
|
|
Josh
|
October 17, 2019 at 9:29 am
It sounds like they need to update the version of MySQL on the server, and at the very least they could restore a backup excluding that one table. So at the very least you’ll have most of your data back, just not the event’s MailChimp groups.
|
