[horde] Problems migrating my DB to horde4

[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