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
Quote from: 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 :
"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.
Thanks it works like a charm!