[horde] Migrating Database from horde3 to horde5

almut bertha almutb at mur.at
Thu Nov 19 13:41:44 UTC 2015


Hello everybody,
Thanks for all your input!

The first thing i tried out now, after your feedback, was running
horde-db-migrate from the command line, and i think, that did the trick.
The first run took quite a while (~60minutes), the second one 5 min...
but with the third run, the DB was converted. When i tried this in the
Webinterface, i clicked the "Update-Button" at least 20times, but always
got the same error message

SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "rampage_types" does
not exist LINE 1: SELECT type_id, type_name FROM "rampage_types" WHERE
type_na..


So what i did now:
1. dump the original database and convert the encoding to utf8 with iconv
2. then dump the database back in a new database being already utf8
3. then do the text to bytea conversion
4. and finally run the horde-db-migrate script from command line three
times.

i just did the whole proces a second time and it went smoothly!

regards,
almut



-- 
almut bertha -- mur.at -- +43 316 8214 5144


More information about the horde mailing list