Project

General

Profile

Actions
Copy link

Enhancement #574

closed

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

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

Status:
Resolved
Priority:
Normal
Assignee:
Marc Dequènes
Category:
Service :: Mail
Start date:
2017-07-05
Due date:
% Done:

100%

Estimated time:
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
Actions
Copy link
 #1

Updated by Marc Dequènes almost 8 years ago

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

already DONE

Actions
Copy link

Also available in: Atom PDF