wisest owl (wisest_owl) wrote in changelog,
wisest owl
wisest_owl
changelog

[livejournal] r18760: LJSUP-8451. "Moderate Community Submissi...

Committer: gprochaev
LJSUP-8451. "Moderate Community Submissions" have bug

U   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;

Tags: livejournal, pm, wisest-owl
Subscribe
  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

  • 0 comments