Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

We've moved the forum!

Please use forum.silverstripe.org for any new questions (announcement).
The forum archive will stick around, but will be read only.

You can also use our Slack channel or StackOverflow to ask for help.
Check out our community overview for more options to contribute.

All other Modules /

Discuss all other Modules here.

Moderators: martimiz, Sean, Ed, biapar, Willr, Ingo, swaiba

Event Calendar problem


Go to End


18 Posts   8010 Views

Avatar
cumquat

Community Member, 201 Posts

17 June 2009 at 2:40am

Hi there, i upgraded a site today from 2.2.1 to 2.3.1 no problem, then i added the event calendar and that seemed to go ok. i can add a calendar no problem, the problem i'm getting is when i add a calander event page it creates the page but everytime i try and save it the cms says "Error saving content". it may be there are some logs somewhere telling me more but apart from that i have no idea why it's happening. i added the dataobject manager as i read it helps but still no luck. Granted not much to go on here but maybe someone has had something similar, it's the latest version of the event calendar, download from the extensions page this morning.

Regards

Mick

Avatar
UncleCheese

Forum Moderator, 4102 Posts

17 June 2009 at 3:24am

In your _config.php, add:

Debug::send_errors_to('your@email.com')

Find out what the error is, and post it here. You can also use firebug to read the response from the server.

Avatar
cumquat

Community Member, 201 Posts

17 June 2009 at 5:03am

Thanks for your speedy response and tip. below is the contents of the email.

Error: Couldn't run query: insert into `CalendarEvent_versions` SET `Recursion` = 0, `CustomRecursionType` = 0, `DailyInterval` = 1, `WeeklyInterval` = 1, `MonthlyInterval` = 1, `MonthlyRecursionType1` = 0, `MonthlyRecursionType2` = 0, `MonthlyIndex` = 1, `ClassName` = 'CalendarEvent', `Created` = null, `LastEdited` = null, `Start` = null, `End` = null, `Content` = null, `Title` = null, `StartTime` = null, `EndTime` = null, `Location` = null, `EventType` = null, `MonthlyDayOfWeek` = '0', `CalendarID` = '0', `RecordID` = 29, `Version` = 2, `AuthorID` = 1 Unknown column 'ClassName' in 'field list'
At line 400 in /home/sites/sunrise-lettings.co.uk/public_html/sapphire/core/model/MySQLDatabase.php

user_error(Couldn't run query: insert into `CalendarEvent_versions` SET `Recursion` = 0, `CustomRecursionType` = 0, `DailyInterval` = 1, `WeeklyInterval` = 1, `MonthlyInterval` = 1, `MonthlyRecursionType1` = 0, `MonthlyRecursionType2` = 0, `MonthlyIndex` = 1, `ClassName` = 'CalendarEvent', `Created` = null, `LastEdited` = null, `Start` = null, `End` = null, `Content` = null, `Title` = null, `StartTime` = null, `EndTime` = null, `Location` = null, `EventType` = null, `MonthlyDayOfWeek` = '0', `CalendarID` = '0', `RecordID` = 29, `Version` = 2, `AuthorID` = 1 Unknown column 'ClassName' in 'field list',256) line 400 of MySQLDatabase.php MySQLDatabase->databaseError(Couldn't run query: insert into `CalendarEvent_versions` SET `Recursion` = 0, `CustomRecursionType` = 0, `DailyInterval` = 1, `WeeklyInterval` = 1, `MonthlyInterval` = 1, `MonthlyRecursionType1` = 0, `MonthlyRecursionType2` = 0, `MonthlyIndex` = 1, `ClassName` = 'CalendarEvent', `Created` = null, `LastEdited` = null, `Start` = null, `End` = null, `Content` = null, `Title` = null, `StartTime` = null, `EndTime` = null, `Location` = null, `EventType` = null, `MonthlyDayOfWeek` = '0', `CalendarID` = '0', `RecordID` = 29, `Version` = 2, `AuthorID` = 1 | Unknown column 'ClassName' in 'field list',256) line 102 of MySQLDatabase.php MySQLDatabase->query(insert into `CalendarEvent_versions` SET `Recursion` = 0, `CustomRecursionType` = 0, `DailyInterval` = 1, `WeeklyInterval` = 1, `MonthlyInterval` = 1, `MonthlyRecursionType1` = 0, `MonthlyRecursionType2` = 0, `MonthlyIndex` = 1, `ClassName` = 'CalendarEvent', `Created` = null, `LastEdited` = null, `Start` = null, `End` = null, `Content` = null, `Title` = null, `StartTime` = null, `EndTime` = null, `Location` = null, `EventType` = null, `MonthlyDayOfWeek` = '0', `CalendarID` = '0', `RecordID` = 29, `Version` = 2, `AuthorID` = 1) line 418 of Database.php Database->manipulate(Array) line 117 of DB.php DB::manipulate(Array) line 833 of DataObject.php DataObject->write() line 642 of LeftAndMain.php LeftAndMain->save(Array,Form,HTTPRequest) line 228 of Form.php Form->httpSubmission(HTTPRequest) line 107 of RequestHandler.php RequestHandler->handleRequest(HTTPRequest) line 121 of RequestHandler.php RequestHandler->handleRequest(HTTPRequest) line 122 of Controller.php Controller->handleRequest(HTTPRequest) line 277 of Director.php Director::handleRequest(HTTPRequest,Session) line 121 of Director.php Director::direct(admin/EditForm) line 115 of main.php

Avatar
UncleCheese

Forum Moderator, 4102 Posts

17 June 2009 at 8:05am

This is a nasty problem. I've experienced it before -- never with EventCalendar, but with other stuff. I have no idea what makes Silverstripe see that phantom column in the Versions table. I wish I could remember how I fixed it.

Avatar
cumquat

Community Member, 201 Posts

17 June 2009 at 9:01pm

Ok well thanks for trying if you do rememebr or if anyone else out there knows please let me know as this is a bit above my Silverstripe skill level.

Avatar
cumquat

Community Member, 201 Posts

22 June 2009 at 9:24pm

Hi Guys don't suppose anyone has any ideas on this, i've now upgraded to 2.3.2 but thats hasn't helped. This is a live website and i'm kinda hoping that i'm not going to have to kill the whole thing and start again.

Regards

Mick

Avatar
UncleCheese

Forum Moderator, 4102 Posts

23 June 2009 at 1:15am

Can you try removing all the tables from the DB, removing the event_calendar folder, run a /dev/build, and start over, maybe?

Avatar
cumquat

Community Member, 201 Posts

23 June 2009 at 1:53am

You sir, are a god...

Cheers for that, i don't know why i didn't think of that i guess i just assumed that if you took away a module that when you ran dev/build again that it would clean/remove the tables.

Many thanks again

Mick

Go to Top