I replaced the CMS files on the server with the new ones from the zip. I then tried to log into admin_cms. It brought up the login box but when I tried to log in I got:
SELECT (SELECT Count(*) FROM pcms2_contents as ps4count WHERE ps4count.ContentGroup = pcms2_contents.ContentGroup AND ContentRefID NOT LIKE 'meta-%') AS ContentCount, ContentGroup, Min(ContentID) AS ContentID, ContentPageName, Min(ContentPageSetParentID) AS ContentPageSetParentID, ContentPageSetOrder FROM pcms2_contents GROUP BY ContentGroup ORDER BY ContentPageSetOrder DESC, ContentGroup, ContentID
Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'awieseth_awcms.pcms2_contents.ContentPageName' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
I tried creating a new empty database but when I uploaded it I get the same message as above.
Do you have any idea of what is happening: