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?

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.

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

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

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.

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

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.

Hi we have same installation ie MSSQL same error

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