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

Status: Active » Needs review
StatusFileSize
new687 bytes

This patch should fix the queries.

geerlingguy’s picture

Status: Needs review » Fixed

Status: Fixed » Closed (fixed)

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