View Single Post
  #25  
Old 08-09-2016, 11:14 PM
 
kevinrm kevinrm is offline
 

X-Wizard
  
Join Date: Aug 2003
Posts: 1,003
 

Default 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
Reply With Quote