From 3b44e46890718e86766a9090bac21cde04d5a0e2 Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Fri, 4 May 2007 07:42:06 +0000 Subject: [PATCH] Database error when inserting work order issues. Fixed --- CHANGELOG.txt | 4 ++++ manufacturing/includes/db/work_order_issues_db.inc | 2 +- 2 files changed, 5 insertions(+), 1 deletion(-) diff --git a/CHANGELOG.txt b/CHANGELOG.txt index 55191e9c..8cf61f6f 100644 --- a/CHANGELOG.txt +++ b/CHANGELOG.txt @@ -19,6 +19,10 @@ Legend: ! -> Note $ -> Affected files +04-May-2007 Joe Hunt + # Database error hen inserting work order issues. Fixed. + $ /manufacturing/includes/db/work_order_issues_db.inc + 03-May-2007 Joe Hunt # Multiple tables and JOIN's have syntax changes in MySQL 5.0.12. Need parentheses. $ /includes/db/manufacturing_db.inc diff --git a/manufacturing/includes/db/work_order_issues_db.inc b/manufacturing/includes/db/work_order_issues_db.inc index 5bcfbad2..fcc6d6f5 100644 --- a/manufacturing/includes/db/work_order_issues_db.inc +++ b/manufacturing/includes/db/work_order_issues_db.inc @@ -25,7 +25,7 @@ function add_work_order_issue($woid, $ref, $to_work_order, $items, $location, $w // insert the actual issue $sql = "INSERT INTO ".TB_PREF."wo_issues (workorder_id, reference, issue_date, loc_code, workcentre_id) - VALUES ($WOID, '$ref', '" . + VALUES ($woid, '$ref', '" . date2sql($date_) . "', '$location', $workcentre)"; db_query($sql,"The work order issue could not be added"); -- 2.30.2