An unexpected error occurred.

An exception occurred while executing 'SELECT p.cID, event.eID as eID, event.sttime as eventstart, event.entime as eventend, event.grouped as grouped, event.category as category, as eventdate FROM Pages p LEFT JOIN btProEventDates event ON p.cID = event.eventID LEFT JOIN PagePaths pp ON (p.cID = pp.cID and pp.ppIsCanonical = true) LEFT JOIN PageSearchIndex psi ON p.cID = psi.cID LEFT JOIN PageTypes pt ON p.ptID = pt.ptID INNER JOIN Collections c ON p.cID = c.cID INNER JOIN CollectionVersions cv ON p.cID = cv.cID LEFT JOIN CollectionSearchIndexAttributes csi ON c.cID = csi.cID WHERE ((( = '2020-05-27' AND event.sttime > ?) OR > ?)) AND (p.cParentID = ?) AND (p.cPointerID < 1) AND (p.cIsTemplate = 0) AND (cvIsApproved = 1) AND (p.cIsActive = ?) AND (p.cIsSystemPage = ?) GROUP BY event.grouped, event.eventID ORDER BY, event.sttime ASC LIMIT 5 OFFSET 0' with params ["04:52:52", "2020-05-27", "190", true, false]: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'hackshaf_mnsbaConcrete5.event.eID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

< Back to Home