|
ElyFolkSchool
|
April 24, 2017 at 3:33 pm
WordPress database error: [Table ‘elyfolks_wrdp1.wp_esp_promotion’ doesn’t exist]
I have deleted the plugin and reinstalled using the download from here and still a whole page of errors. Table does not exist, even when I reinstall it.
|
|
Tony
|
April 25, 2017 at 7:52 am
Hi there,
The problem is there is either no wp_esp_promotion table in your database or for some reason, EE can not create/access the table.
Reinstalling the plugin would normally tell EE to check the tables and create them if they don’t exist, but something is preventing that.
Have you previously used the Promotions add-on or is this the first time you have installed it?
|
|
ElyFolkSchool
|
April 25, 2017 at 7:58 am
I’ve been using it for some time. Using an important promotional code so need it to be fixed asap.
|
|
Josh
|
April 25, 2017 at 7:59 am
Hi there,
The error message indicates that the database user’s permissions are not allowing WordPress to create any new tables. So while WP may be able to write to the existing tables, WP cannot create new tables. This issue will occur with any new WordPress plugin you may try to install or run an update where a new table needs to be added.
Can you or the server administrator check to make sure that the database user has the permission to create new database tables? This is a note in the WordPress codex that explains this further:
Note: Some plugins, themes and major WordPress updates might require to make database structural changes, such as add new tables or change the schema. In such case, before installing the plugin or updating a software, you will need to temporarily allow the database user the required privileges.
http://codex.wordpress.org/Hardening_WordPress#Restricting_Database_User_Privileges
|
|
ElyFolkSchool
|
April 25, 2017 at 8:40 am
My host says: They’re trying to use the collation utf8mb4_unicode_ci with what they’re doing but we dont’ use that we use utf8mb4_general_ci
|
|
Josh
|
April 25, 2017 at 9:54 am
I think there may be some misunderstanding here. Event Espresso doesn’t set the database collation for the tables, and it does not require using utf8mb4_unicode_ci. Did this site happen to get migrated from one host to another?
|
|
ElyFolkSchool
|
April 25, 2017 at 10:01 am
No, it hasn’t moved, but I did have a lot of server issues last week and the db corrupted at least twice. Can I send my login info for you to fix? I have an hour of support time.
|
|
Josh
|
April 25, 2017 at 10:05 am
I don’t think this is something that we can fix. Can the server admin fix this? Generally if there are server issues where the database gets corrupted that needs to be fixed on the server side, not the software side.
|
|
Josh
|
April 25, 2017 at 10:28 am
You may also want to share this recommendation with your host:
https://pento.net/2014/04/07/wordpress-and-utf-8/#comment-33606
|
|
ElyFolkSchool
|
April 25, 2017 at 12:22 pm
According to my host, the db is ok now. They are pointing at you. You are pointing at them. I just need the problem fixed. Host says nothing wrong with db, no issues server-side. I’ll pay. I just need it fixed.
|
|
Josh
|
April 25, 2017 at 12:59 pm
I’m not pointing at your host, but the fix isn’t something we can do through changes to the software. Do you have a backup of the database before if was corrupted that can be used to restored the esp_promotions table?
It would also be a good question to ask the host why was the collation ever set to “utf8mb4_unicode_ci”? Event Espresso doesn’t set that collation. Again, I’m not pointing a finger at the host, but having a mixed collation on the database is an issue that should get resolved on the server’s side or you’ll continue to run into problems like this. So any fix or restore to the database could be temporary at best.
|
|
ElyFolkSchool
|
April 25, 2017 at 1:05 pm
You asked if the site had been migrated? Well, I am in the process of moving and the other host had a migration in process at one point. I am still operating on the old host with this problem, but could it have been caused by whatever the new host did to migrate the account?
|
|
Josh
|
April 25, 2017 at 2:06 pm
If the new host made changes to the database collation on the old host server, absolutely.
|
|
ElyFolkSchool
|
April 25, 2017 at 2:33 pm
I can’t imagine they did anything but zip up the account using cpanel. I’m sure they made no changes to anything on the account.
|
|
Josh
|
April 25, 2017 at 2:48 pm
I get that the host says there’s nothing wrong with the database, but they also said that some of the fields in the database were trying to use a collation that they don’t support. That’s actually something that’s wrong with the database.
|
|
ElyFolkSchool
|
April 26, 2017 at 10:32 am
Is there a way to manually remove anything having to do with the Promotions plugin from the database so that I can reinstall it and maybe it will work?
|
|
Josh
|
April 26, 2017 at 10:35 am
You can restore the esp_promotions table from an earlier backup of the database.
|
