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 and MSSQL server


Go to End


13 Posts   3856 Views

Avatar
Glassboy

Community Member, 9 Posts

23 May 2011 at 11:23am

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?

Avatar
Willr

Forum Moderator, 5523 Posts

23 May 2011 at 11:44am

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.

Avatar
Glassboy

Community Member, 9 Posts

23 May 2011 at 12:27pm

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

Avatar
Glassboy

Community Member, 9 Posts

25 May 2011 at 9:54am

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

Avatar
Willr

Forum Moderator, 5523 Posts

25 May 2011 at 5:33pm

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.

Avatar
mikejoseph

Community Member, 3 Posts

11 October 2011 at 6:21am

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

Avatar
Glassboy

Community Member, 9 Posts

11 October 2011 at 10:58am

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.

Avatar
sebjepb

Community Member, 5 Posts

11 October 2011 at 4:39pm

Hi we have same installation ie MSSQL same error

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

Go to Top