Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
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.
Comment | File | Size | Author |
---|---|---|---|
#1 | db_prefix_219677.patch | 775 bytes | greggles |
Comments
Comment #1
gregglesHow does this look?
Comment #2
gregglesxen commented that it looked fine in IRC so I've committed this.
Comment #3
Xen CreditAttribution: Xen commentedHear hear. I looked long and hard at it, and can't see any possibility for error..
Comment #4
Anonymous (not verified) CreditAttribution: Anonymous commentedAutomatically closed -- issue fixed for two weeks with no activity.