From 235c15d29c2b201cbd36b97b8b697227ac899916 Mon Sep 17 00:00:00 2001 From: marina Date: Sat, 27 Apr 2024 18:07:32 +0300 Subject: [PATCH] =?utf8?q?insert=20ignore=20c=20mysql=20=D0=BF=D0=B5=D1=80?= =?utf8?q?=D0=B5=D0=B2=D0=B5=D0=B4=D0=B5=D0=BD=20postgresql=20=D0=BF=D1=80?= =?utf8?q?=D0=B0=D0=B2=D0=BA=D0=B8?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- erp24/modul/shipment/functionsShipment.php | 5 ++--- 1 file changed, 2 insertions(+), 3 deletions(-) diff --git a/erp24/modul/shipment/functionsShipment.php b/erp24/modul/shipment/functionsShipment.php index fb5e8425..3a6010eb 100644 --- a/erp24/modul/shipment/functionsShipment.php +++ b/erp24/modul/shipment/functionsShipment.php @@ -428,11 +428,10 @@ $status_store=""; if(!empty($store_id)) { if(!empty($_GET["status"]) and !empty($store_id) and !empty($orderId)) { - $db::sql("INSERT INTO store_order_status_log (order_id, store_id, status_id, status, date, admin_id) - VALUES ('$orderId', '$store_id', $status_order_id, 1, NOW(), " . $_SESSION["admin_id"] . ") + $db::sql("INSERT INTO store_order_status_log (order_id, status_id, status, date, admin_id) + VALUES ('$orderId', $status_order_id, 1, NOW(), " . $_SESSION["admin_id"] . ") ON CONFLICT (id) DO UPDATE SET order_id = '$orderId', - store_id = '$store_id', status_id = $status_order_id, status = 1, date = NOW(), -- 2.39.5