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
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?
...