I realise i asked you this already. I now have a problem.
I copied the 47 tables using php-admin which created a PHP file. When I ran the file, I got this error:
--
ALTER TABLE `bb_amelia_appointments` ADD CONSTRAINT `bb_amelia_appointments_ibfk_1` FOREIGN KEY (`serviceId`) REFERENCES `bb_amelia_services` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `bb_amelia_appointments_ibfk_2` FOREIGN KEY (`providerId`) REFERENCES `bb_amelia_users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `bb_amelia_appointments_ibfk_3` FOREIGN KEY (`parentId`) REFERENCES `bb_amelia_appointments` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `bb_amelia_appointments_ibfk_4` FOREIGN KEY (`locationId`) REFERENCES `bb_amelia_locations` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
MySQL said:
#1452 - Cannot add or update a child row: a foreign key constraint fails (`resaloza`.`#sql-alter-1d6-ada0`, CONSTRAINT `bb_amelia_appointments_ibfk_4` FOREIGN KEY (`locationId`) REFERENCES `bb_amelia_locations` (`id`) ON DELETE SET NULL ON UPDATE CASCADE)
We do not do migrations, that is not our area of expertise. The advice we gave you is proven and has helped hundreds of clients. But if something is not done well in the migration process, we really cannot know what is because we do not work with migrations with it. You can either try again or check with your web developer or hosting provider.
When you export your database to your hosting provider, they should be able to transfer it and upload it to your site.
If you have any more questions in regard to the Amelia plugin please open another ticket and we will gladly help you there.
Hi there.
I have developed a replacement site for bespokeauctions.co.uk which is currently hosted at staging.bespokeauctions.co.uk.
Please can you advise how i can move my customers and appointments to the new site.
Thanks.
I realise i asked you this already. I now have a problem.
I copied the 47 tables using php-admin which created a PHP file. When I ran the file, I got this error:
MySQL said:
#1452 - Cannot add or update a child row: a foreign key constraint fails (`resaloza`.`#sql-alter-1d6-ada0`, CONSTRAINT `bb_amelia_appointments_ibfk_4` FOREIGN KEY (`locationId`) REFERENCES `bb_amelia_locations` (`id`) ON DELETE SET NULL ON UPDATE CASCADE)
Can you help please?
Hello Martin,
Thank you for reaching out to us.
We do not do migrations, that is not our area of expertise. The advice we gave you is proven and has helped hundreds of clients. But if something is not done well in the migration process, we really cannot know what is because we do not work with migrations with it. You can either try again or check with your web developer or hosting provider.
When you export your database to your hosting provider, they should be able to transfer it and upload it to your site.
If you have any more questions in regard to the Amelia plugin please open another ticket and we will gladly help you there.
We wish you all the best.
Kind Regards,
Marko Davidovic [email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps, floor plans, choropleth maps, and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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