Jump to:

10850 Posts in 2517 Topics by 1793 members

All other Modules

SilverStripe Forums » All other Modules » Event Calendar and MSSQL server

Discuss all other Modules here.

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

Page: 1 2
Go to End
Author Topic: 1740 Views
  • Glassboy
    Avatar
    Community Member
    9 Posts

    Event Calendar and MSSQL server Link to this post

    Hi all. I have two SS sites running on Windows 2008 R2. One uses MSSQL and the other is using MySQL, both installed via the web installer and both using exactly the same module code bases.

    Now on the MySQL site the Event Calendar module works fine, but on the MSSQl site I get SQL errors when I try to look at the calendar on the publsihed web site. The same thing happens with the Diary module.

    Should the MySQL and MSQL DB modules be equal all things being considered when you want to add other modules?

  • Willr
    Avatar
    Forum Moderator
    5464 Posts

    Re: Event Calendar and MSSQL server Link to this post

    Do you have an error message? The Modules should provide consistent interfaces for most things (I've hotswapped between them all without many issues) though the module will need to use the correct syntax for queries and avoid using any direct sql.

  • Glassboy
    Avatar
    Community Member
    9 Posts

    Re: Event Calendar and MSSQL server Link to this post

    It's a bit of a long error.

    [User Error] Couldn't run query (42000, 102, [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.): SELECT "SiteTree"."ClassName", "SiteTree"."Created", "SiteTree"."LastEdited", "SiteTree"."URLSegment", "SiteTree"."Title", "SiteTree"."MenuTitle", "SiteTree"."Content", "SiteTree"."MetaTitle", "SiteTree"."MetaDescription", "SiteTree"."MetaKeywords", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."HomepageForDomain", "SiteTree"."ProvideComments", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", "SiteTree"."Status", "SiteTree"."ReportClass", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."ToDo", "SiteTree"."Version", "SiteTree"."ExpiryDate", "SiteTree"."CanPublishType", "SiteTree"."Priority", "SiteTree"."ParentID", "Page"."ShowInStaticMenu", "Page"."BannerImageID", "Page"."PollID", "CalendarEvent"."Recursion", "CalendarEvent"."CustomRecursionType", "CalendarEvent"."DailyInterval", "CalendarEvent"."WeeklyInterval", "CalendarEvent"."MonthlyInterval", "CalendarEvent"."MonthlyRecursionType1", "CalendarEvent"."MonthlyRecursionType2", "CalendarEvent"."MonthlyIndex", "CalendarEvent"."MonthlyDayOfWeek", "CalendarEvent"."CalendarID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree" LEFT JOIN "Page" ON "Page"."ID" = "SiteTree"."ID" LEFT JOIN "CalendarEvent" ON "CalendarEvent"."ID" = "SiteTree"."ID" LEFT JOIN `CalendarDateTime` ON `CalendarDateTime`.EventID = `CalendarEvent`.ID WHERE ("SiteTree"."ClassName" IN ('CalendarEvent')) AND ("Recursion" = 1 AND "ParentID" IN (207)) GROUP BY "SiteTree"."ClassName", "SiteTree"."Created", "SiteTree"."LastEdited", "SiteTree"."URLSegment", "SiteTree"."Title", "SiteTree"."MenuTitle", "SiteTree"."Content", "SiteTree"."MetaTitle", "SiteTree"."MetaDescription", "SiteTree"."MetaKeywords", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."HomepageForDomain", "SiteTree"."ProvideComments", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", "SiteTree"."Status", "SiteTree"."ReportClass", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."ToDo", "SiteTree"."Version", "SiteTree"."ExpiryDate", "SiteTree"."CanPublishType", "SiteTree"."Priority", "SiteTree"."ParentID", "Page"."ShowInStaticMenu", "Page"."BannerImageID", "Page"."PollID", "CalendarEvent"."Recursion", "CalendarEvent"."CustomRecursionType", "CalendarEvent"."DailyInterval", "CalendarEvent"."WeeklyInterval", "CalendarEvent"."MonthlyInterval", "CalendarEvent"."MonthlyRecursionType1", "CalendarEvent"."MonthlyRecursionType2", "CalendarEvent"."MonthlyIndex", "CalendarEvent"."MonthlyDayOfWeek", "CalendarEvent"."CalendarID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' END ORDER BY "CalendarDateTime"."StartDate" ASC: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.
    GET /ourhouse/corporate-calendar/?stage=Stage

    Line 620 in C:\inetpub\wwwroot\Ourhouse\sapphire\core\model\Database.php
    Source

    611    /**
    612     * Error handler for database errors.
    613     * All database errors will call this function to report the error. It isn't a static function;
    614     * it will be called on the object itself and as such can be overridden in a subclass.
    615     * @todo hook this into a more well-structured error handling system.
    616     * @param string $msg The error message.
    617     * @param int $errorLevel The level of the error to throw.
    618     */
    619    function databaseError($msg, $errorLevel = E_USER_ERROR) {
    620       user_error($msg, $errorLevel);
    621    }
    622    
    623    /**
    624     * Enable supression of database messages.
    625     */
    626    function quiet() {

    Trace

    Couldn't run query (42000, 102, [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.): SELECT "SiteTree"."ClassName", "SiteTree"."Created", "SiteTree"."LastEdited", "SiteTree"."URLSegment", "SiteTree"."Title", "SiteTree"."MenuTitle", "SiteTree"."Content", "SiteTree"."MetaTitle", "SiteTree"."MetaDescription", "SiteTree"."MetaKeywords", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."HomepageForDomain", "SiteTree"."ProvideComments", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", "SiteTree"."Status", "SiteTree"."ReportClass", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."ToDo", "SiteTree"."Version", "SiteTree"."ExpiryDate", "SiteTree"."CanPublishType", "SiteTree"."Priority", "SiteTree"."ParentID", "Page"."ShowInStaticMenu", "Page"."BannerImageID", "Page"."PollID", "CalendarEvent"."Recursion", "CalendarEvent"."CustomRecursionType", "CalendarEvent"."DailyInterval", "CalendarEvent"."WeeklyInterval", "CalendarEvent"."MonthlyInterval", "CalendarEvent"."MonthlyRecursionType1", "CalendarEvent"."MonthlyRecursionType2", "CalendarEvent"."MonthlyIndex", "CalendarEvent"."MonthlyDayOfWeek", "CalendarEvent"."CalendarID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree" LEFT JOIN "Page" ON "Page"."ID" = "SiteTree"."ID" LEFT JOIN "CalendarEvent" ON "CalendarEvent"."ID" = "SiteTree"."ID" LEFT JOIN `CalendarDateTime` ON `CalendarDateTime`.EventID = `CalendarEvent`.ID WHERE ("SiteTree"."ClassName" IN ('CalendarEvent')) AND ("Recursion" = 1 AND "ParentID" IN (207)) GROUP BY "SiteTree"."ClassName", "SiteTree"."Created", "SiteTree"."LastEdited", "SiteTree"."URLSegment", "SiteTree"."Title", "SiteTree"."MenuTitle", "SiteTree"."Content", "SiteTree"."MetaTitle", "SiteTree"."MetaDescription", "SiteTree"."MetaKeywords", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."HomepageForDomain", "SiteTree"."ProvideComments", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", "SiteTree"."Status", "SiteTree"."ReportClass", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."ToDo", "SiteTree"."Version", "SiteTree"."ExpiryDate", "SiteTree"."CanPublishType", "SiteTree"."Priority", "SiteTree"."ParentID", "Page"."ShowInStaticMenu", "Page"."BannerImageID", "Page"."PollID", "CalendarEvent"."Recursion", "CalendarEvent"."CustomRecursionType", "CalendarEvent"."DailyInterval", "CalendarEvent"."WeeklyInterval", "CalendarEvent"."MonthlyInterval", "CalendarEvent"."MonthlyRecursionType1", "CalendarEvent"."MonthlyRecursionType2", "CalendarEvent"."MonthlyIndex", "CalendarEvent"."MonthlyDayOfWeek", "CalendarEvent"."CalendarID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' END ORDER BY "CalendarDateTime"."StartDate" ASC: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.
    Line 620 of Database.php
    SS_Database->databaseError(Couldn't run query (42000, 102, [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.): SELECT "SiteTree"."ClassName", "SiteTree"."Created", "SiteTree"."LastEdited", "SiteTree"."URLSegment", "SiteTree"."Title", "SiteTree"."MenuTitle", "SiteTree"."Content", "SiteTree"."MetaTitle", "SiteTree"."MetaDescription", "SiteTree"."MetaKeywords", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."HomepageForDomain", "SiteTree"."ProvideComments", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", "SiteTree"."Status", "SiteTree"."ReportClass", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."ToDo", "SiteTree"."Version", "SiteTree"."ExpiryDate", "SiteTree"."CanPublishType", "SiteTree"."Priority", "SiteTree"."ParentID", "Page"."ShowInStaticMenu", "Page"."BannerImageID", "Page"."PollID", "CalendarEvent"."Recursion", "CalendarEvent"."CustomRecursionType", "CalendarEvent"."DailyInterval", "CalendarEvent"."WeeklyInterval", "CalendarEvent"."MonthlyInterval", "CalendarEvent"."MonthlyRecursionType1", "CalendarEvent"."MonthlyRecursionType2", "CalendarEvent"."MonthlyIndex", "CalendarEvent"."MonthlyDayOfWeek", "CalendarEvent"."CalendarID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree" LEFT JOIN "Page" ON "Page"."ID" = "SiteTree"."ID" LEFT JOIN "CalendarEvent" ON "CalendarEvent"."ID" = "SiteTree"."ID" LEFT JOIN `CalendarDateTime` ON `CalendarDateTime`.EventID = `CalendarEvent`.ID WHERE ("SiteTree"."ClassName" IN ('CalendarEvent')) AND ("Recursion" = 1 AND "ParentID" IN (207)) GROUP BY "SiteTree"."ClassName", "SiteTree"."Created", "SiteTree"."LastEdited", "SiteTree"."URLSegment", "SiteTree"."Title", "SiteTree"."MenuTitle", "SiteTree"."Content", "SiteTree"."MetaTitle", "SiteTree"."MetaDescription", "SiteTree"."MetaKeywords", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."HomepageForDomain", "SiteTree"."ProvideComments", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", "SiteTree"."Status", "SiteTree"."ReportClass", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."ToDo", "SiteTree"."Version", "SiteTree"."ExpiryDate", "SiteTree"."CanPublishType", "SiteTree"."Priority", "SiteTree"."ParentID", "Page"."ShowInStaticMenu", "Page"."BannerImageID", "Page"."PollID", "CalendarEvent"."Recursion", "CalendarEvent"."CustomRecursionType", "CalendarEvent"."DailyInterval", "CalendarEvent"."WeeklyInterval", "CalendarEvent"."MonthlyInterval", "CalendarEvent"."MonthlyRecursionType1", "CalendarEvent"."MonthlyRecursionType2", "CalendarEvent"."MonthlyIndex", "CalendarEvent"."MonthlyDayOfWeek", "CalendarEvent"."CalendarID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' END ORDER BY "CalendarDateTime"."StartDate" ASC: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.,256)
    Line 209 of MSSQLDatabase.php
    MSSQLDatabase->databaseError(Couldn't run query (42000, 102, [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.): SELECT "SiteTree"."ClassName", "SiteTree"."Created", "SiteTree"."LastEdited", "SiteTree"."URLSegment", "SiteTree"."Title", "SiteTree"."MenuTitle", "SiteTree"."Content", "SiteTree"."MetaTitle", "SiteTree"."MetaDescription", "SiteTree"."MetaKeywords", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."HomepageForDomain", "SiteTree"."ProvideComments", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", "SiteTree"."Status", "SiteTree"."ReportClass", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."ToDo", "SiteTree"."Version", "SiteTree"."ExpiryDate", "SiteTree"."CanPublishType", "SiteTree"."Priority", "SiteTree"."ParentID", "Page"."ShowInStaticMenu", "Page"."BannerImageID", "Page"."PollID", "CalendarEvent"."Recursion", "CalendarEvent"."CustomRecursionType", "CalendarEvent"."DailyInterval", "CalendarEvent"."WeeklyInterval", "CalendarEvent"."MonthlyInterval", "CalendarEvent"."MonthlyRecursionType1", "CalendarEvent"."MonthlyRecursionType2", "CalendarEvent"."MonthlyIndex", "CalendarEvent"."MonthlyDayOfWeek", "CalendarEvent"."CalendarID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree" LEFT JOIN "Page" ON "Page"."ID" = "SiteTree"."ID" LEFT JOIN "CalendarEvent" ON "CalendarEvent"."ID" = "SiteTree"."ID" LEFT JOIN `CalendarDateTime` ON `CalendarDateTime`.EventID = `CalendarEvent`.ID WHERE ("SiteTree"."ClassName" IN ('CalendarEvent')) AND ("Recursion" = 1 AND "ParentID" IN (207)) GROUP BY "SiteTree"."ClassName", "SiteTree"."Created", "SiteTree"."LastEdited", "SiteTree"."URLSegment", "SiteTree"."Title", "SiteTree"."MenuTitle", "SiteTree"."Content", "SiteTree"."MetaTitle", "SiteTree"."MetaDescription", "SiteTree"."MetaKeywords", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."HomepageForDomain", "SiteTree"."ProvideComments", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", "SiteTree"."Status", "SiteTree"."ReportClass", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."ToDo", "SiteTree"."Version", "SiteTree"."ExpiryDate", "SiteTree"."CanPublishType", "SiteTree"."Priority", "SiteTree"."ParentID", "Page"."ShowInStaticMenu", "Page"."BannerImageID", "Page"."PollID", "CalendarEvent"."Recursion", "CalendarEvent"."CustomRecursionType", "CalendarEvent"."DailyInterval", "CalendarEvent"."WeeklyInterval", "CalendarEvent"."MonthlyInterval", "CalendarEvent"."MonthlyRecursionType1", "CalendarEvent"."MonthlyRecursionType2", "CalendarEvent"."MonthlyIndex", "CalendarEvent"."MonthlyDayOfWeek", "CalendarEvent"."CalendarID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' END ORDER BY "CalendarDateTime"."StartDate" ASC,256)
    Line 310 of MSSQLDatabase.php
    MSSQLDatabase->query(SELECT "SiteTree"."ClassName", "SiteTree"."Created", "SiteTree"."LastEdited", "SiteTree"."URLSegment", "SiteTree"."Title", "SiteTree"."MenuTitle", "SiteTree"."Content", "SiteTree"."MetaTitle", "SiteTree"."MetaDescription", "SiteTree"."MetaKeywords", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."HomepageForDomain", "SiteTree"."ProvideComments", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", "SiteTree"."Status", "SiteTree"."ReportClass", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."ToDo", "SiteTree"."Version", "SiteTree"."ExpiryDate", "SiteTree"."CanPublishType", "SiteTree"."Priority", "SiteTree"."ParentID", "Page"."ShowInStaticMenu", "Page"."BannerImageID", "Page"."PollID", "CalendarEvent"."Recursion", "CalendarEvent"."CustomRecursionType", "CalendarEvent"."DailyInterval", "CalendarEvent"."WeeklyInterval", "CalendarEvent"."MonthlyInterval", "CalendarEvent"."MonthlyRecursionType1", "CalendarEvent"."MonthlyRecursionType2", "CalendarEvent"."MonthlyIndex", "CalendarEvent"."MonthlyDayOfWeek", "CalendarEvent"."CalendarID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree" LEFT JOIN "Page" ON "Page"."ID" = "SiteTree"."ID" LEFT JOIN "CalendarEvent" ON "CalendarEvent"."ID" = "SiteTree"."ID" LEFT JOIN `CalendarDateTime` ON `CalendarDateTime`.EventID = `CalendarEvent`.ID WHERE ("SiteTree"."ClassName" IN ('CalendarEvent')) AND ("Recursion" = 1 AND "ParentID" IN (207)) GROUP BY "SiteTree"."ClassName", "SiteTree"."Created", "SiteTree"."LastEdited", "SiteTree"."URLSegment", "SiteTree"."Title", "SiteTree"."MenuTitle", "SiteTree"."Content", "SiteTree"."MetaTitle", "SiteTree"."MetaDescription", "SiteTree"."MetaKeywords", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."HomepageForDomain", "SiteTree"."ProvideComments", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", "SiteTree"."Status", "SiteTree"."ReportClass", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."ToDo", "SiteTree"."Version", "SiteTree"."ExpiryDate", "SiteTree"."CanPublishType", "SiteTree"."Priority", "SiteTree"."ParentID", "Page"."ShowInStaticMenu", "Page"."BannerImageID", "Page"."PollID", "CalendarEvent"."Recursion", "CalendarEvent"."CustomRecursionType", "CalendarEvent"."DailyInterval", "CalendarEvent"."WeeklyInterval", "CalendarEvent"."MonthlyInterval", "CalendarEvent"."MonthlyRecursionType1", "CalendarEvent"."MonthlyRecursionType2", "CalendarEvent"."MonthlyIndex", "CalendarEvent"."MonthlyDayOfWeek", "CalendarEvent"."CalendarID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' END ORDER BY "CalendarDateTime"."StartDate" ASC,256)
    Line 129 of DB.php
    DB::query(SELECT "SiteTree"."ClassName", "SiteTree"."Created", "SiteTree"."LastEdited", "SiteTree"."URLSegment", "SiteTree"."Title", "SiteTree"."MenuTitle", "SiteTree"."Content", "SiteTree"."MetaTitle", "SiteTree"."MetaDescription", "SiteTree"."MetaKeywords", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."HomepageForDomain", "SiteTree"."ProvideComments", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", "SiteTree"."Status", "SiteTree"."ReportClass", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."ToDo", "SiteTree"."Version", "SiteTree"."ExpiryDate", "SiteTree"."CanPublishType", "SiteTree"."Priority", "SiteTree"."ParentID", "Page"."ShowInStaticMenu", "Page"."BannerImageID", "Page"."PollID", "CalendarEvent"."Recursion", "CalendarEvent"."CustomRecursionType", "CalendarEvent"."DailyInterval", "CalendarEvent"."WeeklyInterval", "CalendarEvent"."MonthlyInterval", "CalendarEvent"."MonthlyRecursionType1", "CalendarEvent"."MonthlyRecursionType2", "CalendarEvent"."MonthlyIndex", "CalendarEvent"."MonthlyDayOfWeek", "CalendarEvent"."CalendarID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree" LEFT JOIN "Page" ON "Page"."ID" = "SiteTree"."ID" LEFT JOIN "CalendarEvent" ON "CalendarEvent"."ID" = "SiteTree"."ID" LEFT JOIN `CalendarDateTime` ON `CalendarDateTime`.EventID = `CalendarEvent`.ID WHERE ("SiteTree"."ClassName" IN ('CalendarEvent')) AND ("Recursion" = 1 AND "ParentID" IN (207)) GROUP BY "SiteTree"."ClassName", "SiteTree"."Created", "SiteTree"."LastEdited", "SiteTree"."URLSegment", "SiteTree"."Title", "SiteTree"."MenuTitle", "SiteTree"."Content", "SiteTree"."MetaTitle", "SiteTree"."MetaDescription", "SiteTree"."MetaKeywords", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."HomepageForDomain", "SiteTree"."ProvideComments", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", "SiteTree"."Status", "SiteTree"."ReportClass", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."ToDo", "SiteTree"."Version", "SiteTree"."ExpiryDate", "SiteTree"."CanPublishType", "SiteTree"."Priority", "SiteTree"."ParentID", "Page"."ShowInStaticMenu", "Page"."BannerImageID", "Page"."PollID", "CalendarEvent"."Recursion", "CalendarEvent"."CustomRecursionType", "CalendarEvent"."DailyInterval", "CalendarEvent"."WeeklyInterval", "CalendarEvent"."MonthlyInterval", "CalendarEvent"."MonthlyRecursionType1", "CalendarEvent"."MonthlyRecursionType2", "CalendarEvent"."MonthlyIndex", "CalendarEvent"."MonthlyDayOfWeek", "CalendarEvent"."CalendarID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' END ORDER BY "CalendarDateTime"."StartDate" ASC,256)
    Line 400 of SQLQuery.php
    SQLQuery->execute()
    Line 2736 of DataObject.php
    DataObject->instance_get("Recursion" = 1 AND "ParentID" IN (207),"CalendarDateTime"."StartDate" ASC,LEFT JOIN `CalendarDateTime` ON `CalendarDateTime`.EventID = `CalendarEvent`.ID,,DataObjectSet)
    Line 2714 of DataObject.php
    DataObject::get(CalendarEvent,"Recursion" = 1 AND "ParentID" IN (207),"CalendarDateTime"."StartDate" ASC,LEFT JOIN `CalendarDateTime` ON `CalendarDateTime`.EventID = `CalendarEvent`.ID)
    Line 264 of Calendar.php
    Calendar->getRecurringEvents()
    Line 405 of Calendar.php
    Calendar->Events(,sfDate,sfDate,1,,)
    Line 869 of Calendar.php
    Calendar_Controller->Events()
    Line 369 of ViewableData.php
    ViewableData->obj(Events,,,1,)
    Line 411 of ViewableData.php
    ViewableData->cachedCall(Events,)
    Line 424 of ViewableData.php
    ViewableData->hasValue(Events)
    Line 92 of .cache.event_calendar.templates.Layout.Calendar.ss
    include(C:\inetpub\wwwroot\Ourhouse\silverstripe-cache\.cache.event_calendar.templates.Layout.Calendar.ss)
    Line 420 of SSViewer.php
    SSViewer->process(Calendar_Controller,Zend_Cache_Frontend_Output)
    Line 411 of SSViewer.php
    SSViewer->process(Calendar_Controller)
    Line 202 of Controller.php
    Controller->handleAction(SS_HTTPRequest)
    Line 143 of RequestHandler.php
    RequestHandler->handleRequest(SS_HTTPRequest)
    Line 147 of Controller.php
    Controller->handleRequest(SS_HTTPRequest)
    Line 199 of ContentController.php
    ContentController->handleRequest(SS_HTTPRequest)
    Line 67 of ModelAsController.php
    ModelAsController->handleRequest(SS_HTTPRequest)
    Line 282 of Director.php
    Director::handleRequest(SS_HTTPRequest,Session)
    Line 125 of Director.php
    Director::direct(corporate-calendar/)
    Line 127 of main.php

  • Glassboy
    Avatar
    Community Member
    9 Posts

    Re: Event Calendar and MSSQL server Link to this post

    Should I log a bug against the MSSQL module for this?

  • Willr
    Avatar
    Forum Moderator
    5464 Posts

    Re: Event Calendar and MSSQL server Link to this post

    No, this looks like a module issue. The select query appears to use backticks rather than escaped quote marks. Submit it as an issue with the module maintainer.

  • mikejoseph
    Avatar
    Community Member
    3 Posts

    Re: Event Calendar and MSSQL server Link to this post

    Hi Glassboy -

    Were you able to find a work-around or alternate module. I'm required to deploy SilverStripe on a Microsoft Environment (IIS/MSSQL) so I'm a little stuck!

    Thanks!
    Mike

  • Glassboy
    Avatar
    Community Member
    9 Posts

    Re: Event Calendar and MSSQL server Link to this post

    I've been far to preoccupied with other things. I believe the best approach would just be to log a bug for that module asking the author to fix it. It's not a huge change and it is in line with SS wanting the modules to be platform independent.

  • sebjepb
    Avatar
    Community Member
    5 Posts

    Re: Event Calendar and MSSQL server Link to this post

    Hi we have same installation ie MSSQL same error

    How do we go about logging bug is there a link we go to ?

    1740 Views
Page: 1 2
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.