[turba] Broken addressbook

Wed Dec 4 14:23:37 2002

All,

I've been using CVS HEAD version of horde..etc for some time and in the last
few days turba got broken. I know most people hate this kind of "its just
broken" message but there we are:

here are th symptoms:

1. When doing a simple search with empty criteria on name (or any field) I
get a blank page where the search reasults should be. The html source simply
reads

<html><body></body></html> for that page, the horde navigation bar at the
bottom of the display is unaffected.

2. the addressbook link from compose simply shows a blank screen

3. the name expansion in compose does not work either

I've turned on all debugging in horde LOG_DEBUG level and monitored the log.
Not noticed anything out of the ordinary there here is a typical extract
when I try to do a search:

Dec  4 14:18:20 ns HORD([7228]: PHP Warning:  Your script possibly relies on
a session side-effect which existed until PHP 4.2.3. Please be advised that
the session extension does not consider global variables as a source of
data, unless register_globals is enabled. You can disable this functionality
and this warning by setting session.bug_compat_42 or session.bug_compat_warn
to off, respectively. in Unknown on line 0

Dec  4 14:18:20 ns HORDE[7228]: [turba] SQL Query by
SessionHandler_sql::write(): query = "SELECT session_id FROM
horde_sessionhandler WHERE session_id = '0f2ca7fce5c126a89e28816f43e0e3ce'"
[on line 100 of "/var/www/horde/lib/SessionHandler/sql.php"]

Dec  4 14:18:20 ns HORDE[7228]: [turba] SQL Query by
Horde_SQL::updateBlob(): query = "UPDATE horde_sessionhandler SET
session_lastmodified = ?, session_data = ? WHERE session_id = ?" [on line
201 of "/var/www/horde/lib/SQL.php"]

Dec  4 14:18:21 ns HORDE[7228]: [turba] SQL search by ashihab@alcahest.com:
table = turba_objects; query = "SELECT object_id, owner_id, object_type,
object_members, object_name, object_email, object_homeaddress,
object_workaddress, object_homephone, object_workphone, object_cellphone,
object_fax, object_title, object_company, object_notes, object_pgppublickey
FROM turba_objects WHERE  (owner_id = 'ashihab@alcahest.com') AND 
(LOWER(object_name) LIKE LOWER('%%'))" [on line 120 of
"/var/www/horde/turba/lib/Driver/sql.php"]

Dec  4 14:18:21 ns 0æÿ¿4æÿ¿![7228]: [turba] SQL Query by
SessionHandler_sql::write(): query = "SELECT session_id FROM
horde_sessionhandler WHERE session_id = '0f2ca7fce5c126a89e28816f43e0e3ce'"
[on line 100 of "/var/www/horde/lib/SessionHandler/sql.php"]

Dec  4 14:18:21 ns 0æÿ¿4æÿ¿![7228]: [turba] SQL Query by
Horde_SQL::updateBlob(): query = "UPDATE horde_sessionhandler SET
session_lastmodified = ?, session_data = ? WHERE session_id = ?" [on line
201 of "/var/www/horde/lib/SQL.php"]

which shows the query of the mysql at base happening I've also verified that
the results are coming back from sql and the database is not returning an error.

I've checked the table schema against the latest turba.sql and seems to match.

Any pointers will be appereciated....

Configuration:

RH 7.1 (latest updates)
apache 1.3.2x (also tried apache 2)
php 4.4.0-dev and php-4.2.3 (released)
horde, turba and other modules from CVS this morning.

my sources.php has a single entry:

$cfgSources['localsql'] = array(
    'title' => _("My Addressbook"),
    'type' => 'sql',
    'params' => array(
        'phptype' => 'mysql',
        'hostspec' => 'galgamish',
        'username' => 'horde',
        'password' => 'xxxxxxxx',
        'database' => 'horde',
        'table' => 'turba_objects'
    ),
    'map' => array(
        '__key' => 'object_id',
        '__owner' => 'owner_id',
        '__type' => 'object_type',
        '__members' => 'object_members',
        'name' => 'object_name',
        'email' => 'object_email',
        'homeAddress' => 'object_homeaddress',
        'workAddress' => 'object_workaddress',
        'homePhone' => 'object_homephone',
        'workPhone' => 'object_workphone',
        'cellPhone' => 'object_cellphone',
        'fax' => 'object_fax',
        'title' => 'object_title',
        'company' => 'object_company',
        'notes' => 'object_notes',
        'pgpPublicKey' => 'object_pgppublickey'
    ),
    'search' => array(
        'name',
        'email',
        'company'
    ),
    'strict' => array(
        'object_id'
    ),
    'public' => true,
    'readonly' => false,
    'admin' => array('ashihab@alcahest.com'),
    'export' => true
);

Ahmed...