Hi, yes I did. But I don't know pretty much RC internals :)
After next user's login, will his user_id be recreated? In case, is it necessary to manually modify contacts table to make address book working again for specific user? Thank you very much > > Il 11 ottobre 2017 alle 10.55 Reindl Harald <[email protected]> ha > scritto: > > Am 11.10.2017 um 10:50 schrieb [email protected]: > > > > > > is there a way to reset RC settings for some user? > > > > I am using RC 1.1.9 with MySQL backend > > > > > > did you even try to look at the database? > just delete the database record for the user > > MariaDB [roundcube_db]> show fields from users; > > +----------------------+------------------+------+-----+---------------------+----------------+ > | Field | Type | Null | Key | Default > | Extra | > > +----------------------+------------------+------+-----+---------------------+----------------+ > | user_id | int(10) unsigned | NO | PRI | NULL > | auto_increment | > | username | varchar(128) | NO | MUL | NULL > | | > | mail_host | varchar(128) | NO | | NULL > | | > | created | datetime | NO | | 1000-01-01 > 00:00:00 | | > | last_login | datetime | YES | | NULL > | | > | language | varchar(5) | YES | | NULL > | | > | preferences | longtext | YES | | NULL > | | > | failed_login | datetime | YES | | NULL > | | > | failed_login_counter | int(10) unsigned | YES | | NULL > | | > > +----------------------+------------------+------+-----+---------------------+----------------+ > 9 rows in set (0.00 sec) > > MariaDB [roundcube_db]> select * from users where > username='[email protected]'; > > +---------+------------------------+-----------+---------------------+---------------------+----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+----------------------+ > | user_id | username | mail_host | created | > last_login | language | preferences > > | failed_login | failed_login_counter | > > +---------+------------------------+-----------+---------------------+---------------------+----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+----------------------+ > | 1 | [email protected] | 127.0.0.1 | 2012-03-03 01:50:57 | > 2017-09-24 21:44:54 | de_DE | > > a:10:{s:11:"client_hash";s:32:"5b9d50d7dc8b4ffecc3b348d1c96cc04";s:11:"search_mods";a:5:{s:1:"*";a:2:{s:7:"subject";i:1;s:4:"from";i:1;}s:4:"Sent";a:2:{s:7:"subject";i:1;s:2:"to";i:1;}s:6:"Drafts";a:2:{s:7:"subject";i:1;s:2:"to";i:1;}s:5:"gmail";a:2:{s:7:"subject";i:1;s:4:"from";i:1;}s:5:"INBOX";a:2:{s:7:"subject";i:1;s:4:"from";i:1;}}s:16:"message_sort_col";s:4:"date";s:18:"message_sort_order";s:4:"DESC";s:9:"list_cols";a:7:{i:0;s:7:"threads";i:1;s:7:"subject";i:2;s:4:"from";i:3;s:4:"date";i:4;s:4:"size";i:5;s:10:"attachment";i:6;s:8:"priority";}s:22:"preview_pane_mark_read";i:5;s:10:"keep_alive";i:60;s:10:"prettydate";b:0;s:9:"junk_mbox";s:4:"junk";s:20:"default_imap_folders";a:5:{i:0;s:5:"INBOX";i:1;s:6:"Drafts";i:2;s:4:"Sent";i:3;s:4:"junk";i:4;s:5:"Trash";}} > | NULL | NULL | > > +---------+------------------------+-----------+---------------------+---------------------+----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+----------------------+ > 1 row in set (0.00 sec) > > MariaDB [roundcube_db]> >
_______________________________________________ Roundcube Users mailing list [email protected] http://lists.roundcube.net/mailman/listinfo/users
