[kronolith] Update kronolith

[Jan Schneider]

Zitat von Christopher Neuhaus <cne at ruhrverband.de>:

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

Try scripts/upgrades/2009-04-13_horde_pgsql_upgrade.sql

-- 
Jan Schneider
The Horde Project
http://www.horde.org/