Mike I've had similar error when updated to VCL 2.3. A custom database upgrade (specific to our environment) in 2.2.1 caused this error. In my case if was custom 'name' value in vcl.affiliation table. Update went OK once I edited update-vcl.sql script to match my production database values.
I hope it helps. Thanks. On Oct 10, 2012, at 16:34 , "Waldron, Michael H" <[email protected]> wrote: > I am going through the upgrade procedure on my VCL test system from 2.2.1 to > 2.3. > > When I run the mysql update script, I get the following error: > # mysql vcl < mysql/update-vcl.sql > > ERROR 1451 (23000) at line 484: Cannot delete or update a parent row: a > foreign key constraint fails (`vcl/provisioningOSinstalltype`, CONSTRAINT > `provisioningOSinstalltype_ibfk_1` FOREIGN KEY (`provisioningid`) REFERENCES > `provisioning` (`id`) ON UPDATE CASCADE) > > Any ideas what might be wrong here? > > Thanks, > Mike > > Mike Waldron > Systems Specialist > ITS - Research Computing Center > University of North Carolina at Chapel Hill > -- Thank you, Dmitri Chebotarov Virtual Computing Lab Systems Engineer, TSD - Ent Servers & Messaging 223 Aquia Building, Ffx, MSN: 1B5 Phone: (703) 993-6175 Fax: (703) 993-3404
