Andreas Echavez (oceanplexian) wrote in changelog,
Andreas Echavez
oceanplexian
changelog

[livejournal] r23513: See http://rt.corp.livejournal.org/Ticke...

Committer: andreas
See http://rt.corp.livejournal.org/Ticket/Display.html?id=2096#txn-45877. DO NOT check this out on admin02 until we've had time to properly flush the DB manually
U   trunk/bin/maint/clean_caches.pl
Modified: trunk/bin/maint/clean_caches.pl
===================================================================
--- trunk/bin/maint/clean_caches.pl	2012-12-28 13:03:07 UTC (rev 23512)
+++ trunk/bin/maint/clean_caches.pl	2012-12-30 20:59:22 UTC (rev 23513)
@@ -205,7 +205,7 @@
     print "-I- Cleaning comet_history.\n";
     foreach my $c (@LJ::CLUSTERS) {
         my $dbcm = LJ::get_cluster_master($c);
-        $dbcm->do("DELETE FROM comet_history WHERE added < UNIX_TIMESTAMP() - 86400*10 LIMIT 100000");
+        $dbcm->do("DELETE FROM comet_history WHERE added < FROM_UNIXTIME( UNIX_TIMESTAMP() - 86400*10 ) LIMIT 100000");
     }
     LJ::disconnect_dbs();
 

Tags: andreas, livejournal, oceanplexian, pl
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