Can't get past Login page tip for 3.01b users

[jjohn2006]

Howdy,

Problem: Frequent sugar user cannot get past the login page using his credentials. No database changes or UI changes occurred since his last successful log in. Other accounts can log in. Sugar and apache logs indicate no error.

Solution: The user_preferences field in the users table for this account had become corrupted. The unserialize() command in User.php failed, returning a FALSE boolean value.

The solution was to replace the problem user's user_preference value with working user_preference string from a user with a similar role. The SQL looked something like this:

UPDATE users SET user_preference='<some base64 looking string>' WHERE user_name='<problem account>';

I realize that most of the world has moved on from 3.01 and so would we. Could someone point me to the upgrade script that turns 3.01 tables into at least 3.5? I think I can follow the upgrade path from there. The outlook connector for 3.0 will still work with 3.5 and 4.0, right? I hope so...

Thanks,

--Joe Johnston

[sadek]

Howdy,
Could someone point me to the upgrade script that turns 3.01 tables into at least 3.5? I think I can follow the upgrade path from there. The outlook connector for 3.0 will still work with 3.5 and 4.0, right? I hope so...

Go to:
http://www.sugarforge.org/frs/?group_id=6

The file is called:
Upgrade_Steps_to_Sugar_Open_Source_v351.pdf

This will take you to SugarCRM 3.5.1. The old outlook plugin will not work with the newer version. You will have to download the latest version.

-Sadek