From a25bfbfc574ac41a8a570a9a9b01716291d5a0dc Mon Sep 17 00:00:00 2001 From: Bernardo Gonzalez Kriegel Date: Tue, 26 Apr 2016 23:08:07 -0300 Subject: [PATCH] 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 Signed-off-by: Kyle M Hall --- installer/data/mysql/updatedatabase.pl | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 1e473df0fd..cf02734e6e 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -12352,16 +12352,16 @@ $dbh->do(q{ DROP FOREIGN KEY emfk_basketno; }); -$dbh->(q{ +$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, ADD CONSTRAINT emfk_basketno FOREIGN KEY ( basketno ) REFERENCES aqbasket ( basketno ) ON DELETE CASCADE ON UPDATE CASCADE; }); -print "Upgrade to $DBversion done (Bug 16354 - Fix FK constraints for edifact_messages table)\n"; - SetVersion($DBversion); - } + print "Upgrade to $DBversion done (Bug 16354 - Fix FK constraints for edifact_messages table)\n"; + SetVersion($DBversion); +} # DEVELOPER PROCESS, search for anything to execute in the db_update directory -- 2.39.5