X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2Fbin%2Ffreeside-upgrade;h=198d03ead8b6ad00307ea5b2f02bfc047d6892e0;hb=64a76489463208a44a0009f8ba3bc59fb1be9369;hp=5b94c477579381bb02f5226ab53e22bb5de8aa7c;hpb=dba6b1030a2694cbb69371c171e4ebb8c52db830;p=freeside.git diff --git a/FS/bin/freeside-upgrade b/FS/bin/freeside-upgrade index 5b94c4775..198d03ead 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 ) + # "; } } @@ -464,14 +465,13 @@ Also performs other upgrade functions: current default. [ -s ]: Schema changes only. Useful for Pg/slony slaves where the data + changes will be replicated from the Pg/slony master. [ -r ]: Skip sqlradius updates. Useful for occassions where the sqlradius databases may be inaccessible. [ -c ]: Skip cdr and h_cdr updates. - changes will be replicated from the Pg/slony master. - [ -j ]: Run certain upgrades asychronously from the job queue. Currently used only for the 2.x -> 3.x cust_location, cust_pay and part_pkg upgrades. This may cause odd behavior before the upgrade is