[Rtir] RT 4.x status

[Kevin Falcone]

On Tue, Mar 13, 2012 at 05:20:04PM +0100, Marco Thorbruegge wrote:
> 
> Enter RT version if you want to stop upgrade at some point,
>   or leave it blank if you want apply above upgrades: <blank>
> 
> IT'S VERY IMPORTANT TO BACK UP BEFORE THIS STEP
> 
> Proceed [y/N]: y
> 
> Processing 3.9.1
> Now inserting data.
> Processing 3.9.2
> Now inserting data.
> [Tue Mar 13 17:06:47 2012] [warning]: DBD::mysql::st execute failed:
> Unknown column 'main.DelegatedBy' in 'where clause' at
> /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587, <>
> line 1. (/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
> [Tue Mar 13 17:06:47 2012] [warning]: RT::Handle=HASH(0x4aa1638)
> couldn't execute the query 'SELECT main.* FROM ACL main  WHERE
> (main.DelegatedBy > '0') AND (main.DelegatedFrom > '0') ' at
> /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

This implies that you ran the upgrade twice, or are running it against
a 4.0 schema.  ACL.DelegatedBy exists in 3.8 and is removed in
etc/upgrade/3.9.3  etc/upgrade/3.9.2 relies on it being there to clean
out old data.

You should check the schema of the ACL table before you start your
upgrade (with a clean import of 3.8.10, be sure that EVERY table in
your rt4 database is gone before you import 3.8.10's data).

> BTW: In my frustration i did a new install of RT 4.0.5 and RTIR 3.0.0
> RC1. I did a "make initialise-database" and then imported a recent dump
> from RT3.8.10/RTIR2.6.1 into the RT4 database (cat rt3-dump.sql | mysql
> -u root -p rt4).
> 
> It seems to work for many things, but not for all (lookup of IP-adresses
> only partial works for example.)

Copying in the data directly from 3.8 shouldn't work. There are several
schema changes on the rt side.

-kevin