I'm using CentOS-installed MySQL (which is 5.0.77 but with their patches) and roundcube 0.4beta. When I go to save an identity, it fails, and the following is logged to my roundcube log file:
[08-Aug-2010 23:28:35] MDB2 Error: constraint violation (-3): _doQuery: [Error message: Could not execute statement]
[Last executed query: EXECUTE mdb2_statement_mysql_3fc664595d3ea536ec7eb834725e8f865807db484 USING @0, @1, @2, @3, @4, @5, @6, @7, @8]
[Native code: 1452]
[Native message: Cannot add or update a child row: a foreign key constraint fails (`email_database/rc_identities`, CONSTRAINT `user_id_fk_identities` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE)]
[08-Aug-2010 23:28:35 -0400]: DB Error: MDB2 Error: constraint violation Query: _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_mysql_3fc664595d3ea536ec7eb834725e8f865807db484 USING @0, @1, @2, @3, @4, @5, @6, @7, @8] [Native code: 1452] [Native message: Cannot add or update a child row: a foreign key constraint fails (`email_prod/rc_identities`, CONSTRAINT `user_id_fk_identities` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE)] in /scrubbed/program/include/rcube_mdb2.php on line 658 (POST /?_task=settings&_action=save-identity)
Thanks for any help you can render.