From c126586039e34cdde988cdf854a66958e9752de8 Mon Sep 17 00:00:00 2001 From: Ivan Kohler Date: Fri, 6 Jun 2014 15:21:02 -0700 Subject: [PATCH] just don't attempt to auto-set upgrade_journal.upgradenum sequence, mysql is drain bramaged, RT#28895 --- FS/bin/freeside-upgrade | 11 ++++++----- 1 file changed, 6 insertions(+), 5 deletions(-) diff --git a/FS/bin/freeside-upgrade b/FS/bin/freeside-upgrade index 5b94c4775..7e074ccb1 100755 --- a/FS/bin/freeside-upgrade +++ b/FS/bin/freeside-upgrade @@ -100,11 +100,12 @@ if ( dbdef->table('upgrade_journal') ) { ( SELECT MAX(upgradenum) FROM upgrade_journal ) ) "; - } elsif ( driver_name =~ /^mysql/i ) { - push @bugfix, " - ALTER TABLE upgrade_journal AUTO_INCREMENT = - ( ( SELECT MAX(upgradenum) FROM upgrade_journal ) + 1 ) - "; + #MySQL can't do this in a statement so have to do it manually + #} elsif ( driver_name =~ /^mysql/i ) { + # push @bugfix, " + # ALTER TABLE upgrade_journal AUTO_INCREMENT = + # ( ( SELECT MAX(upgradenum) FROM upgrade_journal ) + 1 ) + # "; } } -- 2.11.0