Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.

Q2A 1.8.0 beta

+2 votes
asked Oct 12, 2017 in Q2A Core by Arjun Suresh
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
answered Oct 12, 2017 by pupi1985
selected Oct 13, 2017 by Arjun Suresh
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.
commented Oct 13, 2017 by pupi1985
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?
commented Oct 13, 2017 by arjunsuresh
No. With the patched branch it is working fine. Thank you :)
commented Oct 13, 2017 by pupi1985
Great. I'm pretty sure that PR will be merged or the queries will be fixed by the time 1.8 is out
commented Oct 13, 2017 by arjunsuresh
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?