Author Topic: trouble with users preferences  (Read 4415 times)

Offline iut-velizy

  • Newbie
  • *
  • Posts: 4
trouble with users preferences
« 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

Offline alec

  • Hero Member
  • *****
  • Posts: 1,363
Re: trouble with users preferences
« Reply #1 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.

Offline iut-velizy

  • Newbie
  • *
  • Posts: 4
Re: trouble with users preferences
« Reply #2 on: February 03, 2016, 08:48:49 AM »
Thanks it works like a charm!