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,,