[horde] Oracle syntax problem

[Ico Izquierdo]

I feel like in a downward spiral, ;-)

FYI,
1.- patches you've offered me works.

2.- Then I've found a new problem in the same files, (syntax again):

sql.php.seg:663:            $query .= ' LEFT JOIN ' . $this->_table . 
'_users AS u ON u.share_id = s.share_id';
sql.php.seg:678:                $query .= ' LEFT JOIN ' . $this->_table 
. '_groups AS g ON g.share_id = s.share_id';
sql_hierarchical.php.seg:215:            $query .= ' LEFT JOIN ' . 
$this->_table . '_users AS u ON u.share_id = s.share_id';
sql_hierarchical.php.seg:230:                $query .= ' LEFT JOIN ' . 
$this->_table . '_groups AS g ON g.share_id = s.share_id';

solved removing "AS " in four previous lines.

3.- Now I have a new problem adding a record in Turba. It's likean error 
translating values from form to sql sentence

Error code:

Mar 25 14:30:16 HORDE [error] [turba] DB Error: unknown error: INSERT 
INTO turba_objects (object_type, object_firstname, object_lastname, 
object_middlenames, object_nameprefix, object_namesuffix, object_alias, 
object_bday, object_photo, 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_logo, object_category, object_notes, object_url, 
object_freebusyurl, object_pgppublickey, object_smimepublickey, 
owner_id, object_uid, object_id) VALUES ('Object', 'nombre', 'apellido', 
'adicional', 'prefijo', 'sufijo', 'mote', '2009-03-09', 'Array', 
'callep', 'nombre'0, 'nombre'1, 'nombre'2, 'nombre'3, 'nombre'4, 
'nombre'5, 'nombre'6, 'nombre'7, 'nombre'8, 'nombre'9, 'apellido'0, 
'apellido'1, 'apellido'2, 'apellido'3, 'apellido'4, 'apellido'5, 
'apellido'6, 'apellido'7, 'apellido'8, 'apellido'9, 'adicional'0, 
'adicional'1, 'adicional'2, 'adicional'3, 'adicional'4, 'adicional'5, 
'adicional'6, 'adicional'7, 'adicional'8, 'adicional'9, 'prefijo'0) 
[nativecode=ORA-01465: invalid hex number] [pid 26659 on line 300 of 
"/srv/www/htdocs/horde/turba/lib/Driver/sql.php"]
Mar 25 14:30:16 HORDE [error] [turba] DB Error: unknown error: INSERT 
INTO turba_objects (object_type, object_firstname, object_lastname, 
object_middlenames, object_nameprefix, object_namesuffix, object_alias, 
object_bday, object_photo, 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_logo, object_category, object_notes, object_url, 
object_freebusyurl, object_pgppublickey, object_smimepublickey, 
owner_id, object_uid, object_id) VALUES ('Object', 'nombre', 'apellido', 
'adicional', 'prefijo', 'sufijo', 'mote', '2009-03-09', 'Array', 
'callep', 'nombre'0, 'nombre'1, 'nombre'2, 'nombre'3, 'nombre'4, 
'nombre'5, 'nombre'6, 'nombre'7, 'nombre'8, 'nombre'9, 'apellido'0, 
'apellido'1, 'apellido'2, 'apellido'3, 'apellido'4, 'apellido'5, 
'apellido'6, 'apellido'7, 'apellido'8, 'apellido'9, 'adicional'0, 
'adicional'1, 'adicional'2, 'adicional'3, 'adicional'4, 'adicional'5, 
'adicional'6, 'adicional'7, 'adicional'8, 'adicional'9, 'prefijo'0) 
[nativecode=ORA-01465: invalid hex number] [pid 26659 on line 84 of 
"/srv/www/htdocs/horde/turba/lib/Forms/AddContact.php"]

Thank you.
Ico Izquierdo

Michael Rubinsky escribió:
>
> Quoting Jan Schneider <jan at horde.org>:
>
>> Zitat von Michael Rubinsky <mrubinsk at horde.org>:
>>
>>>
>>> Quoting Ico Izquierdo <ico at cc.upv.es>:
>>>
>>>> Hello,
>>>> I've installed Horde Groupware working with Oracle as database.
>>>> All connections seems work properly but a few ones.
>>>> I think the problem is that some .php don't use MDB2 to build sql
>>>> sentences, then the syntax are no correct.
>>>> Could you send any help?
>>>> Thanks in advance.
>>>>
>>>> Ico Izquierdo
>>>> ASIC - UPV
>>>>
>>>> Error codes are:
>>>> *---------------------------------------------------------------------------------------------------------------* 
>>>>
>>>> Mar 23 11:15:36 HORDE [error] [kronolith] MDB2 Error: unknown
>>>> error: _doQuery: [Error message: Could not execute statement]
>>>> [Last executed query: SELECT DISTINCT s.*  FROM kronolith_shares s
>>>> WHERE (s.perm_guest & 2) != 0 ORDER BY s.attribute_name ASC]
>>>
>>> It would appear that Oracle doesn't understand '&' to be a bitwise
>>> AND operation, instead, needing to use the BITAND function. I don't
>>> believe MDB2 would be any help here...
>>
>> Horde_Shares_sql should use Horde_SQL::buildClause().
>
>
> Done. Can you verify that this fixes things for you?
>
> http://lists.horde.org/archives/cvs/Week-of-Mon-20090323/087278.html
>
>
> Thanks,
> mike
>
> -- 
> The Horde Project (www.horde.org)
> mrubinsk at horde.org
>
> "Time just hates me. That's why it made me an adult." - Josh Joplin
> -- 
> Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org