Installing the module to a postgreSQL or MySQL database in ANSI SQL mode fails with a database error, because some queries contain string literals delimited with " double quotes rather than the ANSI SQL92 standard ' single quotes. MySQL's default is to treat "-delimited strings as string literals, but postgres and MySQL in ANSI mode interpret "-delimited strings as quoted identifiers.

The attached patch replaces occurrences of double-quotes around SQL string literals with single quotes, allowing the module to install on all supported databases.

CommentFileSizeAuthor
#1 psql.patch6.78 KBAnonymous (not verified)

Comments

Anonymous’s picture

Anonymous (not verified) commented
StatusFileSize
new psql.patch6.78 KB

Looks like my patch didn't get attached.

agittins’s picture

agittins commented

Excellent, thanks for that patch, enp - also a Postgres shop here so much appreciated. Would be great if this could be drawn into a new release...

FYI, if you have already installed the module, then disable it, then "uninstall" the module (admin, site building, modules, uninstall), then enable it again - this makes sure that the installation sets up the rules and groups for you (otherwise the rules and group tabs will be empty).

HS’s picture

HS commented
Status: Active » Needs review