Committer: gprochaev
LJSUP-8451. "Moderate Community Submissions" have bugU trunk/cgi-bin/LJ/Browse.pm
Modified: trunk/cgi-bin/LJ/Browse.pm =================================================================== --- trunk/cgi-bin/LJ/Browse.pm 2011-03-31 08:56:38 UTC (rev 18759) +++ trunk/cgi-bin/LJ/Browse.pm 2011-03-31 09:21:03 UTC (rev 18760) @@ -1347,8 +1347,8 @@ or die "unable to contact global db master to create category"; $dbh->do("UPDATE categoryjournals_pending SET status=?, " . - "modid=?, lastupdate=UNIX_TIMESTAMP() WHERE pendid IN(?)", undef, - 'D', $mod_u->userid, @pendids); + "modid=?, lastupdate=UNIX_TIMESTAMP() WHERE pendid IN(".join(",", @pendids).")", undef, + 'D', $mod_u->userid); die $dbh->errstr if $dbh->err; return; @@ -1376,7 +1376,7 @@ # Update moderation table $dbh->do("UPDATE categoryjournals_pending SET status=?, " . "modid=?, lastupdate=UNIX_TIMESTAMP() WHERE pendid IN(".join(",", @pendids).")", undef, - 'A', $mod_u->userid, @pendids); + 'A', $mod_u->userid); die $dbh->errstr if $dbh->err; $self->clear_journals_memcache;