[kronolith] Update kronolith
Christopher Neuhaus
cne at ruhrverband.de
Wed May 16 14:07:44 UTC 2012
Hi list!
I have two problems:
After the db migration (postgres) from h3 to h4, every user who logs in
gets a new calendar name. So the user can't find his old dates. Can I
somehow enforce kronolith to keep the old calendar-names?
The db-scheme is converted except for Horde_Prefs. Obviously, there is a
problem with conversioning text to bytea values. Here comes the log.
2012-05-16T15:54:41+02:00 DEBUG: HORDE [horde] SQL (0,0008s)
SELECT version FROM horde_prefs_schema_info [pid 1302 on line 803 of
"/usr/share/php/Horde/Db/Adapter/Base.php"]
2012-05-16T15:54:41+02:00 ERR: HORDE [horde] SQL QUERY FAILED:
SQLSTATE[42804]: Datatype mismatch: 7 FEHLER: Spalte �pref_value� kann
nicht in Typ bytea umgewandelt werden
ALTER TABLE "horde_prefs" ALTER COLUMN "pref_value" TYPE bytea [pid 1302
on line 812 of "/usr/share/php/Horde/Db/Adapter/Base.php"]
2012-05-16T15:54:41+02:00 DEBUG: HORDE [horde] SQL
ALTER TABLE "horde_prefs" ALTER COLUMN "pref_value" TYPE bytea [pid 1302
on line 803 of "/usr/share/php/Horde/Db/Adapter/Base.php"]
2012-05-16T15:54:41+02:00 DEBUG: HORDE [horde] SQL (0,0048s)
SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc,
a.attnotnull FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid
= d.adrelid AND a.attnum = d.adnum WHERE a.attrelid =
'horde_prefs'::regclass AND a.attnum > 0 AND NOT a.attisdropped ORDER
BY a.attnum [pid 1302 on line 803 of
"/usr/share/php/Horde/Db/Adapter/Base.php"]
2012-05-16T15:54:41+02:00 DEBUG: HORDE [horde] SQL (0,0021s)
SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc,
a.attnotnull FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid
= d.adrelid AND a.attnum = d.adnum WHERE a.attrelid =
'horde_prefs'::regclass AND a.attnum > 0 AND NOT a.attisdropped ORDER
BY a.attnum [pid 1302 on line 803 of
"/usr/share/php/Horde/Db/Adapter/Base.php"]
2012-05-16T15:54:41+02:00 DEBUG: HORDE [horde] SQL (0,0036s)
ALTER TABLE "horde_prefs" ADD COLUMN "pref_value_change_tmp" bytea [pid
1302 on line 803 of "/usr/share/php/Horde/Db/Adapter/Base.php"]
2012-05-16T15:54:43+02:00 ERR: HORDE [horde] SQL QUERY FAILED:
SQLSTATE[22P02]: Invalid text representation: 7 FEHLER: ung�ltige
Eingabesyntax f�r Typ bytea
UPDATE "horde_prefs" SET "pref_value_change_tmp" = CAST("pref_value"
AS bytea) [pid 1302 on line 812 of
"/usr/share/php/Horde/Db/Adapter/Base.php"]
2012-05-16T15:54:43+02:00 DEBUG: HORDE [horde] SQL
UPDATE "horde_prefs" SET "pref_value_change_tmp" = CAST("pref_value"
AS bytea) [pid 1302 on line 803 of
"/usr/share/php/Horde/Db/Adapter/Base.php"]
2012-05-16T15:54:43+02:00 DEBUG: HORDE [horde] SQLSTATE[22P02]: Invalid
text representation: 7 FEHLER: ung�ltige Eingabesyntax f�r Typ bytea
[pid 1302 on line 27 of
"/usr/share/php/Horde/Core/Notification/Handler/Decorator/Hordelog.php"]
Do someone know how I can prepare the horde_prefs.pref_value
text-values, so that they can be converted?
Best Regards
Christopher
More information about the kronolith
mailing list