[Tickets #6598] Re: Search List mixes fields

[bugs at horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/6598
-----------------------------------------------------------------------
 Ticket             | 6598
 Updated By         | holger.wegner at hamburg.de
 Summary            | Search List mixes fields
 Queue              | Turba
 Version            | HEAD
 Type               | Bug
 State              | Feedback
 Priority           | 1. Low
 Milestone          |
 Patch              |
 Owners             | Michael Rubinsky, Jan Schneider
-----------------------------------------------------------------------


holger.wegner at hamburg.de (2008-04-12 09:23) wrote:

Here is the config of that source:
 'map' => array(
        '__key' => 'id',
        '__uid' => 'id',
        'name' => array('fields' => array('firstname', 'lastname'),
                 'format' => '%s %s'),
        'firstname' => 'first_name',
        'lastname' => 'last_name',
        'title' => 'title',
        'department' => 'department',
        'birthday' => 'birthdate',
        'homePhone' => 'phone_home',
        'cellPhone' => 'phone_mobile',
        'workPhone' => 'phone_work',
        'otherPhone' => 'phone_other',
        'fax' => 'phone_fax',
        'email' => 'email1',
        'emails' => 'email2',
        'assistant' => 'assistant',
        'homeStreet' => 'primary_address_street',
        'homeCity' => 'primary_address_city',
        'homeProvince' => 'primary_address_state',
        'homePostalCode' => 'primary_address_postalcode',
        'homeCountry' => 'primary_address_country',
        'workStreet' => 'alt_address_street',
        'workCity' => 'alt_address_city',
        'workProvince' => 'alt_address_state',
        'workPostalCode' => 'alt_address_postalcode',
        'workCountry' => 'alt_address_country'
    ),
    'search' => array(
        'name',
        'email',
        'homeCity',
        'homePhone',
        'workPhone',
        'cellPhone'
    ),
    'strict' => array(
        'id',
    ),
    'tabs' => array(
    'Allgemein' => array('firstname', 'lastname', 'birthday', 'title',
                        'homePhone', 'cellPhone', 'workPhone', 'fax',
'email', 'emails'),
    'Addressen' => array('department', 'assistant',
                        'homeStreet', 'homePostalCode', 'homeCity',
'homeProvince', 'homeCountry',
                        'workStreet', 'workPostalCode', 'workCity',
'workProvince', 'workCountry')
    ),
    'export' => true,
    'browse' => true,
    'use_shares' => false,
);

In the browser I see following in the surch list following field of the
details page
Name: Wegner, Wegner
Firstname: Wegner
Lastname: Wegner
Phone privat: the cell phone number
cell phone: the business number
Phone business: the privat number
Fax: the email addess
E-Mail: nothing
city privat: the postalcode

its completly mixed.

In the debug log I see following for a search:
Apr 12 15:22:25 HORDE [debug] [horde] Connected to the following memcache
servers:localhost:11211 [pid 25755 on line 123 of
"/usr/share/php/Horde/Memcache.php"]
Apr 12 15:22:25 HORDE [debug] [horde] Read session data (id =
82635f3ca4552932271d46828f2f2946) [pid 25755 on line 164 of
"/usr/share/php/Horde/SessionHandler/memcache.php"]
Apr 12 15:22:25 HORDE [debug] [turba] Hook _horde_hook_share_init in
application horde not called. [pid 25755 on line 1595 of
"/usr/share/php/Horde.php"]
Apr 12 15:22:25 HORDE [debug] [turba] SQL query by
Turba_Driver_sql::_search(): SELECT id, first_name, last_name, title,
department, birthdate, phone_home, phone_mobile, phone_work, phone_other,
phone_fax, email1, email2, assistant, primary_address_street,
primary_address_city, primary_address_state, primary_address_postalcode,
primary_address_country, alt_address_street, alt_address_city,
alt_address_state, alt_address_postalcode, alt_address_country FROM
contacts WHERE (((LOWER(first_name) LIKE LOWER(?) OR LOWER(first_name) LIKE
LOWER(?)) AND (LOWER(last_name) LIKE LOWER(?) OR LOWER(last_name) LIKE
LOWER(?)))) [pid 25755 on line 166 of
"/opt/horde/turba/lib/Driver/sql.php"]
Apr 12 15:22:25 HORDE [debug] [turba] SQL query by
Horde_Alarm_sql::_list(): SELECT alarm_id, alarm_uid, alarm_start,
alarm_end, alarm_methods, alarm_params, alarm_title, alarm_text,
alarm_snooze, alarm_internal FROM horde_alarms WHERE alarm_dismissed = 0
AND ((alarm_snooze IS NULL AND alarm_start <= ?) OR alarm_snooze <= ?) AND
(alarm_end IS NULL OR alarm_end >= ?) AND (alarm_uid = ? OR alarm_uid = ?)
ORDER BY alarm_start, alarm_end [pid 25755 on line 148 of
"/usr/share/php/Horde/Alarm/sql.php"]
Apr 12 15:22:25 HORDE [debug] [turba] SQL query by
Turba_Driver_sql::_search(): SELECT object_id, object_type, owner_id,
object_firstname, object_lastname FROM turba_objects WHERE (object_type = ?
AND owner_id = ?) [pid 25755 on line 166 of
"/opt/horde/turba/lib/Driver/sql.php"]
Apr 12 15:22:25 HORDE [debug] [turba] Max memory usage: 2883584 bytes [pid
25755 on line 333 of "/usr/share/php/Horde/Registry.php"]
Apr 12 15:22:25 HORDE [debug] [turba] Wrote session data (id =
82635f3ca4552932271d46828f2f2946) [pid 25755 on line 212 of
"/usr/share/php/Horde/SessionHandler/memcache.php"]