Roundcube Community Forum

SVN Releases => Issues & Bugs => Topic started by: iut-velizy on February 03, 2016, 05:26:14 AM

Title: trouble with users preferences
Post by: iut-velizy on February 03, 2016, 05:26:14 AM
Hi
I recently upgraded from 0.6 to 1.1.4. But 0.6 version users' preferences causes problems (very slow display, error messages) so i have to "refresh" them. For example the following user could not connect to INBOX :

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| user_id | username | mail_host   | alias | created             | last_login          | language | preferences                                                                                                                                                                                                                                                                                                                                         -------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|      39 | xxxxx    | xxx.xx.xx.x |       | 2007-11-02 03:07:25 | 2016-01-17 17:38:47 | fr_FR    | a:4:{s:11:"search_mods";a:4:{s:1:"*";a:2:{s:7:"subject";i:1;s:4:"from";i:1;}s:10:"INBOX.Sent";a:2:{s:7:"subject";i:1;s:2:"to";i:1;}s:12:"INBOX.Drafts";a:2:{s:7:"subject";i:1;s:2:"to";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:15:"namespace_fixed";b:1;} |

I deleted this entry in the users' mysql table (mysql> delete from users where username = 'xxxxx') and he can connect himself to INBOX again, his users row being recreated and simplified :

+---------+----------------+-------------+---------------------+---------------------+----------+----------------------------------------------------------------------------------------------+
| user_id | username       | mail_host   | created             | last_login          | language | preferences                                                                                  |
+---------+----------------+-------------+---------------------+---------------------+----------+----------------------------------------------------------------------------------------------+
|     204 | xxxxx            | xxx.xx.xx.x| 2016-02-02 12:09:43 | 2016-02-03 10:08:28 | fr_FR    | a:2:{s:11:"client_hash";s:32:"a1cf876416e5affa786e95358f2887ac";s:15:"namespace_fixed";b:1;} |
+---------+----------------+-------------+---------------------+---------------------+----------+----------------------------------------------------------------------------------------------+

The next problem being he's lost his address book in the process. The entries in his contacts table are lost with the delete command.
For the next person in this situation, i could directly correct/SET the preferences in the users table. But I dont understand the preferences syntax (a:2{...??). Could you help me ?
 
Thx in  advance
Title: Re: trouble with users preferences
Post by: alec on February 03, 2016, 06:45:24 AM
Hi
I recently upgraded from 0.6 to 1.1.4. But 0.6 version users' preferences causes problems (very slow display, error messages) so i have to "refresh" them. For example the following user could not connect to INBOX :

"message_sort_col";s:4:"date"
Maybe your server has very slow sorting implementation. So, sorting by date takes ages, while your default may be different.

Quote
I deleted this entry in the users' mysql table (mysql> delete from users where username = 'xxxxx') and he can connect himself to INBOX again, his users row being recreated and simplified :
Setting the field to NULL should be enough.
Quote
For the next person in this situation, i could directly correct/SET the preferences in the users table. But I dont understand the preferences syntax (a:2{...??). Could you help me ?
This is format used by PHP's serialize() function.
Title: Re: trouble with users preferences
Post by: iut-velizy on February 03, 2016, 08:48:49 AM
Thanks it works like a charm!