I uninstall Amelia plugin from my domain. Now I need to move the web I created to my client server (with Duplicator plugin) and Duplicator gives me the error saying that there is a lot of Amelia staff in my sql data base.
That means that whe you unistall Amelia, it does not do it well and lefts over a lot of staff that it should not. :-(
Because of it, tomorrow my client will have no web and will loose money and will be upset ;-(
Duplicator error:
INSTALL ERROR! DATABASE CREATION FAILURE! Unable to remove table from database "derrick_wpbase.wpms_derrickamelia_appointments". Please remove all tables from this database and try the installation again. If no tables show in the database, then Drop the database and re-create it. ERROR MESSAGE
And look at my data base (with Amelia unistalled):
We're duplicating websites with Amelia at least once a week, and we've never experienced issues with the Duplicator plugin.
When you delete Amelia from your WordPress site, all its tables are still saved in the database. That's been done on purpose, so if someone deletes the plugin to manually update it, they don't lose their data, and have to start over again.
You shouldn't remove tables from the database using the Duplicator plugin because there are over 50 foreign keys in it, and without a user to deselect "Enable foreign key checks", the plugin cannot delete any tables from the database. This is the default behavior of a database, and you cannot delete any table that has foreign key constraints without manually confirming that the foreign key check needs to be skipped.
You can run the installation of the duplicator files without issues, just don't delete the tables through it, but manually.
The web I was duplicating did not use Amelia. I used another booking plugin. Amelia had been installed and removed before. That is why I say that there should not be so many amelia tables in the database. Amelia was installed in my domain, which I use to make webs for clients that later I moved with Duplicator to their domains.
If I do not use Amelia in theirs webs, I think they should not have Amelia tables on their data bases. :-(
I tried to removed them manually but it was not possible. Oh well...
To delete those tables manually, like I said, you need to disable Foreign Key Checks. When you select all 40 Amelia tables, and choose "Drop", you will see a screen like this:
In bottom left, you can see "Enable foreign key checks" check-box. When you un-check it, you can delete the tables without issues.
I am just desperate!
I uninstall Amelia plugin from my domain. Now I need to move the web I created to my client server (with Duplicator plugin) and Duplicator gives me the error saying that there is a lot of Amelia staff in my sql data base.
That means that whe you unistall Amelia, it does not do it well and lefts over a lot of staff that it should not. :-(
Because of it, tomorrow my client will have no web and will loose money and will be upset ;-(
Duplicator error:
INSTALL ERROR!
DATABASE CREATION FAILURE!
Unable to remove table from database "derrick_wpbase.wpms_derrickamelia_appointments".
Please remove all tables from this database and try the installation again. If no tables show in the database, then Drop the database and re-create it.
ERROR MESSAGE
And look at my data base (with Amelia unistalled):
wpms_derrickamelia_appointmentsHi again Isabel
We're duplicating websites with Amelia at least once a week, and we've never experienced issues with the Duplicator plugin.
When you delete Amelia from your WordPress site, all its tables are still saved in the database. That's been done on purpose, so if someone deletes the plugin to manually update it, they don't lose their data, and have to start over again.
You shouldn't remove tables from the database using the Duplicator plugin because there are over 50 foreign keys in it, and without a user to deselect "Enable foreign key checks", the plugin cannot delete any tables from the database. This is the default behavior of a database, and you cannot delete any table that has foreign key constraints without manually confirming that the foreign key check needs to be skipped.
You can run the installation of the duplicator files without issues, just don't delete the tables through it, but manually.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi,
The web I was duplicating did not use Amelia. I used another booking plugin. Amelia had been installed and removed before. That is why I say that there should not be so many amelia tables in the database. Amelia was installed in my domain, which I use to make webs for clients that later I moved with Duplicator to their domains.
If I do not use Amelia in theirs webs, I think they should not have Amelia tables on their data bases. :-(
I tried to removed them manually but it was not possible. Oh well...
I see, Isabel
To delete those tables manually, like I said, you need to disable Foreign Key Checks. When you select all 40 Amelia tables, and choose "Drop", you will see a screen like this:
In bottom left, you can see "Enable foreign key checks" check-box. When you un-check it, you can delete the tables without issues.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables