[Tickets #533] NEW: oci8 sessionhandler

[bugs at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/?id=533
-----------------------------------------------------------------------
 Ticket     | 533
 Created By | trent.hornibrook at gmail.com
 Summary    | oci8 sessionhandler
 Queue      | Horde Base
 Version    | 2.2.5
 State      | Unconfirmed
 Priority   | 2. Medium
 Type       | Bug
 Owners     | 
-----------------------------------------------------------------------


trent.hornibrook at gmail.com (2004-09-02 00:08) wrote:


The oci8 sessionhandler does not appear to work at all.

I'm running
php-4.3.2-11.1.ent
httpd-2.0.46-32.ent.3
oracle-9.2.0.4

When attempting to log in:

Warning: ociexecute(): OCIStmtExecute: ORA-00933: SQL command not properly
ended in /export/san_mail/htdocs/horde/lib/SQL.php on line 157

Warning: ocifetchinto(): OCIFetchInto: ORA-24374: define not done before
fetch or execute and fetch in /export/san_mail/htdocs/horde/lib/SQL.php on
line 158

Fatal error: Call to a member function on a non-object in
/export/san_mail/htdocs/horde/lib/SQL.php on line 159

Warning: Unknown(): A session is active. You cannot change the session
module's ini settings at this time. in Unknown on line 0


SQL.php attemps to run this sql:
SELECT session_data FROM horde_sessionhandler FOR UPDATE WHERE session_id =
'xxxxxxxxxxxxxxxxxxxxxxxx'


which is just syntactically incorrect in oracle 9.