DEA fotoblog



PHP-STATS AUTO DEBUG MODE
QUERY:
SELECT SUBSTRING_INDEX(data,'/',3) as dom,SUM(visits) as sumvisits,MAX(date) as date FROM php_stats_referer GROUP BY dom ORDER BY data DESC LIMIT 0,100

MySql ERROR:
1055: Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'Sql1427801_1.php_stats_referer.data' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

v2.7 © Roberto Bizzarri - Server timestamp: 6/02/23 16:10 - Browscap rel.: 19 Jan 2023