[dev] Kronolith missing 'event_resources' field

Rick Romero rick at havokmon.com
Tue Oct 19 00:57:25 UTC 2010


Thanks for the info on pear MDB2_Driver_mysql - I had MDB2, but not the
specific driver.

  Anyways, I'm getting the following now:

  2010-10-16T09:30:40-05:00 ERR: HORDE4 [kronolith] DB Error: no such field:
SELECT event_id, event_uid, event_description, event_location,
event_private, event_status, event_attendees, event_title,
event_recurcount, event_url, event_recurtype, event_recurenddate,
event_recurinterval, event_recurdays, event_start, event_end, event_allday,
event_alarm, event_alarm_methods, event_modified, event_exceptions,
event_creator_id, event_resources, event_baseid,
event_exceptionoriginaldate FROM kronolith_events WHERE calendar_id =
'rick at havokmon.com' AND ((event_end >= '2010-09-26 05:00:00' AND
event_start <= '2010-11-07 04:59:59') OR (event_recurenddate >= '2010-09-26
05:00:00' AND event_start <= '2010-11-07 04:59:59' AND event_recurtype <>
0)) [nativecode=1054 ** Unknown column 'event_resources' in 'field list']
[pid 7806 on line 1003 of
"/usr/local/www/sub/beta.vfemail.net/data/horde_git/horde/kronolith/lib/Driver/Sql.php"]

  I started with Kronotlith 2.2, pulled the latest Kronolith from CVS, and
ran both
  2.2_to_2.3.sql
  and
  2008-10-21_add_allday_flag.sql (because it had a newer file date)

  Then I ran horde/bin/db_migrate kronolith, and (eventually) upgraded to
level '13'

  I think I missed something because not only do I not have the
'event_resources' field, I had to manually change the kronolith_shares
table and change the share_id Default from 0 to None before the db_migrate
script could change it to auto_increment.

  Did I miss an upgrade?


More information about the dev mailing list