[rt-users] Problems upgrading from 3.9.3

[Kevin Falcone]

On Tue, Apr 23, 2013 at 06:11:33AM -0700, saxmad wrote:
> [Tue Apr 23 13:06:53 2013] [warning]: DBD::Pg::st execute failed: ERROR: 
> column main.delegatedby does not exist
> LINE 1: SELECT main.* FROM ACL main  WHERE (main.DelegatedBy > '0') ...
>                                             ^ at
> /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 509, <> line 1.
> (/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:509)
> 
> Firstly, seeing as it tried to do the 3.9.3 upgrade, can I assume that the
> 3.9.2 upgrade did in fact go through, despite the messages ?
> 
> Secondly, what course of action is needed to fix the 3.9.3 upgrade message ? 
> It seems to be related to the messages in the 3.9.2 upgrade, so maybe that
> didn't got through cleanly.

You have not completed 3.9.2.
Show the schema of your ACL table now and show it on your 3.6.7
instance.  Then restore cleanly to test run an upgrade again and show
the ACL schema there.

The DelegatedBy column is dropped during the 3.9.3 step, so getting an
error in 3.9.2 about it missing implies something is wrong.

-kevin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 235 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130423/8420d90c/attachment.sig>