[horde] Migrating Database from horde3 to horde5

almut bertha almutb at mur.at
Tue Nov 17 13:49:30 UTC 2015


Hello List!
We are trying to migrate our old Horde3 (3.3.12) Installation to horde5.
I setup a new Debian Jessie Server for horde5.

We try to preserve our Database (postgres 9.1) ...
I read the UPGRADE Documentation, so I tried to run the script
2009-04-13_horde_pgsql_upgrade.sql, but i got an error -- after
searching the internet i found this

für postgres ab 8.1
alter TABLE horde_prefs ALTER COLUMN pref_value TYPE BYTEA USING
decode(replace(pref_value, E'\\', E'\\\\'), 'escape');

and that worked.

Unfortunately i'm stuck at another point now: i try to upgrade the DB
via the horde-Webinterface (horde 5.2.2) and i get the following error
(in turba, kronolith, etc..  not in ingo, gollem, trean) :

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..

Can someone help?

thanks in advance,
almut


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


More information about the horde mailing list