Welcome Guest, Not a member yet? Register   Sign In
Oracle OCI8 support for CI 4
#23

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:, :dataSmile', $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
Reply


Messages In This Thread
Oracle OCI8 support for CI 4 - by ajk - 05-07-2020, 04:03 PM
RE: Oracle OCI8 support for CI 4 - by kilishan - 05-07-2020, 09:03 PM
RE: Oracle OCI8 support for CI 4 - by ajk - 04-15-2021, 11:57 AM
RE: Oracle OCI8 support for CI 4 - by kenjis - 10-13-2021, 12:11 AM
RE: Oracle OCI8 support for CI 4 - by b126 - 10-30-2021, 01:28 PM
RE: Oracle OCI8 support for CI 4 - by gurthang75 - 10-25-2021, 01:08 PM
RE: Oracle OCI8 support for CI 4 - by kenjis - 10-30-2021, 04:16 PM
RE: Oracle OCI8 support for CI 4 - by gurthang75 - 10-26-2021, 01:44 PM
RE: Oracle OCI8 support for CI 4 - by gurthang75 - 11-23-2021, 09:07 AM
RE: Oracle OCI8 support for CI 4 - by rocksvern - 11-29-2021, 07:51 AM
RE: Oracle OCI8 support for CI 4 - by gurthang75 - 12-09-2021, 05:24 AM
RE: Oracle OCI8 support for CI 4 - by kenjis - 11-28-2021, 06:16 PM
RE: Oracle OCI8 support for CI 4 - by kenjis - 11-30-2021, 01:01 AM
RE: Oracle OCI8 support for CI 4 - by kenjis - 12-29-2021, 02:48 AM
RE: Oracle OCI8 support for CI 4 - by kenjis - 01-25-2022, 04:54 PM
RE: Oracle OCI8 support for CI 4 - by b126 - 02-11-2022, 06:05 PM
RE: Oracle OCI8 support for CI 4 - by kenjis - 06-08-2022, 05:23 PM
RE: Oracle OCI8 support for CI 4 - by b126 - 02-21-2023, 09:32 AM
RE: Oracle OCI8 support for CI 4 - by luckmoshy - 06-08-2022, 11:33 PM
RE: Oracle OCI8 support for CI 4 - by nilo - 11-29-2023, 04:33 PM
RE: Oracle OCI8 support for CI 4 - by kenjis - 11-29-2023, 04:47 PM
RE: Oracle OCI8 support for CI 4 - by nilo - 12-04-2023, 01:18 AM
RE: Oracle OCI8 support for CI 4 - by kenjis - 06-26-2024, 06:33 PM



Theme © iAndrew 2016 - Forum software by © MyBB