[horde] Oracle syntax problem

Mon Mar 23 13:39:26 UTC 2009

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]
[Native code: 920]
[Native message: ORA-00920: invalid relational operator]
 [pid 3007 on line 1330 of 
"/srv/www/htdocs/horde/kronolith/lib/Kronolith.php"]
Mar 23 11:15:36 HORDE [error] [nag] MDB2 Error: unknown error: _doQuery: 
[Error message: Could not execute statement]
[Last executed query: SELECT DISTINCT s.*  FROM nag_shares s  WHERE 
(s.perm_guest & 2) != 0 ORDER BY s.attribute_name ASC]
[Native code: 920]
[Native message: ORA-00920: invalid relational operator]
 [pid 3007 on line 457 of "/srv/www/htdocs/horde/lib/Horde/Share/sql.php"]
Mar 23 11:15:36 HORDE [error] [nag] MDB2 Error: unknown error: _doQuery: 
[Error message: Could not execute statement]
[Last executed query: SELECT DISTINCT s.*  FROM nag_shares s  WHERE 
(s.perm_guest & 2) != 0 ORDER BY s.attribute_name ASC]
[Native code: 920]
[Native message: ORA-00920: invalid relational operator]
 [pid 3007 on line 281 of "/srv/www/htdocs/horde/nag/lib/Nag.php"]
Mar 23 11:15:36 HORDE [error] [nag] MDB2 Error: unknown error: _doQuery: 
[Error message: Could not execute statement]
[Last executed query: SELECT DISTINCT s.*  FROM nag_shares s  WHERE 
(s.perm_guest & 2) != 0 ORDER BY s.attribute_name ASC]
[Native code: 920]
[Native message: ORA-00920: invalid relational operator]
 [pid 3007 on line 457 of "/srv/www/htdocs/horde/lib/Horde/Share/sql.php"]
Mar 23 11:15:36 HORDE [error] [nag] MDB2 Error: unknown error: _doQuery: 
[Error message: Could not execute statement]
[Last executed query: SELECT DISTINCT s.*  FROM nag_shares s  WHERE 
(s.perm_guest & 2) != 0 ORDER BY s.attribute_name ASC]
[Native code: 920]
[Native message: ORA-00920: invalid relational operator]
 [pid 3007 on line 281 of "/srv/www/htdocs/horde/nag/lib/Nag.php"]
*---------------------------------------------------------------------------------------------------------------*

I've installed the following:

*---------------------------------------------------------------------------------------------------------------*

    * Horde: 3.3.3

    * Dimp: H3 (1.1)
    * Horde: 3.3.3
    * Imp: 4.3.3 (run Imp tests <https://mintaka.cc.upv.es/imp/test.php>)
    * Ingo: H3 (1.2.1) (run Ingo tests
      <https://mintaka.cc.upv.es/ingo/test.php>)
    * Kronolith: H3 (2.3) (run Kronolith tests
      <https://mintaka.cc.upv.es/kronolith/test.php>)
    * Mimp: H3 (1.1.1)
    * Mnemo: H3 (2.2.1)
    * Nag: H3 (2.3)
    * Turba: H3 (2.3.1) (run Turba tests
      <https://mintaka.cc.upv.es/turba/test.php>)

    * View phpinfo() screen
      <https://mintaka.cc.upv.es/test.php?mode=phpinfo&url=%2Ftest.php>
    * View loaded extensions
      <https://mintaka.cc.upv.es/test.php?mode=extensions&url=%2Ftest.php>
    * PHP Version: 5.2.6
    * PHP Major Version: 5.2
    * PHP Minor Version: 6
    * PHP Version Classification: release
    * *You are running a supported version of PHP.*

    * Ctype Support: *Yes*
    * DOM XML Support: *Yes*
    * FTP Support: *Yes*
    * GD Support: *Yes*
    * Gettext Support: *Yes*
    * GeoIP Support (via PECL extension): *No*
      *Horde can optionally use the GeoIP extension to provide faster
      country name lookups.*
    * Iconv Support: *Yes*
    * GNU Iconv Support: *Yes*
    * IMAP Support: *Yes*
    * JSON Support: *Yes*
    * LDAP Support: *Yes*
    * LZF Compression Support: *No*
      *If the lzf PECL module is available, Horde can compress some
      cached data in your session to make your session size smaller.*
    * Mbstring Support: *Yes*
    * PCRE Support: *Yes*
    * PCRE UTF-8 Support: *Yes*
    * Mcrypt Support: *Yes*
    * memcached Support (memcache): *Yes*
    * MIME Magic Support (fileinfo): *Yes*
    * MIME Magic Support (mime_magic): *No*
      *The fileinfo PECL module (see above) or the mime_magic PHP
      extension will most likely provide faster MIME Magic lookups than
      the built-in Horde PHP magic code. See horde/docs/INSTALL for
      information on how to install PECL/PHP extensions.*
    * MySQL Support: *Yes*
    * OpenSSL Support: *Yes*
    * PostgreSQL Support: *No*
      *The PostgreSQL extension is only required if you want to use a
      PostgreSQL database server for data storage.*
    * Session Support: *Yes*
    * XML Support: *Yes*
    * Zlib Support: *Yes*

    * magic_quotes_runtime disabled: *Yes*
    * memory_limit value: 128M
      *If PHP's internal memory limit is not set high enough Horde will
      not be able to handle large data items (e.g. large mail
      attachments in IMP). You should set the value of memory_limit in
      php.ini to a sufficiently high value - at least 64M is recommended.*
    * safe_mode disabled: *Yes*
    * session.use_trans_sid disabled: *Yes*
    * session.auto_start disabled: *Yes*
    * zlib.output_compression disabled: *Yes*
    * zend_accelerator.compress_all disabled: *Yes*

    * file_uploads enabled: *Yes*
    * upload_tmp_dir: */tmp*
    * upload_max_filesize: 2M
    * post_max_size: 8M
      This value should be several times the expect largest upload size
      (notwithstanding any upload limits present in an application). Any
      upload that exceeds this size will cause any state information
      sent along with the uploaded data to be lost. This is a PHP
      limitation and can not be worked around.

    * config/conf.php: *Yes*
    * config/mime_drivers.php: *Yes*
    * config/nls.php: *Yes*
    * config/prefs.php: *Yes*
    * config/registry.php: *Yes*

    * Session counter: 5
    * To unregister the session: click here
      <https://mintaka.cc.upv.es/test.php?mode=unregister>

    * *PEAR Search Path (PHP's include_path)*:
       /srv/www/htdocs/horde/lib:/srv/www/htdocs/horde/lib/../pear
    * PEAR: *Yes*
    * Recent PEAR: *Yes*
    * Mail: *Yes*
    * Mail_Mime: *Yes*
    * Mail_mimeDecode: *Yes*
    * Log: *Yes*
    * DB: *Yes*
    * MDB2: *Yes*
    * Net_Socket: *Yes*
    * Date: *Yes*
    * Auth_SASL: *Yes*
    * HTTP_Request: *Yes*
    * HTTP_WebDAV_Server: *Yes*
    * Net_SMTP: *Yes*
    * Services_Weather: *Yes*
    * Cache: *Yes*
    * XML_Serializer: *Yes*

*---------------------------------------------------------------------------------------------------------------* 