always ask for Time Zone (before 4.5.1e update)

[rgurgel]

Hi people,

I had update sugarcrm from 4.5.1d to 4.5.1e and now sugar always ask for user time zone before login.

I believe that happening for all users that ask for "Reset To Default Preferences" option on "My Account" Tab

sugarcrm... to be or not to be. too bugs to not so free.

[default]

that is realy the process..

[julian]

Hello rgurgel,

Are you saying that it only asks users to set their time zone after you click the "Reset To Default Preferences" link for them? This is expected behavior.

If Sugar is prompting your users to reset their time zone each time they login, even if they have not clicked "Reset To Default Preferences", then there's a bug we should look into.

Thanks,

[rgurgel]

Hello rgurgel,

Are you saying that it only asks users to set their time zone after you click the "Reset To Default Preferences" link for them? This is expected behavior.

If Sugar is prompting your users to reset their time zone each time they login, even if they have not clicked "Reset To Default Preferences", then there's a bug we should look into.

Thanks,

No, I'm saying that not stop to ask (all time that i login, sugar asks)... But I believe that occours after 1 time I ask to "Reset to Default..."

[ndaniels]

I'm seeing similar problem - for some (not all) users after they do "Reset to Default Preferences" they are asked to confirm time zone on every login, not just the first. Additionally the new preferences which they select after login are not saved - are not visible on the next login (after confirming timezone again).
Where in the db is the flag for 'user is ok, don't ask for timezone, save preferences' ??? I'm willing to manually set that as needed for now....
Thoughts?

[simple]

In the file module/UserPreferences/UserPreference.php on about line 280 we had to change

				if(!empty($row['id'])) { // update
					$focus->retrieve($row['id']);
					$focus->deleted = 0;
					$focus->contents = base64_encode(serialize($contents));
				}

to

				if(!empty($row['id'])) { // update
					$focus->assigned_user_id = $user->id;
					$focus->retrieve($row['id'], true, false);
					$focus->deleted = 0;
					$focus->contents = base64_encode(serialize($contents));
				}

Hope this solves your problem too. Check if you have entries in the user_preferences table which don't have an assigned_user_id.

[gneill794]

Simple,

Would you recommend the entries in user_preferences which have no assigned_user_id's be deleted from the DB?

Thanks,
George.

[simple]

We did not delete them. But if you have a lot of these entries, you may delete them. I do not think that this will cause any problems.

[gneill794]

Simple,

I did this,

UPDATE user_preferences SET deleted = 1 WHERE assigned_user_id = '';

... and everything still seems to be working just fine.

Thanks,
George.

[ndaniels]

Thanks, Simple - your fix works perfectly. We've applied to our test system and to our production system and now we have happier users.