[horde] Migration Database Horde 5 to Horde 6
lst_hoe02 at kwsoft.de
lst_hoe02 at kwsoft.de
Mon Oct 26 16:57:30 UTC 2026
Hello
we are on the way to migrate a old Horde 5 installation to Horde 6 and
try to use the old database content and do
"./vendor/bin/horde-db-migrate up" to adjust the schema to Horde 6.
This somewhat works but Kronolith throws the following error:
Migrating to KronolithUpgradeResourcesToShares (24)
== 24 KronolithUpgradeResourcesToShares: migrating
============================
-- addColumn('kronolith_sharesng', 'attribute_email', 'text')
-> 0.0013s
-- addColumn('kronolith_sharesng', 'attribute_members', 'text')
-> 0.0010s
-- addColumn('kronolith_sharesng', 'attribute_response_type', 'integer')
-> 0.0009s
-- addColumn('kronolith_sharesng', 'attribute_type', 'integer',
array('default' => 1))
-> 0.0204s
-- addColumn('kronolith_sharesng', 'attribute_isgroup', 'integer',
array('default' => 0))
-> 0.0181s
-- addColumn('kronolith_shares', 'attribute_email', 'text')
-> 0.0009s
-- addColumn('kronolith_shares', 'attribute_members', 'text')
-> 0.0009s
-- addColumn('kronolith_shares', 'attribute_response_type', 'integer')
-> 0.0009s
-- addColumn('kronolith_shares', 'attribute_type', 'integer',
array('default' => 1))
-> 0.0038s
-- addColumn('kronolith_shares', 'attribute_isgroup', 'integer',
array('default' => 0))
-> 0.0029s
SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input
syntax for type integer: "f"
LINE 1: ... NULL, NULL, 'Besprechungsraum', '', '', 1, 2, 'f', 's:0:...
To my knowledge the entry is some resource defined in Kronolith long
ago. Truncating "kronolith_resources" before horde-db-migrate fixes
the problem. Is this expected eg. are resource not able to migrate to
the new version?
Regards
Andreas
More information about the horde
mailing list