Error - Invalid query: SQLSTATE
We had a website running Perch 2.8.14 and blog 4.6 - it was running fine on Friday, then the client's host provider did some upgrades or something. They won't say. Monday morning the site was showing no Blog Posts and just 1970.
I won't bore you will details about convo with host, but we upgraded client stage, Perch to 2.8.26 and the Blog to 5.0.
We turned on error checking and we see:
Invalid query: SQLSTATE: Syntax error or access violation: 1055 'thepoint_stage.main.postID' isn't in GROUP BY
Array ( [type] => 8 [message] => Undefined offset: 0 [file] => /home/thepoint/public_html/stage/latest-issue.php [line] => 81 )
Our dev stage did not show any errors.
Is this from the host running mySQL in STRICT mode?
The problem has now magically resolved itself, the site running the old core and blog work now. I'm trying to find out what happened and the host won't say if they changed anything. Any help much appreciated as we don't want this happening again.