Re: Double release: 5.3.1 and 5.2.16, XC4 to XC5 Migration Wizard, New Developer Portal
Very glad I did not run this upgrade on my live store!
I created a development copy under /dev, copied the database, everything seems to be working okay. When I try to upgrade core only from 5.2.15 to 5.2.16, I get stuck at step 5:
Deploying store [step 5 of 13], please wait...
Run the "Doctrine_Plugin_UpdateSchema" plugin...
Error
ERROR: "0" (code N/A)
An exception occurred while executing 'ALTER TABLE `xc_profiles` ADD CONSTRAINT FK_564F69D78D9F6D38 FOREIGN KEY (order_id) REFERENCES xc_orders (order_id) ON DELETE CASCADE': SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ocha_xcDev`.`#sql-42dd_2fc3`, CONSTRAINT `FK_564F69D78D9F6D38` FOREIGN KEY (`order_id`) REFERENCES `xc_orders` (`order_id`) ON DELETE CASCADE)
Deleting /var/run and .rebuildMark, .rebuildStarted is all to no avail.
Any ideas?
__________________
X-Cart 5.4.1.39 Live
PHP 7.4.33
5.5.5-10.3.38-MariaDB MariaDB
Apache 2.4
CENTOS 7.8 64Bit Single Quad-Core E3-1241v3 3.4Ghz 8M 1600 w/ HT
32GB RAM 2x 512GB Samsung 850 Pro SSD RAID 1
|