Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
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 CreditAttribution: Cainan commentedI have added your fix in the 5.X code release
Comment #2
(not verified) CreditAttribution: commented