[horde] Export user's preferences

[Vilius Sumskas/LNK]

> > Hi,
> >
> >> My Horde data base is probably corrupted, here are some of the
> >> problems some users are having:
> >>
> >> - some users cannot select the address book to "save recipients
> >> automatically" in IMP preferences;
> >> - some users cannot see its contacts and they are unnable to export 
it;
> >> - some users cannot use its calendar and they are unnable to export 
it;
> >
> > Looks like something went wrong in the Share system. Have you changed
> > charsets in the database recently? Also, what do you mean by "cannot 
see
> > its calendar"? They cannot see it in the calendar list, or they just
> > cannot see events in the calendar? Did you try to increase Horde 
logging
> > level and check for SQL errors?
> 
> You are right, I remember years ago we used a Portuguese Debian 
installation.
> 
> The calendar itself is there but some events do not show and the 
> calendar cannot be exported.
> 
> I will increase Horde logging level and will check for Sql errors.
> 
> >
> >> Those are users that have been using Horde for a long time.
> >>
> >> I have tried to "horde-remove-user-data" for one of those users but 
it
> >> did not solve the problem for him.
> >
> > If clearing data for a user doesn't solve the problem, then there is 
no
> > point exporting/importing. Have you tried with a newly created user?
> 
> Newly created users are OK.
> 
> There is no point exporting/importing for those that are having 
> problem, but will do for those that are not having problem. The idea 
> is to export whatever data can be exported, start a new empty database 
> and import back the data. When I say export I mean via Horde (ics, 
> csv, vcard, icalendar) or via mysql for those that are OK.

If newly created users are OK, then I would run "horde-remove-user-data" 
for one bad user and then search database tables for that user to see what 
the script have missed.

There is no magic really. That script is not updated constantly so it is 
probably missing some tables.

-- 
   Vilius