[turba] fresh install 2.3.5 mysql weirdness

[Chris Flav]

Hello,

I just installed turba-h3-2.3.5, and I seem to have a sql problem.  if I add a 
contact, the Turba interface indicates;

test  test added.
followed by 
The contact you requested does not exist.

If I then run a simple search for the "test" contact, turba shows it to me as a 
clickable link.  This is the query it then sends to show it;

                     91 Query       SELECT object_id, owner_id, object_type, 
object_members, object_uid, object_firstname, object_lastname, 
object_middlenames, object_nameprefix, object_namesuffix, object_alias, 
object_bday, object_homestreet, object_homepob, object_homecity, 
object_homeprovince, object_homepostalcode, object_homecountry, 
object_workstreet, object_workpob, object_workcity, object_workprovince, 
object_workpostalcode, object_workcountry, object_tz, object_email, 
object_homephone, object_workphone, object_cellphone, object_fax, object_pager, 
object_title, object_role, object_company, object_category, object_notes, 
object_url, object_freebusyurl, object_pgppublickey, object_smimepublickey FROM 
turba_objects WHERE (owner_id = 'cflav' AND ((LOWER(object_nameprefix) LIKE 
LOWER('%test%') OR LOWER(object_firstname) LIKE LOWER('%test%') OR 
LOWER(object_middlenames) LIKE LOWER('%test%') OR LOWER(object_lastname) LIKE 
LOWER('%test%') OR LOWER(object_namesuffix) LIKE LOWER('%test%'))))
                     91 Init DB     horde
                     91 Query       SELECT object_id, object_type, owner_id, 
object_nameprefix, object_firstname, object_middlenames, object_lastname, 
object_namesuffix FROM turba_objects WHERE (object_type = 'Group' AND owner_id = 
'cflav')
                     91 Quit


Now, it is looking for "object_type="group"", however it is saved in the db as 
object_type "Object";

mysql> select * from turba_objects;
+----------------------------------+----------+-------------+---------------------------------------------------+----------------+------------------+-----------------+--------------------+-------------------+-------------------+--------------+--------------+------------------+-------------+-------------------+----------------+-----------------+---------------------+-----------------------+--------------------+-------------------+----------------+-----------------+---------------------+-----------------------+--------------------+-----------+------------+--------------+------------------+------------------+------------------+------------+--------------+--------------+-------------+-------------+-----------------+----------------+-----------------+--------------+------------+--------------------+---------------------+-----------------------+

| object_id                        | owner_id | object_type | 
object_uid                                        | object_members | 
object_firstname | object_lastname | object_middlenames | object_nameprefix | 
object_namesuffix | object_alias | object_photo | object_phototype | object_bday 
| object_homestreet | object_homepob | object_homecity | object_homeprovince | 
object_homepostalcode | object_homecountry | object_workstreet | object_workpob 
| object_workcity | object_workprovince | object_workpostalcode | 
object_workcountry | object_tz | object_geo | object_email | object_homephone | 
object_workphone | object_cellphone | object_fax | object_pager | object_title | 
object_role | object_logo | object_logotype | object_company | object_category | 
object_notes | object_url | object_freebusyurl | object_pgppublickey | 
object_smimepublickey |
+----------------------------------+----------+-------------+---------------------------------------------------+----------------+------------------+-----------------+--------------------+-------------------+-------------------+--------------+--------------+------------------+-------------+-------------------+----------------+-----------------+---------------------+-----------------------+--------------------+-------------------+----------------+-----------------+---------------------+-----------------------+--------------------+-----------+------------+--------------+------------------+------------------+------------------+------------+--------------+--------------+-------------+-------------+-----------------+----------------+-----------------+--------------+------------+--------------------+---------------------+-----------------------+

| 74c773c81df954eaf2b0bfddb682abd9 | cflav    | Object      | 
20101126152313.225210y7w1lvc4z4 at nat.localhost.localdomain | NULL           | 
test             | test            |                    |                   
|                   |              | NULL         | NULL             | 
NULL        |                   |                |                 
|                     |                       |                    
|                   |                |                 |                     
|                       |                    |           | NULL       
|              |                  |                  |                  
|            |              |              |             | NULL        | 
NULL            |                |                 |              |            
|                    |                     |                       |
+----------------------------------+----------+-------------+---------------------------------------------------+----------------+------------------+-----------------+--------------------+-------------------+-------------------+--------------+--------------+------------------+-------------+-------------------+----------------+-----------------+---------------------+-----------------------+--------------------+-------------------+----------------+-----------------+---------------------+-----------------------+--------------------+-----------+------------+--------------+------------------+------------------+------------------+------------+--------------+--------------+-------------+-------------+-----------------+----------------+-----------------+--------------+------------+--------------------+---------------------+-----------------------+





So out of the box I seem to hit a wall.  Any tips?

Thanks,

C. Flav