[rt-users] error upgrading db from 3.6.3 to 4.0.0

2011-05-02 Thread Hersker, Steve
I'm moving RT to a new server and taking the opportunity to upgrade versions as well. Currently, v3.6.3 on FC4 and MySql 4.1.16. I backed up the db with Mysqldump --opt --add-drop-table --single-transaction -default-character-set=binary -u root -pXXX rt3 rt363.adhoc.bkup Copied the SQL

Re: [rt-users] error upgrading db from 3.6.3 to 4.0.0

2011-05-02 Thread Kevin Falcone
On Mon, May 02, 2011 at 02:03:51PM -0700, Hersker, Steve wrote: SoI 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

Re: [rt-users] error upgrading db from 3.6.3 to 4.0.0 -- SOLVED

2011-05-02 Thread Hersker, Steve
Processing 3.7.81 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 DBD::mysql::st execute failed: Can't DROP 'DelegatedBy'; check that column/key exists at