[rt-users] Error When Upgrade-Database from 3.8.1 to 3.8.2

[Rutgers Marine]

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 <falcone at 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