I'm trying to upgrade our 0.3.1 installation to 0.4.2.
When I execute the following SQL upgrade lines, I get the errors that
follow them:
mysql> ALTER TABLE `contacts` ADD CONSTRAINT `user_id_fk_contacts`
FOREIGN KEY (`user_id`)
-> REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;
ERROR 1452 (23000): Cannot add or update a child row: a foreign key
constraint fails (`pis_roundcube/#sql-36e8_638`, CONSTRAINT
`user_id_fk_contacts` FOREIGN KEY (`user_id`) REFERENCES `users`
(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE)
mysql> ALTER TABLE `identities` ADD CONSTRAINT `user_id_fk_identities`
FOREIGN KEY (`user_id`)
-> REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;
ERROR 1452 (23000): Cannot add or update a child row: a foreign key
constraint fails (`pis_roundcube/#sql-36e8_638`, CONSTRAINT
`user_id_fk_identities` FOREIGN KEY (`user_id`) REFERENCES `users`
(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE)
The first 2 ALTER TABLE commands work OK, and I've verified all tables
have been changed to InnoDB. Any ideas on how to get this to work?
Alternately, is there a good way to import data from an existing older
roundcube MySQL database into a fresh, up-to-date one?
Thanks!
- John
--
-------------------------------------------------------------------
John May : President http://www.pointinspace.com/
Point In Space Internet Solutions [email protected]
Twitter: http://twitter.com/pointinspace/
Facebook: http://www.facebook.com/PointInSpace/
Professional FileMaker Pro, MySQL, PHP & Lasso Hosting
on shared, virtual and hardware dedicated servers
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/8f4f07cd
