| ( ! ) Fatal error: Uncaught mysqli_sql_exception: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'freshfactory_db.p.sku_number' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by in /var/www/html/plugins/sendmail/ggl-stock.php on line 94 | ||||
|---|---|---|---|---|
| ( ! ) mysqli_sql_exception: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'freshfactory_db.p.sku_number' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by in /var/www/html/plugins/sendmail/ggl-stock.php on line 94 | ||||
| Call Stack | ||||
| # | Time | Memory | Function | Location |
| 1 | 0.0016 | 530480 | {main}( ) | .../ggl-stock.php:0 |
| 2 | 0.0240 | 853296 | query( $query = '\r\nSELECT p.sku_number, p.name,\r\nSUM(CASE WHEN w.name = \'Jakarta Utara\' THEN 1 ELSE 0 END) as \'Jakarta Utara\',\r\nSUM(CASE WHEN w.name = \'Jakarta Pusat\' THEN 1 ELSE 0 END) as \'Jakarta Pusat\',\r\nSUM(CASE WHEN w.name = \'Jakarta Selatan\' THEN 1 ELSE 0 END) as \'Jakarta Selatan\',\r\nSUM(CASE WHEN w.name = \'Jakarta Barat\' THEN 1 ELSE 0 END) as \'Jakarta Barat\',\r\nSUM(CASE WHEN w.name = \'Depok\' THEN 1 ELSE 0 END) as \'Depok\',\r\nSUM(CASE WHEN w.name = \'Bekasi\' THEN 1 ELSE 0 END) as \'Bekasi\',\r\nSUM(CASE WHEN w.name = \'Ta'... ) | .../ggl-stock.php:94 |