SQL Errors on clean build when adding blogs

Permalink
Hi Community

I'm a new user of concrete5, I've installed it onto an Ubuntu 16.04 server for evaluation as a CMS for our school but I'm having some SQL issues.
Can anyone help me?
When I try to add a new blog I get the following....

An exception occurred while executing 'SELECT date_format(cv.cvDatePublic, "%Y") as navYear, date_format(cv.cvDatePublic, "%m") as navMonth FROM Pages p 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 (pt.ptID = ?) AND (p.cParentID = ?) AND (p.cPointerID < 1) AND (p.cIsTemplate = 0) AND (cvIsApproved = 1) AND (p.cIsActive = ?) AND (p.cIsSystemPage = ?) GROUP BY navYear, navMonth ORDER BY cvDatePublic desc' with params [7, 159, true, false]: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'intranet.cv.cvDatePublic' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

jasonbbcah39
 
MrKDilkington replied on at Permalink Best Answer Reply
MrKDilkington
Hi jasonbbcah39,

Another user was receiving this error and found a solution for it:
https://www.concrete5.org/community/forums/installation/issue-when-i...

"It was happening due MySql version change.
Solved it by adding my.ini file changes:-

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
jasonbbcah39 replied on at Permalink Best Answer Reply
jasonbbcah39
Great! That fixed the sql issue a treat.

Cheers
Jason