Expression #2 of SELECT SUM()

[thatsawan]

Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'picture_***.d.buy_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [1055]

SQL

SELECT d.oder_id, d.buy_date,SUM(d.sum) as sum ,SUM(d.price) as price FROM (phpbb_m_pt_buy_photo_detail d) GROUP BY d.oder_id