[horde] [kronolith] Update kronolith

[Christopher Neuhaus]

Zitat von Jan Schneider <jan at horde.org>:

>
> 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/
>
>
> --
> kronolith mailing list
> Frequently Asked Questions: http://wiki.horde.org/FAQ
> To unsubscribe, mail: kronolith-unsubscribe at lists.horde.org
>
>

That's it. Thank you for this!
The schema is now converted and H4 is working well.

Best Regards
Christopher