From 301e84f971fcaad601cbf293b070f6b662248783 Mon Sep 17 00:00:00 2001 From: Maxime Bourget Date: Tue, 11 Jun 2013 14:04:00 +0100 Subject: [PATCH] Use TB_PREF. --- includes/db_order_lines.inc | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/includes/db_order_lines.inc b/includes/db_order_lines.inc index 266b343..94ed65f 100644 --- a/includes/db_order_lines.inc +++ b/includes/db_order_lines.inc @@ -122,7 +122,7 @@ function update_order_detail_defaults($use_order_date=false) { // Set priority to current time. $sql = "UPDATE ".TB_PREF."sales_order_details"; if($use_order_date) { - $sql .= " NATURAL JOIN 0_sales_orders + $sql .= " NATURAL JOIN ".TB_PREF."sales_orders SET priority = ord_date"; } else { @@ -133,7 +133,7 @@ function update_order_detail_defaults($use_order_date=false) { // Set hold_until_date to delivery_date $sql = "UPDATE ".TB_PREF."sales_order_details - NATURAL JOIN 0_sales_orders + NATURAL JOIN ".TB_PREF."sales_orders SET hold_until_date = delivery_date WHERE hold_until_date is null"; $ok &= db_query($sql); -- 2.30.2