Database Error | |
---|---|
Message: | MySQL Query fail: select *,date(gp_datetime) as thedate from (select * from goldprice where MONTH(gp_datetime) = 6 and YEAR(gp_datetime) = 2022 order by gp_datetime DESC) AS gp_alias group by date(gp_datetime) order by gp_datetime DESC |
MySQL Error: | Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'gp_alias.gp_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by |
Date: | Saturday, June 25, 2022 at 4:32:56 PM |
Script: | /month-2022-06-%D8%A7%D8%B3%D8%B9%D8%A7%D8%B1-%D8%A7%D9%84%D8%B0%D9%87%D8%A8-%D8%B4%D9%87%D8%B1-.html |