id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc
1486396	Cannot create identities when tablenames changed	mhasle		"Hi,

As I'm having only one database on my hosting service, I had to rename the MySQL tables..

So I changes the db.inc.php as following : 
{{{
$rcmail_config['db_table_users'] = 'roundcube_users';
$rcmail_config['db_table_identities'] = 'roundcube_identities';
$rcmail_config['db_table_contacts'] = 'roundcube_contacts';
$rcmail_config['db_table_session'] = 'roundcube_session';
$rcmail_config['db_table_cache'] = 'roundcube_cache';
$rcmail_config['db_table_messages'] = 'roundcube_messages';
}}}

I also changed the mysql.initial.sql accordingly...

Once this done, I cannot create any identity anymore.
The error file shows the following:

{{{
[29-Dec-2009 23:19:06 +0100]: DB Error: MDB2 Error: constraint violation Query: _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_mysql_37dc9d4ef89600af929306eb2f7aec69aabf0f4eb 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 (`xxxxx/roundcube_identities`, CONSTRAINT `user_id_fk_identities` FOREIGN KEY (`user_id`) REFERENCES `'''users'''` (`user_id`))]  in /home/xxxxx/webmail/program/include/rcube_mdb2.php on line 627 (POST /webmail/?_task=settings&_action=save-identity)
}}}

It looks like the tablename is hardcoded somewhere...

Any help here is welcome.

Michael
"	Bugs	closed	5	later	Database	0.3.1	normal	invalid