I copied an account to another server and all the horde preferences are gone

BianchiDude

Well-Known Member
PartnerNOC
Jul 2, 2005
617
0
166
I copied an account to another server and all the horde preferences are gone, the footer, etc.

How do I get those back?
 

cyon

Well-Known Member
PartnerNOC
Jan 15, 2003
314
0
241
the script /scripts/pkgacct doesn't dump all data from the horde table and this causes some missing stuff on the new system.

here is a fix:

search the following line in the script /scripts/pkgacct on your source-server:

exec("mysqldump","-c","-Q","-q","-t","-w","owner_id REGEXP '@(${dnslist})\$'","horde","turba_objects");
replace this line with the following code:

system("mysqldump","-c","-Q","-q","-t","-w","owner_id REGEXP '@(${dnslist})\$'","horde","turba_objects");
system("mysqldump","-c","-Q","-q","-t","-w","pref_uid REGEXP '@(${dnslist})\$'","horde","horde_prefs");
system("mysqldump","-c","-Q","-q","-t","-w","calendar_id REGEXP '@(${dnslist})\$'","horde","kronolith_events");
system("mysqldump","-c","-Q","-q","-t","-w","memo_owner REGEXP '@(${dnslist})\$'","horde","mnemo_memos");
system("mysqldump","-c","-Q","-q","-t","-w","task_owner REGEXP '@(${dnslist})\$'","horde","nag_tasks");
If you transfer your account again, it will contain all data and settings.

I submitted this info to cpanel already but they haven't fixed it yet.

You can extract the missing data also by hand from the old table if you won't copy the account again.