[rt-users] Upgrade to 4.01 MySQL questoin

2011-08-08 Thread Paul O'Rorke
My apologies for a silly post but I'm getting confused... I am migrating from 3.8.4 to 4.01. I have a new server with 4.01 installed and mostly set up how I want. I have pulled my database dumps into the new instance, performed the steps in UPGRADING.mysql and run the script */opt/rt4/sbin/rt-se

Re: [rt-users] Upgrade to 4.01 MySQL questoin

2011-08-08 Thread Kevin Falcone
On Mon, Aug 08, 2011 at 03:05:53PM -0700, Paul O'Rorke wrote: >I am migrating from 3.8.4 to 4.01. I have a new server with 4.01 installed > and mostly set up >how I want. I have pulled my database dumps into the new instance, > performed the steps in >UPGRADING.mysql and run the scrip

Re: [rt-users] Upgrade to 4.01 MySQL questoin

2011-08-09 Thread Paul O'Rorke
Thaks Kevin, I missed that in the output. Most of it seems OK up until the part where it processesd 3.9.2 and 3.9.3.: Processing 3.9.2 Now inserting data. [Tue Aug 9 02:42:25 2011] [warning]: DBD::mysql::st execute failed: Unknown column 'main.DelegatedBy' in 'where clause' at /usr/local/share/

Re: [rt-users] Upgrade to 4.01 MySQL questoin

2011-08-09 Thread Kevin Falcone
On Tue, Aug 09, 2011 at 12:27:03PM -0700, Paul O'Rorke wrote: >[Tue Aug 9 02:42:25 2011] [warning]: DBD::mysql::st execute failed: > Unknown column >'main.DelegatedBy' in 'where clause' at This implies that you have a partially upgraded database, since this column is deleted in 3.9.3 Are

Re: [rt-users] Upgrade to 4.01 MySQL questoin

2011-08-09 Thread Paul O'Rorke
no - actually I'm not. I guess I have to change my plan. I had thought to import the data - spend some time setting up 4.01 as I wanted then update the DB by running the import again. I guess this is not such a good idea. I'm thinking then that I'll have to make careful note of the set up chang

Re: [rt-users] Upgrade to 4.01 MySQL questoin

2011-08-09 Thread Kevin Falcone
On Tue, Aug 09, 2011 at 02:56:52PM -0700, Paul O'Rorke wrote: >no - actually I'm not. I guess I have to change my plan. > >I had thought to import the data - spend some time setting up 4.01 as I > wanted then update the >DB by running the import again. I guess this is not such a good

Re: [rt-users] Upgrade to 4.01 MySQL questoin

2011-08-10 Thread Paul O'Rorke
aaah - well then that's what I must do. Thanks for the help. I'll let you know how that goes. regards On Tue, Aug 9, 2011 at 5:14 PM, Kevin Falcone wrote: > On Tue, Aug 09, 2011 at 02:56:52PM -0700, Paul O'Rorke wrote: > >no - actually I'm not. I guess I have to change my plan. > > > >