[turba] fresh install 2.3.5 mysql weirdness

[Jan Schneider]

Zitat von Chris Flav <chris.flav at yahoo.ca>:

> 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";

Where do you see that? I don't:
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')

> 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
>
>
> --
> Turba mailing list - Join the hunt: http://horde.org/bounties/#turba
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: turba-unsubscribe at lists.horde.org
>



Jan.

-- 
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/