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