[horde] Horde database cleanup, not delete everything

[Jan Schneider]

Zitat von Jorge Dionisio Baigorri Salas <anstiac at hotmail.com>:

>
> Hello,
>
> I've been using Horde for about 7 years now, and i've been on a  
> private server since 2005 and i was browsing through the horde  
> database because after upgrading my cpanel i had a client call  
> saying he lost some entries on it's calendar (kronolith) ... i hope  
> & assume it was due to upgrading cpanel.... and had to manually sql  
> to add them from my backup into kronolith_events. And it's here that  
> i came to realize that HORDE does'nt cleanup old entries  
> automatically.. or so i guess because i was looking at entries from  
> 2005!! LOL
>
> So  my question/request would be if there's a way to set/programm a  
> script to automatically cleanup ooold entries? I've already deleted  
> the ones from kronolith_events based on the event date, but i looked  
> in datatree_attributes, histories and prefs and i'm somewhat worried  
> (apart from unwilling to do one by one manually) that i might end up  
> screwing something up.

Why would you want to do that? Besides certain groupware data, this  
doesn't make much sense to me. I can only think of old calendar data  
and old, completed tasks. For calendar data, there is a maintenance  
task since Kronoith 2.3 for that purpose.

> I know this is odd, but if any of you guys are up to the task, that  
> would be great... if not... i'm a programmer myself and if someone  
> points me in the right direction (ie.- which values linked to which  
> fields related to which data i may erase) i would gladly do the  
> script myself and share it here to be posetd somewhere in case  
> anybody needs it too.

Jan.

-- 
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/