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
