+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Problem with CI Session class + Oracle DB driver (/showthread.php?tid=24522)
Problem with CI Session class + Oracle DB driver - El Forum - 11-12-2009
[eluser]Rob Stefanussen[/eluser]
Hi all,
I've run into an issue with the CI session class when used with the Oracle DB driver. In my searching, I came across this thread which had some useful information in it: http://ellislab.com/forums/viewthread/129918/#656946
Whenever there's a sess_update(), the script blows with an error. This an example query:
Code:
UPDATE "ci_sessions" SET "last_activity" = 1257986513, "session_id" = '73e6752f63e7ede91722a36b66a54dda' WHERE session_id = 'ded5e6dd8cccf9d5602e46cf1baa668d'I did some troubleshooting in Oracle's "Application Express" and discovered that the query works if the last "session_id" is wrapped in double-quotes like the one before it. I found it odd that CI's DB class is enclosing the first "session_id" in double-quotes, but not the last. Does anyone have any pointers? I wanted to try my luck here in hopes that there is someone who has more expertise before I go tearing the DB class apart.
Thanks!
Rob Stefanussen
Problem with CI Session class + Oracle DB driver - El Forum - 11-12-2009
[eluser]Rob Stefanussen[/eluser]
bump