From 4138783cae8e44f0e15915d55508b64c3b8338b2 Mon Sep 17 00:00:00 2001 From: Bernardo Gonzalez Kriegel Date: Tue, 26 Apr 2016 23:08:07 -0300 Subject: [PATCH] [PASSED QA] Bug 16361: Installer syntax error Bug 16354 introduces a syntax error on updatedatabase.pl see comment #5 there To test 1) Check error on update 3.23.00.051 2) Apply the patch 3) run updatedabase again (perhaps changing 051 to XXX) Signed-off-by: Liz Rea happy again! Signed-off-by: Katrin Fischer --- installer/data/mysql/updatedatabase.pl | 2 ++ 1 file changed, 2 insertions(+) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 1f1c5a0..a6eac32 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -12350,7 +12350,9 @@ $dbh->do(q{ DROP FOREIGN KEY emfk_vendor, DROP FOREIGN KEY emfk_edi_acct, DROP FOREIGN KEY emfk_basketno; + }); +$dbh->do(q{ ALTER TABLE edifact_messages ADD CONSTRAINT emfk_vendor FOREIGN KEY ( vendor_id ) REFERENCES aqbooksellers ( id ) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT emfk_edi_acct FOREIGN KEY ( edi_acct ) REFERENCES vendor_edi_accounts ( id ) ON DELETE CASCADE ON UPDATE CASCADE, -- 1.9.1