Hi I ran the upgrade the first time as you indicated just let it run from 3.2.2 to 4.0.7, and that failed as well. So I went back through the docs and the was a step that stated to stop after 3.8.7.
Cynthia Roe CRoe Photography (732) 882-6079 http://croephotography.com On Oct 24, 2012, at 10:58 PM, Kevin Falcone <falc...@bestpractical.com> wrote: > On Mon, Oct 22, 2012 at 05:13:57PM -0400, Cynthia Roe wrote: >> I am in the process of upgrade our RT environment from 3.2.2 to 4.0.7. >> So far I have been able to upgrade successfully from 3.2.2 to 3.8.1. >> However, when I run the $ make upgrade-database from 3.8.1 to 3.8.2 I >> received the following error: > > Is there a particular reason that you're going one upgrade at a time? > We wrote the make upgrade-database command to make running them all > much easier than it ever was in older versions. > > In this case, the problem is that RT's code expects the ACL table to > have a Creator field, but the 3.8.2 upgrade is run before the schema > change. We actually have code to handle this and if you let it just > run from 3.8.1 -> 4.0.6 instead of taking single steps, it will > complete correctly. > > There's a bug that it only looks for our special "backcompat" file in > the versions of the upgrade you specified, and we should fix that, but > I'm not sure why you're running the upgrade in single steps instead of > just letting it go and only revisiting it if something fails? > > I've filed a bug about this > http://issues.bestpractical.com/Ticket/Display.html?id=21317 > > -kevin > >> $ make upgrade-database >> Enter RT version you're upgrading from: 3.8.1 >> >> Going to apply following upgrades: >> * 3.8.2 >> * 3.8.3 >> * 3.8.4 >> * 3.8.6 >> * 3.8.8 >> * 3.8.9 >> * 3.9.1 >> * 3.9.2 >> * 3.9.3 >> * 3.9.5 >> * 3.9.6 >> * 3.9.7 >> * 3.9.8 >> * 4.0.0rc2 >> * 4.0.0rc4 >> * 4.0.0rc7 >> * 4.0.1 >> * 4.0.3 >> * 4.0.4 >> * 4.0.6 >> >> Enter RT version if you want to stop upgrade at some point, >> or leave it blank if you want apply above upgrades: 3.8.2 >> >> Going to apply following upgrades: >> * 3.8.2 >> >> IT'S VERY IMPORTANT TO BACK UP BEFORE THIS STEP >> >> Proceed [y/N]:y >> Processing 3.8.2 >> Now inserting data. >> [Mon Oct 22 20:54:57 2012] [warning]: Going to add [OLD] prefix to all >> templates in approvals queue. If you have never used approvals, you can >> safely delete all the templates with the [OLD] prefix. Leave the new >> Approval templates because you may eventually want to start using approvals. >> (./etc/upgrade/3.8.2/content:3) >> [Mon Oct 22 20:54:58 2012] [warning]: DBD::mysql::st execute failed: Unknown >> column 'Creator' in 'field list' at >> /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 587. >> (/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:587) > > -------- > Final RT training for 2012 in Atlanta, GA - October 23 & 24 > http://bestpractical.com/training > > We're hiring! http://bestpractical.com/jobs -------- Final RT training for 2012 in Atlanta, GA - October 23 & 24 http://bestpractical.com/training We're hiring! http://bestpractical.com/jobs