Tickets :: Comment on [#6598] Search List mixes fields

* Your Email Address
* Spam protection	Enter the letters below: .___.__..__..___. . [__ [__][__][__ \ / \| \| \|\| \|\| \/
Comment	> 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"] > > > > > > > > > >
Attachment
Watch this ticket

Saved Queries