Hi guys... when I connect to OCI8 everything is ok (at this moment) but if I switch the session from file to DB error appear ..
the project is migrated from php 7.4 to php 8.2 and and the db is the same, any idea ?
***!*** Fatal error: Uncaught ErrorException: oci_execute(): ORA-00904: "NOW": invalid identifier in /var/www/html/frm-new/vendor/codeigniter4/framework/system/Database/OCI8/Connection.php:199 Stack trace: #0 [internal function]: CodeIgniter\Debug\Exceptions->errorHandler(2, 'oci_execute(): ...', '/var/www/html/f...', 199) #1 /var/www/html/frm-new/vendor/codeigniter4/framework/system/Database/OCI8/Connection.php(199): oci_execute(Resource id #261, 32) #2 /var/www/html/frm-new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(693): CodeIgniter\Database\OCI8\Connection->execute('INSERT INTO "ci...') #3 /var/www/html/frm-new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(607): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO "ci...') #4 /var/www/html/frm-new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2308): CodeIgniter\Database\BaseConnection->query('INSERT INTO "ci...', Array, false) #5 /var/www/html/frm-new/vendor/codeigniter4/framework/system/Session/Handlers/DatabaseHandler.php(197): CodeIgniter\Database\BaseBuilder->insert(Array) #6 [internal function]: CodeIgniter\Session\Handlers\DatabaseHandler->write('rjkmajal04ekp8m...', '__ci_last_regen...') #7 [internal function]: session_write_close() #8 {main} Next CodeIgniter\Database\Exceptions\DatabaseException: oci_execute(): ORA-00904: "NOW": invalid identifier in /var/www/html/frm-new/vendor/codeigniter4/framework/system/Database/OCI8/Connection.php:211 Stack trace: #0 /var/www/html/frm-new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(693): CodeIgniter\Database\OCI8\Connection->execute('INSERT INTO "ci...') #1 /var/www/html/frm-new/vendor/codeigniter4/framework/system/Database/BaseConnection.php(607): CodeIgniter\Database\BaseConnection->simpleQuery('INSERT INTO "ci...') #2 /var/www/html/frm-new/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2308): CodeIgniter\Database\BaseConnection->query('INSERT INTO "ci...', Array, false) #3 /var/www/html/frm-new/vendor/codeigniter4/framework/system/Session/Handlers/DatabaseHandler.php(197): CodeIgniter\Database\BaseBuilder->insert(Array) #4 [internal function]: CodeIgniter\Session\Handlers\DatabaseHandler->write('rjkmajal04ekp8m...', '__ci_last_regen...') #5 [internal function]: session_write_close() #6 {main} Next CodeIgniter\Database\Exceptions\DatabaseException: oci_execute(): ORA-00904: "NOW": invalid identifier in /var/www/html/frm-new/vendor/codeigniter4/framework/system/Database/BaseConnection.php on line 647
***!*** CodeIgniter\Database\Exceptions\DatabaseException: oci_execute(): ORA-00904: "NOW": invalid identifier in /var/www/html/frm-new/vendor/codeigniter4/framework/system/Database/BaseConnection.php on line 647
***!*** Time Memory Function Location
1 0.6784 9197336 session_write_close( ) .../Unknown:0
2 0.6784 9197592 CodeIgniter\Session\Handlers\DatabaseHandler->write( $id = 'rjkmajal04ekp8mmlbdbc74cl7dt6ali', $data = '__ci_last_regenerate|i:1701299372;_ci_previous_url|s:27:"https://frm-new.local/login";' ) .../DatabaseHandler.php:0
3 0.6784 9199352 CodeIgniter\Database\BaseBuilder->insert( $set = ['id' => 'chts:rjkmajal04ekp8mmlbdbc74cl7dt6ali', 'ip_address' => '172.23.0.1', 'data' => '__ci_last_regenerate|i:1701299372;_ci_previous_url|s:27:"https://frm-new.local/login";'], $escape = ??? ) .../DatabaseHandler.php:197
4 0.6785 9200112 CodeIgniter\Database\BaseConnection->query( $sql = 'INSERT INTO "ci_sessions" ("timestamp", "id", "ip_address", "data") VALUES (now(), :id:, :ip_address:, :data
', $binds = ['id' => [0 => 'chts:rjkmajal04ekp8mmlbdbc74cl7dt6ali', 1 => TRUE], 'ip_address' => [0 => '172.23.0.1', 1 => TRUE], 'data' => [0 => '__ci_last_regenerate|i:1701299372;_ci_previous_url|s:27:"https://frm-new.local/login";', 1 => TRUE]], $setEscapeFlags = FALSE, $queryClass = ??? ) .../BaseBuilder.php:2308
Oracle OCI8 support for CI 4
