Front end won't save

[Zachary]

I used the upgradejevents_1.4.zip upgradejevents.php file.

Then followed the instructions in "Joomla 1.5 to 2.5 Migration" from this site.


Also I was running jevents 1.5.5 before the upgrade.

[carcam]

Did you upgrade your JEvents component to the latest version before migrating your Joomla! data? That is a required step for a successful migration.

[rjan]

Hello,

I installed JEvent component 2.2.7 and upgraded to 2.2.8. Creating events from backend works fine. Trying to create an event using frontend raises this error:

Fatal error: Call to a member function rp_id() on a non-object in /homepages/43/d29837476/htdocs/joomla/administrator/components/com_jevents/libraries/saveIcalEvent.php on line 215

I thought this might fit in this thread. Any idea about the reason or how to fix? Thank you in advance.
Ralf

btw: The version information for support team is saying

Code: Select all

Joomla : 2.5.6
component_com_jevents : 2.2.8
plugin_editors_jce : 2.2.1.2


[Geraint]

Check the access levels on the categories you have created and also make sure your menu item is not constrained to only show events from a specific category(ies)

[Zachary]

I upgraded to jevents2.2.8

I only have the following extensions installed also.

Googlemaps
edocs (google pdf viewer)
Iyosis_facebook
tweetxt

[Geraint]

Zach - can you create and save new events in backend of Joomla? What problems do you encounter in the frontend (i.e. what error messages/unexpected behaviour)?

[Zachary]

I am unable to add events from the front end.

I log in and can access the page and fill it out. Then when I try to save it. I get this 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','','','','','

test
','0','0','','0','','test','','','','','0','','','1','0','2012-12-06 09:25:34')

[Zachary]

And when I try to go through the back end. I am able to log in and select /component/jevents. Then I select manage events. When I do that I get this error.

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




I am able to access all other parts of the jevents component. Just the manage events button gives me the error.

[Zachary]

Okay, after work I did a complete wipe of the site. Uploaded my backup and then did a total upgrade of the site again.

Then did the Jevents upgrade, All is working fine now. I guess there was a hickup with the first upgrade.