Project

General

Profile

Enhancement #574

Call /usr/share/roundcube/bin/cleandb.sh in a cron job

Added by Pierre-Louis Bonicoli almost 2 years ago. Updated almost 2 years ago.

Status:
Resolved
Priority:
Normal
Category:
Service :: Mail
Start date:
2017-07-05
Due date:
% Done:

100%

Patch Available:
Confirmed:
Yes
Branch:
Entity:
DuckCorp
Security:
Help Needed:

Description

/usr/share/roundcube/bin/cleandb.sh - which finally remove all db records marked as deleted some time ago for 'contacts', 'contactgroups', 'identities' tables - should be called in a cron task.

select count(*) from identities where del=1 and changed < current_date - interval '365' day;
 count 
-------
     1

select count(*) from contactgroups where del=1 and changed < current_date - interval '365' day;
 count 
-------
     0

select count(*) from contacts where del=1 and changed < current_date - interval '365' day;
 count 
-------
    10

History

#1 Updated by Marc Dequènes almost 2 years ago

  • Status changed from New to Resolved
  • Assignee set to Marc Dequènes
  • % Done changed from 0 to 100

already DONE

Also available in: Atom PDF