Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
+2 votes
1.3k views
in Q2A Core by
Q2A 1.8 is really nice with many essential features.

While checking, in the question page I'm getting the following error:

PHP Question2Answer MySQL query error 1055: Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'qa1.children.acount' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Query: UPDATE qa_posts AS x, (SELECT parents.postid, parents.created AS qcreated, COALESCE(MAX(children.created), parents.created) as acreated, children.acount, parents.netvotes, parents.views FROM qa_posts AS parents LEFT JOIN qa_posts AS children ON parents.postid=children.parentid AND children.type='A' WHERE parents.postid BETWEEN 39618 AND 39618 GROUP BY postid) AS a SET x.hotness=(((TO_DAYS(a.qcreated)-734138)*86400.0+TIME_TO_SEC(a.qcreated))*10 + ((TO_DAYS(a.acreated)-734138)*86400.0+TIME_TO_SEC(a.acreated))*30 + (a.acount+0.0)*12000000 + (a.netvotes+0.0)*16000000 + (a.views+0.0)*320000) WHERE x.postid=a.postid, referer: http://db.gateoverflow.in/activity
Q2A version: 1.8.0

1 Answer

+3 votes
by
selected by
 
Best answer
That should have been solved in the current dev branch: https://github.com/q2a/question2answer/archive/dev.zip . Give it a try.

Note the commit that fixes that fell out of the 1.8 branch for a couple of days but will surely be included in the final 1.8 release.
by
Thank you pupi. Now it works but some of the question pages still have the same error.
by
Yes, there could be some other missing queries to update. Can you post the URLs? E.G.: /activity
by
Actually this happens for individual question posts. Some of them works fine, but some don't. Question list is here: http://db.gateoverflow.in/activity
by
Track this PR: https://github.com/q2a/question2answer/pull/551

The branch with the fix should be this one: https://github.com/pupi1985/question2answer/archive/patch-92.zip

Let me know if that one still generates the issue. Also remember you can just disable the strict group by flag: https://stackoverflow.com/a/36033983/268273
by
Thank you pupi. I was just testing Q2A 1.8.0. Everything else seems fine. I'll try adding plugins too.
by
Sorry, but I didn't quite get your last comment. The patch-92 branch is based on the dev branch which is based on the 1.8 branch. Did you still face the nonaggregated column issues with the patch-92 branch?
by
No. With the patched branch it is working fine. Thank you :)
by
Great. I'm pretty sure that PR will be merged or the queries will be fixed by the time 1.8 is out
by
Hope so  :) I would like to buy some plugins from you but my Paypal email id is no longer active -- my Institute just deleted it one day :) Would it be possible for you to send me the plugin to another email?
...