[Tickets #10003] Re: unknown address book "localsql"

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/10003
------------------------------------------------------------------------------
  Ticket             | 10003
  Updated By         | vilius at lnk.lt
  Summary            | unknown address book "localsql"
  Queue              | Turba
  Version            | Git master
  Type               | Bug
  State              | Not A Bug
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             | Michael Rubinsky
------------------------------------------------------------------------------


vilius at lnk.lt (2011-08-02 06:14) wrote:

OK, I found out that this is not related to add_source preference. I  
deleted all add_sources which point to 'localsql'. I have also  
configured a hook to choose default address book in imp for adding  
addresses automatically.

I have added:
Horde::logMessage(var_export($lines, true) . " user: ".  
$GLOBALS['registry']->getAuth(), 'ERR');

under if (!empty($lines)) on line 67 in Turba.php and got the  
following output on failling users:

2011-08-02T01:26:06+03:00 ERR: HORDE [turba] 345 user: martas at lnk.lt  
[pid 15040 on line 68 of "/var/www/html/horde/turba/lib/Turba.php"]
2011-08-02T01:26:06+03:00 WARN: HORDE [turba] PHP ERROR: Invalid  
argument supplied for foreach() [pid 15040 on line 70 of  
"/var/www/html/horde/turba/lib/Turba.php"]

When looking into database I see that this user somehow got new line  
into his preference:
mysql> select * from horde_prefs where pref_uid = 'martas at lnk.lt' and  
pref_name = 'addressbooks';
+---------------+------------+--------------+------------+
| pref_uid      | pref_scope | pref_name    | pref_value |
+---------------+------------+--------------+------------+
| martas at 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 at lnk.lt           | turba      | addressbooks |
388       |
| raimonda at lnk.lt          | turba      | addressbooks |
350       |
| simkus at lnk.lt            | turba      | addressbooks |
330       |
| daugirdaite at lnk.lt       | turba      | addressbooks |
332       |

..........

Seems like upgrade task problem to me. No?