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

Cainan’s picture

Status: Active » Fixed

I have added your fix in the 5.X code release

Anonymous’s picture

Status: Fixed » Closed (fixed)