Delete order doesn't use DB_PREFIX in the qty update
Posted: Thu Jul 23, 2009 4:48 am
A new feature of 1.3.0 is to auto increment stock when deleting an order from admin
But the sql query doesn't use the DB_PREFIX part.
Easy fix.
EDIT: admin/model/customer/order.php
FIND:
REPLACE WITH:
But the sql query doesn't use the DB_PREFIX part.
Easy fix.
EDIT: admin/model/customer/order.php
FIND:
Code: Select all
$this->db->query("UPDATE `product` SET quantity = (quantity + " . (int)$product['quantity'] . ") WHERE product_id = '" . (int)$product['product_id'] . "'");
Code: Select all
$this->db->query("UPDATE " . DB_PREFIX . "product SET quantity = (quantity + " . (int)$product['quantity'] . ") WHERE product_id = '" . (int)$product['product_id'] . "'");