There is a bug with postgresql and this line :
db_query("UPDATE {comment_notify} c SET c.notify = 0 WHERE notify_hash = '%s'", $arg);

It seems that "c" aliasing is not working but this is working :
db_query("UPDATE {comment_notify} SET notify = 0 WHERE notify_hash = '%s'", $arg);

CommentFileSizeAuthor
#2 comment_notify.patch702 bytesYoran

Comments

greggles’s picture

greggles
he/him
Primary language English
Location Denver, Colorado, USA
commented
Status: Needs review » Active

I know it's small, but could you make an actual patch?

Yoran’s picture

Yoran commented
StatusFileSize
new comment_notify.patch702 bytes

You are very lasy today :-)

Well... Here it is :)

greggles’s picture

greggles
he/him
Primary language English
Location Denver, Colorado, USA
commented
Status: Active » Fixed

I tested this on mysql for 6.x and it worked fine. Committed to 6 and backported to 5. Thanks!

Status: Fixed » Closed (fixed)

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