Query: SELECT a.sub_id, a.user_id, a.action_id, a.object_id, a.object_data, a.add_time, GROUP_CONCAT(a.id) AS ids, COUNT(a.user_id) AS cnt, FROM_UNIXTIME(a.add_time, '%Y-%m-%d %H') AS hourly, u.username, u.avatar, u.gender FROM aspro320_56_activity AS a LEFT JOIN aspro320_56_user AS u ON (u.user_id = a.user_id AND u.status = 1) WHERE a.user_id > 0 AND a.status = 1 GROUP BY a.sub_id, a.user_id, a.action_id, hourly ORDER BY a.add_time DESC LIMIT 100
User Message: Failed to prepare query!
Error: Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'porn01_aspro320.a.object_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Query: SELECT a.sub_id, a.user_id, a.action_id, a.object_id, a.object_data, a.add_time, GROUP_CONCAT(a.id) AS ids, COUNT(a.user_id) AS cnt, FROM_UNIXTIME(a.add_time, '%Y-%m-%d %H') AS hourly, u.username, u.avatar, u.gender FROM aspro320_56_activity AS a LEFT JOIN aspro320_56_user AS u ON (u.user_id = a.user_id AND u.status = 1) WHERE a.user_id > 0 AND a.status = 1 GROUP BY a.sub_id, a.user_id, a.action_id, hourly ORDER BY a.add_time DESC LIMIT 100
Error Message: Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'porn01_aspro320.a.object_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Error Code: 1055