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