Tickets :: Comment on [#10003] unknown address book "localsql"

* Your Email Address
* Spam protection	Enter the letters below: .__ .__ . .\ /.__ [ __[__)\| \| >< [__) [_./[__)\|__\|/ \\|
Comment	> >> When looking into database I see that this user somehow got new line >> into his preference: > > When did this entry get added? I have no idea where that numeric > value would have come from. It's not a valid horde 3 value, nor a > valid horde 4 value for the addressbooks pref. > >> mysql> select * from horde_prefs where pref_uid = 'martas@lnk.lt' and >> pref_name = 'addressbooks'; >> +---------------+------------+--------------+------------+ >> \| pref_uid \| pref_scope \| pref_name \| pref_value \| >> +---------------+------------+--------------+------------+ >> \| martas@lnk.lt \| turba \| addressbooks \| >> 345 \| >> +---------------+------------+--------------+------------+ >> 1 row in set (0.00 sec) >> >> Also I'm not sure, but there are other users who have 'addressbooks' >> set to simple numbers from ~250 to ~400. >> >> mysql> select * from horde_prefs where pref_name = 'addressbooks' and >> pref_value LIKE '____'; >> +--------------------------+------------+--------------+------------+ >> \| pref_uid \| pref_scope \| pref_name \| pref_value \| >> +--------------------------+------------+--------------+------------+ >> \| kitokie@lnk.lt \| turba \| addressbooks \| >> 388 \| >> \| raimonda@lnk.lt \| turba \| addressbooks \| >> 350 \| >> \| simkus@lnk.lt \| turba \| addressbooks \| >> 330 \| >> \| daugirdaite@lnk.lt \| turba \| addressbooks \| >> 332 \| >> >> .......... >> >> Seems like upgrade task problem to me. No? > > Well, the upgrade task wouldn't produce those values. So if it ran, > something went really wrong. If it didn't run, those values are > corrupt anyway. You will have to track this down in > Turba_LoginTasks_SystemTask_Upgrade#_upgradeAbookPrefs() with a fresh > set of unupdated data and see what the values are at different points > along the process. >
Attachment
Watch this ticket

Saved Queries