Source
516 }
517
518 function databaseError($msg, $errorLevel = E_USER_ERROR) {
519 // try to extract and format query
520 if(preg_match('/Couldn\'t run query: ([^\|]*)\|\s*(.*)/', $msg, $matches)) {
521 $formatter = new SQLFormatter();
522 $msg = "Couldn't run query: \n" . $formatter->formatPlain($matches[1]) . "\n\n" . $matches[2];
523 }
524
525 user_error($msg, $errorLevel);
526 }
527
528 /**
529 * Return a boolean type-formatted string
530 *
531 * @param array $values Contains a tokenised list of info about this data type
Trace
- Couldn't run 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"."Priority", "SiteTree"."GenerateMetaData", "SiteTree"."ParentID", "Page"."MainHeading", "Page"."VideoLink", "Page"."VideoDesc", "Page"."ImageDesc", "Page"."ShowSidebar", "Page"."ShowFacebook", "Page"."PageBanner1ID", "Page"."PageImageID", "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 = 6)
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"."Priority", "SiteTree"."GenerateMetaData", "SiteTree"."ParentID", "Page"."MainHeading", "Page"."VideoLink", "Page"."VideoDesc", "Page"."ImageDesc", "Page"."ShowSidebar", "Page"."ShowFacebook", "Page"."PageBanner1ID", "Page"."PageImageID", "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
Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'rossnugentfounda_slvdb.CalendarDateTime.StartDate' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Line 525 of MySQLDatabase.php
- MySQLDatabase->databaseError(Couldn't run 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"."Priority", "SiteTree"."GenerateMetaData", "SiteTree"."ParentID", "Page"."MainHeading", "Page"."VideoLink", "Page"."VideoDesc", "Page"."ImageDesc", "Page"."ShowSidebar", "Page"."ShowFacebook", "Page"."PageBanner1ID", "Page"."PageImageID", "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 = 6) 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"."Priority", "SiteTree"."GenerateMetaData", "SiteTree"."ParentID", "Page"."MainHeading", "Page"."VideoLink", "Page"."VideoDesc", "Page"."ImageDesc", "Page"."ShowSidebar", "Page"."ShowFacebook", "Page"."PageBanner1ID", "Page"."PageImageID", "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 | Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'rossnugentfounda_slvdb.CalendarDateTime.StartDate' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by,256)
Line 123 of MySQLDatabase.php
- MySQLDatabase->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"."Priority", "SiteTree"."GenerateMetaData", "SiteTree"."ParentID", "Page"."MainHeading", "Page"."VideoLink", "Page"."VideoDesc", "Page"."ImageDesc", "Page"."ShowSidebar", "Page"."ShowFacebook", "Page"."PageBanner1ID", "Page"."PageImageID", "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 = 6) 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"."Priority", "SiteTree"."GenerateMetaData", "SiteTree"."ParentID", "Page"."MainHeading", "Page"."VideoLink", "Page"."VideoDesc", "Page"."ImageDesc", "Page"."ShowSidebar", "Page"."ShowFacebook", "Page"."PageBanner1ID", "Page"."PageImageID", "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"."Priority", "SiteTree"."GenerateMetaData", "SiteTree"."ParentID", "Page"."MainHeading", "Page"."VideoLink", "Page"."VideoDesc", "Page"."ImageDesc", "Page"."ShowSidebar", "Page"."ShowFacebook", "Page"."PageBanner1ID", "Page"."PageImageID", "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 = 6) 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"."Priority", "SiteTree"."GenerateMetaData", "SiteTree"."ParentID", "Page"."MainHeading", "Page"."VideoLink", "Page"."VideoDesc", "Page"."ImageDesc", "Page"."ShowSidebar", "Page"."ShowFacebook", "Page"."PageBanner1ID", "Page"."PageImageID", "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 404 of SQLQuery.php
- SQLQuery->execute()
Line 2736 of DataObject.php
- DataObject->instance_get(Recursion = 1 AND ParentID = 6,`CalendarDateTime`.StartDate ASC,LEFT JOIN `CalendarDateTime` ON `CalendarDateTime`.EventID = `CalendarEvent`.ID,,DataObjectSet)
Line 2714 of DataObject.php
- DataObject::get(CalendarEvent,Recursion = 1 AND ParentID = 6,`CalendarDateTime`.StartDate ASC,LEFT JOIN `CalendarDateTime` ON `CalendarDateTime`.EventID = `CalendarEvent`.ID)
Line 258 of Calendar.php
- Calendar->getRecurringEvents()
Line 399 of Calendar.php
- Calendar->Events(,sfDate,sfDate)
Line 164 of CalendarUI.class.php
- LiveCalendarWidget->getEventsFor(sfDate,sfDate)
Line 194 of CalendarUI.class.php
- LiveCalendarWidget->getWeeks()
Line 248 of CalendarUI.class.php
- LiveCalendarWidget->forTemplate()
Line 290 of CalendarUI.class.php
- LiveCalendarWidget_Controller->handleShow(SS_HTTPRequest)
Line 143 of RequestHandler.php
- RequestHandler->handleRequest(SS_HTTPRequest)
Line 147 of Controller.php
- Controller->handleRequest(SS_HTTPRequest)
Line 282 of Director.php
- Director::handleRequest(SS_HTTPRequest,Session)
Line 125 of Director.php
- Director::direct(/LiveCalendarWidget_Controller/show/201709/20171013/20171013/Calendar/6/0)
Line 127 of main.php