From 9991a3c99ec472f1ad00062e588435adaf1b60bc Mon Sep 17 00:00:00 2001 From: Alexander Smirnov Date: Mon, 3 Jun 2024 14:00:33 +0300 Subject: [PATCH] fix bug --- erp24/modul/products/ajax_product_provider_add.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/erp24/modul/products/ajax_product_provider_add.php b/erp24/modul/products/ajax_product_provider_add.php index d83130be..01a69c1a 100644 --- a/erp24/modul/products/ajax_product_provider_add.php +++ b/erp24/modul/products/ajax_product_provider_add.php @@ -19,7 +19,7 @@ if(!empty($_REQUEST["id"])) { if($_REQUEST["view"]=="on") $view=1; else $view=0; - $db::sql("UPDATE products_1c SET view=? WHERE id=? LIMIT 1",[$view,$id]); + $db::sql("UPDATE products_1c SET view=? WHERE id=?",[$view,$id]); $sql = "INSERT INTO products_1c_options (id, options, provider_id, expiration_days,min_lot,colors,price_zakup,min_order,group_id,main) VALUES (?, ?, ?, ?,?,?,?,?,?, ?) ON CONFLICT (id) DO UPDATE SET options=?, provider_id=?, expiration_days=?, min_lot=?, colors=?, price_zakup=?, min_order=?, group_id=?, main=? "; -- 2.39.5