[horde] Problems migrating my DB to horde4

["T. Bühlmann"]

Am 20.04.2011 17:29, schrieb Simon Brereton:
>> From: horde-bounces at lists.horde.org [mailto:horde-
>> bounces at lists.horde.org] On Behalf Of Thomas Buehlmann
>> Hello List!
>>
>> I have a problem migrating my "old" horde DB to new version4 on my
>> opensuse 11.4 Box.
>> Everything works just fine, except the kronolith-part.
>> I get the following error by executing
>>
>> $  /usr/bin/horde-db-migrate -d kronolith up
>> ------------------
>> ...
>> ...
>> ...
>> 2011-04-20T16:44:55+02:00 DEBUG: SQL  (0.0160s)
>>          UPDATE kronolith_schema_info SET version = 17 2011-04-
>> 20T16:44:55+02:00 DEBUG: SQL  (0.0007s)
>>          SHOW TABLES
>> 2011-04-20T16:44:55+02:00 DEBUG: SQL  (0.0001s)
>>          SELECT version FROM kronolith_schema_info Migrating to
>> KronolithUpgradeCategoriesToTags (18) == 18
>> KronolithUpgradeCategoriesToTags: migrating
>> ============================= == 18 KronolithUpgradeCategoriesToTags:
>> Migrating event categories to tags. ===
>> -- select(SELECT event_uid, event_category, event_creator_id,
>> calendar_id FROM kronolith_events) 2011-04-20T16:44:55+02:00 DEBUG:
>> SQL  (0.0008s)
>>          SELECT event_uid, event_category, event_creator_id,
>> calendar_id FROM
>>            kronolith_events
>>     -> 0.0009s
>> -- getOption(charset)
>>     -> 0.0000s
>> 2011-04-20T16:44:55+02:00 DEBUG: SQL  (0.0002s)
>>          SELECT object_id, object_name FROM `rampage_objects` WHERE
>> object_name
>>            IN ('20101004122951.16093aa0n6v4qhsv at tbuhl.ch') AND
>> type_id = 2 2011-04-20T16:44:55+02:00 DEBUG: SQL  (0.0177s)
>>          INSERT INTO `rampage_objects` (object_name, type_id) VALUES
>>            ('20101004122951.16093aa0n6v4qhsv at tbuhl.ch', 2) 2011-04-
>> 20T16:44:55+02:00 DEBUG: SQL  (0.0001s)
>>          SELECT user_id, user_name FROM `rampage_users` WHERE
>> user_name IN
>>            ('tomnet')
>> 2011-04-20T16:44:55+02:00 DEBUG: SQL  (0.0161s)
>>          INSERT INTO `rampage_users` (user_name) VALUES ('hans')
>> 2011-04-20T16:44:55+02:00 DEBUG: SQL  (0.0003s)
>>          SELECT * FROM kronolith_sharesng WHERE share_name = 'hans'
>> == 18 KronolithUpgradeCategoriesToTags: Unable to find Share: hans
>> Skipping.
>> PHP Fatal error:  Call to a member function get() on a non-object in
>> /srv/www/eyeos/horde4/kronolith/migration/18_kronolith_upgrade_catego
>> riestotags.php on line
>> 53
>>
>> -----------------
>>
>> All the other applications worked fine.
>> And this same database works without a glitch in H3.
>>
>> Could please anybody tell me what i do wrong?
> Check on the Kronolith list - but this has been fixed - you need to download an update (to one file) or make the change yourself (it's a matter of commenting a few lines).
>
> http://lmgtfy.com/?q=Can%27t+upgrade+Kronolith+DB+Schema
>
> Simon
>
>
Thanks Simon. I took the file "18_kronolith_upgrade_categoriestotags.php"
from git repo and it worked!
Still some issues to overcome, but i know where the kind people are to
help. :)

Thanks once again!
Tom