bcit-ci / CodeIgniter

Open Source PHP Framework (originally from EllisLab)
https://codeigniter.com/
MIT License
18.27k stars 7.62k forks source link

DB_query_builder.php and DB_driver.php errors #2014

Closed runcom closed 11 years ago

runcom commented 11 years ago

Just logged these errors:

ERROR - 2012-11-20 17:38:05 --> Severity: Warning --> Illegal string offset 'escape' C:\wamp\www\CI\system\database\DB_query_builder.php 2252 ERROR - 2012-11-20 17:38:05 --> Severity: Warning --> Illegal string offset 'condition' C:\wamp\www\CI\system\database\DB_query_builder.php 2261 ERROR - 2012-11-20 17:38:05 --> Query error: near "session_id": syntax error - Invalid query: UPDATE "usession" SET "last_activity" = 1353433080, "user_data" = 'a:2:{s:9:"user_data";s:0:"";s:9:"logged_in";a:3:{s:2:"id";s:1:"1";s:8:"username";s:3:"bob";s:6:"logout";s:16:"vlUWbVuYhQHBQ9u9";}}' WHERE " AND "session_id" = 'ea5e3e2c4fa14abda8e451a27bfbb657' DEBUG - 2012-11-20 17:38:05 --> Language file loaded: language/english/db_lang.php ERROR - 2012-11-20 17:38:05 --> Severity: Notice --> Undefined index: file C:\wamp\www\CI\system\database\DB_driver.php 1611

Should be simple to fix

runcom commented 11 years ago

This happens either on login and on logout when using save session to database

narfbg commented 11 years ago

CI doesn't have an authentication class. What's the code on your end that does it? Also, are you using the Sessions library from develop or the one from 2.1.x?

runcom commented 11 years ago

I m using the 2.1.3 session TIM: la tua mail in mobilità con il BlackBerry®

-----Original Message----- From: Andrey Andreev notifications@github.com Date: Tue, 20 Nov 2012 10:17:31 To: EllisLab/CodeIgniterCodeIgniter@noreply.github.com Reply-To: EllisLab/CodeIgniter reply@reply.github.com Cc: Antonio Murdacaantonio.murdaca@gmail.com Subject: Re: [CodeIgniter] DB_query_builder.php and DB_driver.php errors (#2014)

CI doesn't have an authentication class. What's the code on your end that does it? Also, are you using the Sessions library from develop or the one from 2.1.x?


Reply to this email directly or view it on GitHub: https://github.com/EllisLab/CodeIgniter/issues/2014#issuecomment-10566091

runcom commented 11 years ago

And yes is a simple login system (really simple: user pass and set session and logout destroy the session) TIM: la tua mail in mobilità con il BlackBerry®

-----Original Message----- From: Andrey Andreev notifications@github.com Date: Tue, 20 Nov 2012 10:17:31 To: EllisLab/CodeIgniterCodeIgniter@noreply.github.com Reply-To: EllisLab/CodeIgniter reply@reply.github.com Cc: Antonio Murdacaantonio.murdaca@gmail.com Subject: Re: [CodeIgniter] DB_query_builder.php and DB_driver.php errors (#2014)

CI doesn't have an authentication class. What's the code on your end that does it? Also, are you using the Sessions library from develop or the one from 2.1.x?


Reply to this email directly or view it on GitHub: https://github.com/EllisLab/CodeIgniter/issues/2014#issuecomment-10566091

runcom commented 11 years ago

This problem of course prevent the application to write/delete the session to/in database and problems on login/logout arise....

narfbg commented 11 years ago

I'm unable to reproduce this. Could you show the code that triggers it?

runcom commented 11 years ago

Of course do you have an email so i can send you the whole application? TIM: la tua mail in mobilità con il BlackBerry®

-----Original Message----- From: Andrey Andreev notifications@github.com Date: Tue, 20 Nov 2012 11:50:04 To: EllisLab/CodeIgniterCodeIgniter@noreply.github.com Reply-To: EllisLab/CodeIgniter reply@reply.github.com Cc: Antonio Murdacaantonio.murdaca@gmail.com Subject: Re: [CodeIgniter] DB_query_builder.php and DB_driver.php errors (#2014)

I'm unable to reproduce this. Could you show the code that triggers it?


Reply to this email directly or view it on GitHub: https://github.com/EllisLab/CodeIgniter/issues/2014#issuecomment-10569895

narfbg commented 11 years ago

Exchanging private emails in order to debug a publicly discussed issue isn't good for collaboration, somebody else might want and/or be able to help and wouldn't be able to. Plus, it would make it hard to follow for people reading these comments.

I wouldn't need the whole application anyway, just post the relevant parts where you set/unset the user_id here. Presumably your login and logout logics.

runcom commented 11 years ago

Sure i m making a github repo for this..so you can directly check this out.. TIM: la tua mail in mobilità con il BlackBerry®

-----Original Message----- From: Andrey Andreev notifications@github.com Date: Tue, 20 Nov 2012 13:26:26 To: EllisLab/CodeIgniterCodeIgniter@noreply.github.com Reply-To: EllisLab/CodeIgniter reply@reply.github.com Cc: Antonio Murdacaantonio.murdaca@gmail.com Subject: Re: [CodeIgniter] DB_query_builder.php and DB_driver.php errors (#2014)

Exchanging private emails in order to debug a publicly discussed issue isn't good for collaboration, somebody else might want and/or be able to help and wouldn't be able to. Plus, it would make it hard to follow for people reading these comments.

I wouldn't need the whole application anyway, just post the relevant parts where you set/unset the user_id here. Presumably your login and logout logics.


Reply to this email directly or view it on GitHub: https://github.com/EllisLab/CodeIgniter/issues/2014#issuecomment-10573777

narfbg commented 11 years ago

... and? :)

I still don't think that the whole app code is needed though.