[kronolith] No Data after Migration

[Jan Schneider]

Zitat von Simon Brereton <simon.brereton at dada.net>:

>> -----Original Message-----
>> From: kronolith-bounces at lists.horde.org [mailto:kronolith-
>> bounces at lists.horde.org] On Behalf Of Simon Brereton
>> After installing Kronolith 3.0.1 on a clean machine (with Horde
>> 4.0.1), I attempted to migrate the data from the hold Horde 3 install
>> like this:
>>
>>
>> Import the horde3 DB and give permissions to the local horde user to
>> use it.
>>
>> mysql -u root -p < /donald/root/horde3.datestamp.sql mysql -u root -p
>> -e "grant all privileges on horde3.* to 'horde'@'localhost'
>> identified by 'xxxxxxxx';”
>> mysql -u root -p
>> use horde;
>> update kronolith_events set event_creator_id=lower(event_creator_id);
>>
>>
>> In the Horde Configuration tab changed from the clean horde4 DB to
>> the imported one.
>>
>> Horde Configuration – Database
>> 	Called the DB horde3 (was previously horde)
>>
>> Saved the configuration and ran Update DB schema's for all apps which
>> worked.  I think this called /usr/bin/horde-db-migrate
>>
>> After that, I dumped the clean (and empty) DB horde and renamed
>> horde3 (the old and now updated one) to horde4.  Then I went back to
>> the Horde Configuration tab and changed the name:
>>
>> Horde Configuration – Database
>> 	Called the DB horde4 (was previously horde3)
>>
>> Now, my address books are fine and have all the data, but the
>> calendar data seems to be missing.  However, if I use mysql or
>> phpmyadmin I see the kronolith.events has all the events in it.  But
>> these are not displaying in the calendar.
>>
>> Creating, editing and deleting new events doesn't seem to be a
>> problem.
>>
>> Have I missed anything (read done something stupid) again?
>
>
> I think I've found it.  In the old schema the calendar_id was the  
> same as the username/email address.  The new code uses a 22 char  
> alphanumeric mixed-case string...
>
> Is that a hash of something so that I can just update that column?

No, it's just a random hash, but such hashes were used in Kronolith 2  
too, for any calendars but your default calendar.

Jan.

-- 
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/