X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2Fbin%2Ffreeside-upgrade;h=95916aed2b74407d792d611db4202a7e6296b7c2;hb=c69b65ad2d388ecf94f4313bb68c98218a18960d;hp=e74abbfd0a5b8888b1bba8c2bd9e3e0d6e20d8c7;hpb=704df08c7f81c0ac0e828362f0b1304225757374;p=freeside.git diff --git a/FS/bin/freeside-upgrade b/FS/bin/freeside-upgrade index e74abbfd0..95916aed2 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