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

[Kevin Falcone]

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)
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20121024/c12e4efe/attachment.sig>