timezone not being saved for one user

[mikesolomon]

I have a user who after resetting his user preferences noe cannot save the timezone

every time he logs on it asks him for his timezone

any help solving this would be much appreciated

[eggsurplus]

I had a similar issue at one point. It may be caused by one of the two issues I posted at http://www.sugarcrm.com/forums/print...2&pp=10&page=2

[mikesolomon]

I have narrowed the issue down a bit

It happens to a user if they reset their user preferences

once they have done this then they have to enter timezone on login and all changes to home page/dashlets are lost when they logout

[mikesolomon]

I fixed this by by deleting all records from the user_preferences table

[eggsurplus]

Mike,

That sounds exactly like what we had. What was probably happening was the uppercase vs lowercase issue for the category.

[mikesolomon]

Mike,

That sounds exactly like what we had. What was probably happening was the uppercase vs lowercase issue for the category.

What I found was once a user reset his preferences any subsequent entries into the user_preferences table had assigned_use_id & category fields as null

Clearing the table fixed this and also meant that search preferences were saved which was another issue I was investigating

[Taliesin]

What I found was once a user reset his preferences any subsequent entries into the user_preferences table had assigned_use_id & category fields as null

Clearing the table fixed this and also meant that search preferences were saved which was another issue I was investigating

Just to say that you don't have to delete the entire contents of the table. Delete those rows where the category field is NULL or the assigned_user_id is the affected user's id code, and this will be sufficient. Saves upsetting a large number of users if you blitz everyone's user preferences.

That said, I spent most of this morning digging through the code to get to the point that I found the preferences were being saved to blank users in the database. Once I'd found the NULL category fields, finding this thread and the solutions was easy. Still, that's a morning I could have productively spent on something else.

I've searched but couldn't find a bug filed on this, so I've created one at:

http://www.sugarcrm.com/crm/support/...6-4c063ee6050b

For reference, this bug exists for me in the Professional version, 5.2 at the time of posting.

Taliesin.