cron problems - unserialize error

[hankster]

When I run cron.php I get these messages:

PHP Notice: unserialize(): Error at offset 4535 of 49151 bytes in /home/sugar/httpd/html/modules/UserPreferences/UserPreference.php on line 168
PHP Notice: unserialize(): Error at offset 4535 of 49151 bytes in /home/sugar/httpd/html/modules/UserPreferences/UserPreference.php on line 169

The user is admin. The category is global.

How can I repair admin global prefs?

More details:

I'm using the Community Editions with "You have the latest version available".

The piece of code in error is here:

$row = $GLOBALS['db']->fetchByAssoc($result);
if ($row) {

$_SESSION[$user->user_name . '_PREFERENCES'][$category] = unserialize(base64_decode($row['contents']));
$user->user_preferences[$category] = unserialize(base64_decode($row['contents']));
return true;
}
}


Which prints out the decoded contents as follows (user, category, contents):

admin
global

a:55:{s:8:"timezone";s:19:"America/Los_Angeles";s:2:"ut";s:1:"1";s:19:"Users_USER_ORD E
....
"return_module";s:8:"Accounts";s:21:"current_query _by_page";s:120880:"YTo3MTp7czoxMzoicmV0dXJuX2FjdG lvbiI7czoxMDoiRGV0YWlsVmlldyI7czoxMzoicmV0dXJuX21v ZHVsZSI7czo4OiJBY2NvdW50cyI7czoxMDoibWFzc3VwZGF0ZS I7czo1OiJmYWxzZSI7czo2OiJkZWxldGUiO3M6NToiZmFsc2Ui O3M6NToibWVyZ2UiO3M6NToiZmFsc2UiO3M6MjE6ImN1cnJlbn RfcXVlcnlfYnlfcGFnZSI7czo4NzE0MDoiWVRvM01UcDdjem94 TXpvaWNtVjBkWEp1WDJGamRHbHZiaUk3Y3pveE1Eb2lSR1YwWV dsc1ZtbGxkeUk3Y3pveE16b2ljbVYwZFhKdVgyMXZaSFZzWlNJ N2N6bzRPaUpCWTJOdmRXNTBjeUk3Y3pveE1Eb2liV0Z6YzNWd1 pHRjBaU0k3Y3pvMU9pSm1ZV3h6WlNJN2N6bzJPaUprWld4bGRH VWlPM002TlRvaVptRnNjMlVpTzNNNk5Ub2liV1Z5WjJVaU8zTT ZOVG9pWm1Gc2MyVWlPM002TWpFNkltTjFjbkpsYm5SZmNYVmxj bmxmWW5sZmNHRm5aU0k3Y3pvMk1UZ3p

....

So there seems to be a long string "s:120880:"YTo3MTp7czoxMzo" which is blowing up.

Any ideas?

Thanks

[hankster]

After trying various repairs on the database and saving new admin prefs this problem went away. I don't know what exactly fixed it, but it's gone now.

[salesagility]

Exactly what version are you running ... if it's 6, then you should expect problems as this is not production ready ... if you need a production version, then goto 5.5.x