Closed (fixed)
Project:
Session Limit
Version:
4.7.x-1.x-dev
Component:
Code
Priority:
Critical
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
16 Jan 2007 at 14:47 UTC
Updated:
9 Mar 2007 at 21:02 UTC
Greetings.
I'm using your module for my project which is working with PostgreSQL. I have a problem in DELETE SQL statement when removing a selected session id:
db_query('DELETE from {sessions} where sid = "%s"',$edit['sid']);
It is not allowed to wrap string constants with "" in PostgreSQL. You should use '' instead. The fix is as follows:
db_query("DELETE from {sessions} where sid = '%s'",$edit['sid']);
I did it for myself and this was tested in both MySQL and PostgreSQL. Please, fix this in your module for HEAD and 4.7.
Thank you.
Comments
Comment #1
Cainan commentedI have added your fix in the 5.X code release
Comment #2
(not verified) commented