Login

01-17-2012, 04:29 PM

[eluser]ee99ee[/eluser]
We just deployed CI 2.1 against Oracle for session data storage. We are getting the following error on load:

Code:
A PHP Error was encountered

Severity: Warning

Message: oci_fetch_assoc() [function.oci-fetch-assoc]: ORA-01002: fetch out of sequence

Filename: oci8/oci8_result.php

Line Number: 155

This error is being triggered here (Session.php, line 216):

Code:
// No result?  Kill it!

if ($query->num_rows() == 0) // <--- fails here

{

 $this->sess_destroy();

 return FALSE;

}

I verified the schema of CI_SESSIONS is correct. Here is the setting of database.php:

Code:
$active_group = 'default';

$active_record = TRUE;

$db['default']['hostname'] = '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = database.server)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SID = ******)))';

$db['default']['username'] = '*******';

$db['default']['password'] = '*******';

$db['default']['database'] = '*******';

$db['default']['dbdriver'] = 'oci8';

$db['default']['dbprefix'] = 'SCHEMA_OWNER.';

$db['default']['pconnect'] = TRUE;

$db['default']['db_debug'] = TRUE;

$db['default']['cache_on'] = FALSE;

$db['default']['cachedir'] = '';

$db['default']['char_set'] = 'utf8';

$db['default']['dbcollat'] = 'utf8_general_ci';

$db['default']['swap_pre'] = '';

$db['default']['autoinit'] = TRUE;

$db['default']['stricton'] = FALSE;

Any ideas?

-Chris