Tickets :: Comment on [#9151] Kronolith, Nag, Mnemo, Turba don't work with Oracle DB

* Your Email Address
* Spam protection	Enter the letters below: . ..___.._..__ .___. \| \| _/ \| [__) _/ \|__\|./__._\|_\| \./__.
Comment	> tried - worked. Thanks a lot. > Connections to the database are made and its doing inserts and updates. > > BUT: Now I got lots of errors like this: > > [pid 8797 on line 470 of > "/home/horde/horde-webmail-1.2.6/lib/Horde/Share/sql.php"] > Jul 27 23:47:49 HORDE [error] [mnemo] MDB2 Error: unknown error: > _doQuery: [Error message: Could not execute statement] > [Last executed query: SELECT DISTINCT s.* FROM mnemo_shares s LEFT > JOIN mnemo_shares_users AS u ON u.share_id = s.share_id WHERE > s.share_owner = 'rmarz' OR (bitand(s.per > m_creator, 4) = 4) OR (bitand(s.perm_default, 4) = 4) OR ( u.user_uid > = 'rmarz' AND (bitand(u.perm, 4) = 4)) ORDER BY s.attribute_name ASC] > [Native code: 905] > [Native message: ORA-00905: missing keyword] > > which is caused by the "AS" between table-name and alias in the > outer-joined table. > In this rare case, Oracle follows hard the sql99-Standard, which > says, that "as" is allowed for column aliases and does not mention it > for table-aliases. > > >
Attachment
Watch this ticket