10377 Posts in 2193 Topics by 1709 members
| Go to End | Next > | |
| Author | Topic: | 3753 Views |
-
Event Calendar problem

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
-
Re: Event Calendar problem

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.
-
Re: Event Calendar problem

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.phpuser_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
-
Re: Event Calendar problem

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.
-
Re: Event Calendar problem

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.
-
Re: Event Calendar problem

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
-
Re: Event Calendar problem

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?
-
Re: Event Calendar problem

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
| 3753 Views | ||
| Go to Top | Next > |

