From: Ivan Kohler <ivan@freeside.biz>
Date: Fri, 6 Jun 2014 22:21:05 +0000 (-0700)
Subject: just don't attempt to auto-set upgrade_journal.upgradenum sequence, mysql is drain... 
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=dca8165e63b41dbf72a12a171ccfda2b17a420ca

just don't attempt to auto-set upgrade_journal.upgradenum sequence, mysql is drain bramaged, RT#28895
---

diff --git a/FS/bin/freeside-upgrade b/FS/bin/freeside-upgrade
index e74abbfd0..bf99be639 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 )
+  #  ";
   }
 }