| ( ! ) Fatal error: Uncaught mysqli_sql_exception: Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'freshfactory_db.w.id' 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/email_inventory_level.php on line 103 | ||||
|---|---|---|---|---|
| ( ! ) mysqli_sql_exception: Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'freshfactory_db.w.id' 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/email_inventory_level.php on line 103 | ||||
| Call Stack | ||||
| # | Time | Memory | Function | Location |
| 1 | 0.0016 | 592576 | {main}( ) | .../email_inventory_level.php:0 |
| 2 | 0.0579 | 6242496 | query( $query = 'SELECT \r\nCURDATE() AS hari_ini,\r\nCURRENT_TIME() AS jam,\r\np.id AS product_id,\r\nw.id AS warehouse_id,\r\nt.company_name AS penyewa,\r\nw.name AS gudang_penyimpanan,\r\nCASE \r\n\tWHEN isCreator = 0 THEN \'T2T\'\r\n\tELSE \'Inventaris\'\r\nEND AS tipe_barang,\r\np.sku_number AS kode_sku,\r\np.name AS nama_produk,\r\ni.Fulfillment AS fulfilment_iku_masa_pengawasan,\r\ni.stock as iku_tersedia_sekarang,\r\nISNULL(ikuses.date_expired < DATE(NOW())) AS iku_tersedia_sekarang_masa_simpan,\r\n\r\nCEIL(i.Fulfillment+(i.Fulfillment/7)) as fulfilment_'... ) | .../email_inventory_level.php:103 |