No custom database tables

[amaze646]

Hello,

Im trying to move some old roundcube installation on newest version (new server). Old instance has custom database tables created for roundcube that seems that are not recongised on new installation.

For example i have this defined in my configuration:
$rcmail_config['db_table_users'] = 'user_view';
$rcmail_config['db_table_userswrite'] = 'user_w';

But I get this error bellow. From what I can see, roundcube still uses users table instead user_view:

LINE 1: SELECT * FROM "users" WHERE "mail_host" = 'my.hostename.com...
                      ^ (SQL Query: SELECT * FROM "users" WHERE "mail_host" = 'my.hostename.com' AND "username" = 'myusername') in /var/www/roundcube/program/lib/Roundcube/rcube_db.php on line 543 (POST /?_task=login&_action=login)


Are those custom database table definitions still enabled on new roundcube versions? My old version is 0.8.5, version on new server is 1.4.3

Thank you and kind regards,
Igor

[JohnDoh]

The db_table_*/db_sequence_* options where removed in version 1.0 and replaced with a single db_prefix option. See https://github.com/roundcube/roundcubemail/commit/399db1b647e14947e97a865c09215969f56a7efe

[amaze646]

Hello,

thank you for your anwser!

So it is not possible to assign table names with different names than default anymore? In this case, user_view for example.

Kind regards,
Igor

[JohnDoh]

The prefix is applied to all tables so while you cannot completely change the name of the table you can customize with a prefix. eg. `rcdb_users`.