[turba] Broken addressbook

Thu Dec 5 00:38:06 2002

for completeness sake and the archives, I've figured out what was wrong. 
The address book I was using had the object_type field of the database's 
table empty which did not seem to matter to previous versions of turba.

Latest versions have a problem, though I don't know what it is. Once I 
filled the missing value in the field of every wrong entry it all sprung 
back to life.

Ahmed...

Quoting Ahmed <ashihab@alcahest.com>:

> 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...
> 
> 
> 
> 
> --
> Turba mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: turba-unsubscribe@lists.horde.org
> 
> 
> 