[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