Thanks for your answer. I am wondering why I get this message when I try to duplicate a sub domain and if I can ignore the foreign keys while duplicating the site?
Apparently the dupplication plugin (Multisite Clone Duplicator) drops some tables in the duplication process. But what foreign keys do exist when it tries to drop the appointments table? I have cleared all my appointments in the database.
We are not familiar with functionality of that plugin, so we are not sure why is not deleted all foreign key tables. That is the question for support of that plugin.
What you can do is to delete all Amelia tables in database manually and then just activate plugin and all tables will be created again.
Also, you can use Plugin Duplicator. We use it and it's working fine, because he will transfer all the files and also the tables to database.
Hello, I would like to copy a subdomain (with associated posts and pages) to another subdomain within my network. However, I get the following error:
ERROR SQL ON : DROP TABLE IF EXISTS `wp_14_amelia_appointments`
WPDB ERROR : Cannot delete or update a parent row: a foreign key constraint fails
Is there anything I can do to prevent this?
Thank you.
Regards,
Stijn Wouters
Hi Stijn,
Thank you for your purcahse.
Sorry for late response.
We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
If you are deleting tables then you need to eneble foreign keys option(in phpmyadmin) or force to be deleted(Sequel pro). (attachments)
Also you can check is your database support foreing keys.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Hello Milan,
Thanks for your answer. I am wondering why I get this message when I try to duplicate a sub domain and if I can ignore the foreign keys while duplicating the site?
Apparently the dupplication plugin (Multisite Clone Duplicator) drops some tables in the duplication process. But what foreign keys do exist when it tries to drop the appointments table? I have cleared all my appointments in the database.
Please advise what I should do.
Kind regards,
Stijn Wouters
Hi Stijn,
We are not familiar with functionality of that plugin, so we are not sure why is not deleted all foreign key tables. That is the question for support of that plugin.
What you can do is to delete all Amelia tables in database manually and then just activate plugin and all tables will be created again.
Also, you can use Plugin Duplicator. We use it and it's working fine, because he will transfer all the files and also the tables to database.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables