On Mon, May 02, 2011 at 02:03:51PM -0700, Hersker, Steve wrote: > So....I want to upgrade to that instead. There was no UPGRADING.mysql, > just the README saying > to run rt-setup-database.
UPGRADING.mysql is now in docs and is still referenced in README and UPGRADING-3.6 which you should be reading (along with UPGRADING-3.8 and UPGRADING-4.0) > When I try to upgrade from 3.6.3 all the way up to 4.0.0, I'm getting: > > Processing 3.7.81 > > Now populating database schema. > > [Mon May 2 20:53:58 2011] [crit]: DBD::mysql::st execute failed: > Duplicate key name > 'CachedGroupMembers3' at /opt/rt4/sbin/../lib/RT/Handle.pm line 503. > (/opt/rt4/sbin/../lib/RT.pm:340) > > DBD::mysql::st execute failed: Duplicate key name 'CachedGroupMembers3' at > /opt/rt4/sbin/../lib/RT/Handle.pm line 503. Looks like you ran 3.7.81 twice > > Now populating database schema. > > [Mon May 2 20:31:51 2011] [crit]: DBD::mysql::st execute failed: Can't > DROP 'DelegatedBy'; > check that column/key exists at /opt/rt4/sbin/../lib/RT/Handle.pm line 503. > (/opt/rt4/sbin/../lib/RT.pm:340) > > DBD::mysql::st execute failed: Can't DROP 'DelegatedBy'; check that > column/key exists at > /opt/rt4/sbin/../lib/RT/Handle.pm line 503. Looks like you ran something else twice too, since that column has existed since at least 3.4 > Do I need to upgrade incrementally from 3.6.3 to 3.8.9 to 3.9.x and then > to 4.0.0? Is there > info on this that I missed? Or, should the rt-setup-database handle the > jump from 3.6.3 to > 4.0.0 (including 3.8.0's schema changes)? You can use rt-setup-database from 3.6.3 to 3.7.81 follow UPGRADING.mysql and then continue onward from there to 4.0.0 Also, there is no reason to use a 3.8.9 tarball and a 4.0.0 tarball, you can do it all from the fresh install in /opt/rt4 -kevin
pgpliyH9fhN8t.pgp
Description: PGP signature
