View | Details | Raw Unified | Return to bug 34027
Collapse All | Expand All

(-)a/misc/cronjobs/cleanup_database.pl (-1 / +4 lines)
Lines 397-402 if ($pZ3950) { Link Here
397 

          397
          

        

        

          398
          
if ($pLogs) {

          398
          
if ($pLogs) {

        

        

          399
          
    print "Purging records from action_logs.\n" if $verbose;

          399
          
    print "Purging records from action_logs.\n" if $verbose;

        

            

              
              
              400
              
    for (0..10000){

            

            

              401
              
        $dbh->do(q{ INSERT INTO action_logs (user,timestamp) VALUES (52,"2022-01-01 09:00:00") });

            

            

              402
              
        $dbh->do(q{ UPDATE action_logs SET timestamp = "2020-01-01 10:00:00" ORDER BY action_id DESC LIMIT 1 });

            

            

              403
              
    }

            

        

          400
          
    my $log_query = q{

          404
          
    my $log_query = q{

        

        

          401
          
            DELETE FROM action_logs

          405
          
            DELETE FROM action_logs

        

        

          402
          
            WHERE timestamp < date_sub(curdate(), INTERVAL ? DAY)

          406
          
            WHERE timestamp < date_sub(curdate(), INTERVAL ? DAY)

        

            

              403
              
- 

              
              
            






  

  Return to bug 34027