| ( ! ) Fatal error: Uncaught mysqli_sql_exception: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ed.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/global_pet_ed.php on line 90 | ||||
|---|---|---|---|---|
| ( ! ) mysqli_sql_exception: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ed.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/global_pet_ed.php on line 90 | ||||
| Call Stack | ||||
| # | Time | Memory | Function | Location |
| 1 | 0.0015 | 559896 | {main}( ) | .../global_pet_ed.php:0 |
| 2 | 0.0536 | 6193528 | query( $query = '\r\nSELECT \r\n\ted.sku_number,\t\r\n\ted.name,\r\n\ted.product_name,\r\n\tCOUNT(ed.item) as qty,\r\n\ted.date_expired\r\nFROM\r\n(SELECT\r\n products.sku_number,\r\n warehouses.name,\r\n ikuses.iku_id as item,\r\n products.name as product_name,\r\n ikuses.tenant_id,\r\n ikuses.date_expired\r\n \r\n FROM\r\n ikuses\r\n \r\n \r\n left join warehouses ON ikuses.warehouse_id = warehouses.id\r\nleft Join products ON ikuses.product_id = products.id\r\nleft Join tenants ON tenants.id = ikuses.tenant_id\r\nleft Join order_ikus ON'... ) | .../global_pet_ed.php:90 |