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 _______________________________________________ Rtir mailing list [email protected] http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rtir
