I am having a similar problem.
I just upgrade from joomla 1.5.26 to 2.5.8
I have upgraded to jevent2.2.8
when I try to add an event and save it I get the following error.
Front end error:
321 - Problem saving event Unknown column 'modified' in 'field list' SQL=INSERT INTO `j25_jevents_vevdetail` (`dtstart`,`dtstartraw`,`duration`,`durationraw`,`dtend`,`dtendraw`,`dtstamp`,`class`,`categories`,`description`,`geolon`,`geolat`,`location`,`priority`,`status`,`summary`,`contact`,`organizer`,`url`,`created`,`sequence`,`extra_info`,`color`,`multiday`,`noendtime`,`modified`) VALUES ('1354806000','','0','','1354838400','','','','','
Back end error:
Warning: Invalid argument supplied for foreach() in /components/com_jevents/controllers/icalevent.php on line 324
DB function failed with error number 1054
Unknown column 'detail.modified' in 'field list' SQL=SELECT ev.*, ev.state as evstate, detail.*, ev.created as created, max(detail.modified) as modified, a.title as _groupname , rr.rr_id, rr.freq,rr.rinterval ,MAX(rpt.endrepeat) as endrepeat ,MIN(rpt.startrepeat) as startrepeat , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup , YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup , HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn FROM j25_jevents_vevent as ev LEFT JOIN j25_jevents_repetition as rpt ON rpt.eventid = ev.ev_id LEFT JOIN j25_jevents_vevdetail as detail ON ev.detail_id=detail.evdet_id LEFT JOIN j25_jevents_rrule as rr ON rr.eventid = ev.ev_id LEFT JOIN j25_viewlevels AS a ON a.id = ev.access WHERE ev.catid IN(-1,52,48,49,50,51,53,54,55,56,57,58,59,60) AND rpt.endrepeat>'2012-12-05 09:26:37' GROUP BY ev.ev_id ORDER BY rpt.startrepeat asc LIMIT 0, 10
Any suggestions on how ti fix this.