| ( ! ) Fatal error: Uncaught mysqli_sql_exception: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'freshfactory_db.products.name' 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/sirclo-stock_revsplit.php on line 91 | ||||
|---|---|---|---|---|
| ( ! ) mysqli_sql_exception: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'freshfactory_db.products.name' 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/sirclo-stock_revsplit.php on line 91 | ||||
| Call Stack | ||||
| # | Time | Memory | Function | Location |
| 1 | 0.0013 | 534368 | {main}( ) | .../sirclo-stock_revsplit.php:0 |
| 2 | 0.0271 | 855432 | query( $query = '\r\n\t\t\r\nSELECT \r\n products.sku_number,\r\n products.name, \r\n CASE WHEN warehouses.id = \'3ae5e101-25dc-4233-b731-9da7df06df8d\' \r\n THEN SUM(CASE\r\n WHEN ikuses.status = \'stored\' THEN 1 ELSE 0\r\n END)\r\n ELSE 0 END as \'Sirclo - Tangerang\',\r\n \r\n\t\tCASE WHEN warehouses.id = \'65b22bb0-ff66-4152-ad91-435a10e27c9e\' THEN SUM(CASE\r\n WHEN ikuses.status = \'stored\' THEN 1 ELSE 0\r\n END)\r\n ELSE 0 END as \'Sirclo - Jakarta Selatan\',\r\n \r'... ) | .../sirclo-stock_revsplit.php:91 |