| ( ! ) Fatal error: Uncaught mysqli_sql_exception: Expression #3 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/cosmart-stock_ed.php on line 96 | ||||
|---|---|---|---|---|
| ( ! ) mysqli_sql_exception: Expression #3 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/cosmart-stock_ed.php on line 96 | ||||
| Call Stack | ||||
| # | Time | Memory | Function | Location |
| 1 | 0.0013 | 534376 | {main}( ) | .../cosmart-stock_ed.php:0 |
| 2 | 0.0283 | 857472 | query( $query = '\r\nSELECT \r\n\ted.sku_number,\r\n\ted.name,\r\n\ted.product_name,\r\n\ted.barcode,\r\n\ted.company_name,\r\n\tCASE \r\n\tWHEN ed.status = \'ordered\' THEN \'Dipesan\'\r\n\tWHEN ed.status = \'packing\' THEN \'Sedang Dikemas\'\r\n\tWHEN ed.status = \'packed\' THEN \'Sudah Dikemas\'\r\n\tWHEN ed.status = \'stored\' THEN \'Tersimpan\'\r\n\tWHEN ed.status = \'received\' THEN \'Diterima\'\r\n\tWHEN ed.status = \'disposal requested\' THEN \'Pemusnahan Diminta\'\r\n\tWHEN ed.status = \'disposal process\' THEN \'Pemusnahan Diproses\' \r\n\tWHEN ed.status = \'investigate\' THEN \'Investig'... ) | .../cosmart-stock_ed.php:96 |