SQL statements like

$request = 'SELECT count(*) FROM {users} WHERE uid <> "0"';
Should be replaced with
$request = "SELECT count(*) FROM {users} WHERE uid <> '0'";
so that they also work with PSQL out of the box.

Alternatively the quotes around the number could be dropped completely since uid is an integer field.

CommentFileSizeAuthor
#1 1451038-1-sql-cleanup.patch687 bytesgeerlingguy

Comments

geerlingguy’s picture

geerlingguy commented
Status: Active » Needs review
StatusFileSize
new 1451038-1-sql-cleanup.patch687 bytes

This patch should fix the queries.

geerlingguy’s picture

geerlingguy commented
Status: Needs review » Fixed

Fixed in commit: http://drupalcode.org/project/user_limit.git/commit/a654142

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.