| ( ! ) 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/karya_muda_stock.php on line 127 | ||||
|---|---|---|---|---|
| ( ! ) 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/karya_muda_stock.php on line 127 | ||||
| Call Stack | ||||
| # | Time | Memory | Function | Location |
| 1 | 0.0015 | 530536 | {main}( ) | .../karya_muda_stock.php:0 |
| 2 | 0.0248 | 878320 | query( $query = '\r\nselect tenantStock.sku_number,\r\n tenantStock.name, \r\n sum(tenantStock.bdg_stock) bdg_stock,\r\n sum(tenantStock.bks_stock) bks_stock,\r\n sum(tenantStock.bgr_stock) bgr_stock,\r\n sum(tenantStock.jks_stock) jks_stock\r\n \r\nfrom (\r\nSELECT \r\n products.sku_number,\r\n products.name, \r\n tenants.company_name,\r\n \r\n SUM(case when warehouses.code = \'BDG\' and ikuses.status IN (\'received\',\'stored\') then 1 else 0 end) as bdg_stock,\r\n\t\tSUM(case wh'... ) | .../karya_muda_stock.php:127 |