In comment_notify_page:

      db_query("UPDATE {comments} c, users u                                    
          SET c.notify = 0
          WHERE u.uid = c.uid                                                     
          AND md5(concat(c.mail, ifnull(u.mail, u.init), c.uid, c.name, c.nid))\
 = '%s'",
        $arg
      );

it should be "UPDATE {comments} c, {users} u" in order for the tables to be prefixed properly.

CommentFileSizeAuthor
#1 db_prefix_219677.patch775 bytesgreggles
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

greggles’s picture

Assigned: Unassigned » greggles
Status: Active » Needs review
FileSize
775 bytes

How does this look?

greggles’s picture

Status: Needs review » Fixed

xen commented that it looked fine in IRC so I've committed this.

Xen’s picture

Hear hear. I looked long and hard at it, and can't see any possibility for error..

Anonymous’s picture

Status: Fixed » Closed (fixed)

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