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 jmay(a)pointinspace.com
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/aba52c80
Hi,
Here is the japanese translation for 0.4,
updated only labels.inc file.
---
Taka
--- 8< --- detachments --- 8< ---
The following attachments have been detached and are available for viewing.
http://detached.gigo.com/rc/TW/tRCC7F2H/0.4-ja-labels.tar.gz
Only click these links if you trust the sender, as well as this message.
--- 8< --- detachments --- 8< ---
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80
Hi,
attached (or rather detached) is the updated Lithuanian translation for
RoundCube.
By the way, are there any plans to support more than one plural forms,
e.g. by employing gettext?
Regards,
Rimas
--- 8< --- detachments --- 8< ---
The following attachments have been detached and are available for viewing.
http://detached.gigo.com/rc/sq/uvXd4uZY/Roundcube_lt.zip
Only click these links if you trust the sender, as well as this message.
--- 8< --- detachments --- 8< ---
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80
Regards,
David
--
The day microsoft makes something that doesn't suck is the day they
start making vacuum cleaners.
gpg --keyserver pgp.mit.edu --recv-keys 1920BD87
Key fingerprint = 3326 32CE 888B DFF1 DED3 B8D2 105F 29CB 1920 BD87
--- 8< --- detachments --- 8< ---
The following attachments have been detached and are available for viewing.
http://detached.gigo.com/rc/Wh/QP88vda7/labels.inchttp://detached.gigo.com/rc/Wh/QP88vda7/messages.inc
Only click these links if you trust the sender, as well as this message.
--- 8< --- detachments --- 8< ---
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80