[User Error] 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

GET /LiveCalendarWidget_Controller/show/202004/20200311/20200311/Calendar/6/0

Line 525 in /home/rossnugentfounda/public_html/sapphire/core/model/MySQLDatabase.php

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