Keys 2.0 is not compatible with postgres, since LOCATE is a function for mysql.

For postgres I had to replace
LOCATE(rule, '%s')
for
strpos('%s',rule) > 0

CommentFileSizeAuthor
#3 keys-postgresql-support-714110-3.diff627 bytesgreenskin
#2 keys-allsql.patch762 bytesroderik

Comments

Anonymous’s picture

Anonymous (not verified) commented

(continues from initial description)

.... with this I got the debug block to work, but I couldn't get gmaps to work (Gmap 6.x-1.1-rc1); it kept using the initial API key.

roderik’s picture

roderik
Primary language Dutch
Location Amsterdam,NL / Budapest,HU
commented
StatusFileSize
new keys-allsql.patch762 bytes

Use this: POSITION(rule IN '%s')

The syntax is... creepy, but it's apparently an SQL defined standard function...

greenskin’s picture

greenskin commented
Status: Active » Needs review
StatusFileSize
new keys-postgresql-support-714110-3.diff627 bytes

Does this patch work? I'm not sure why I went with LOCATE originally rather than LIKE.