Jump to:

10987 Posts in 2724 Topics by 1817 members

All other Modules

SilverStripe Forums » All other Modules » Event Calendar problem

Discuss all other Modules here.

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

Page: 1 2 3
Go to End
Author Topic: 4583 Views
  • cumquat
    Avatar
    Community Member
    198 Posts

    Event Calendar problem Link to this post

    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

  • UncleCheese
    Avatar
    4085 Posts

    Re: Event Calendar problem Link to this post

    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.

  • cumquat
    Avatar
    Community Member
    198 Posts

    Re: Event Calendar problem Link to this post

    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

  • UncleCheese
    Avatar
    4085 Posts

    Re: Event Calendar problem Link to this post

    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.

  • cumquat
    Avatar
    Community Member
    198 Posts

    Re: Event Calendar problem Link to this post

    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.

  • cumquat
    Avatar
    Community Member
    198 Posts

    Re: Event Calendar problem Link to this post

    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

  • UncleCheese
    Avatar
    4085 Posts

    Re: Event Calendar problem Link to this post

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

  • cumquat
    Avatar
    Community Member
    198 Posts

    Re: Event Calendar problem Link to this post

    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

    4583 Views
Page: 1 2 3
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.