Hey all, I've been scouring the net as well as our config docs trying to figure out what maybe causing my upgrade issues with DelegatedBy. We have mysql setup with the innodb settings and 3.8.8 working great with RTIR.
Specifically there are two warnings. Which the upgrade script passed on, then two critical errors. Any suggestions would be greatly appreciated. Full log below: 3.8.9 ok 3.9.1 ok Processing 3.9.2 Now inserting data. [Thu Jan 3 16:46:18 2013] [warning]: DBD::mysql::st execute failed: Unknown column 'main.DelegatedBy' in 'where clause' at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 587. (/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:587) [Thu Jan 3 16:46:18 2013] [warning]: RT::Handle=HASH(0x1f53e620) couldn't execute the query 'SELECT main.* FROM ACL main WHERE (main.DelegatedBy > '0') AND (main.DelegatedFrom > '0') ' at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 600 DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x1f53e620)', 'SELECT main.* FROM ACL main WHERE (main.DelegatedBy > \'0\')...') called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm line 236 DBIx::SearchBuilder::_DoSearch('RT::ACL=HASH(0x1f1db0d0)') called at /tmp/rt-4.0.8/sbin/../lib/RT/SearchBuilder.pm line 343 RT::SearchBuilder::_DoSearch('RT::ACL=HASH(0x1f1db0d0)') called at /tmp/rt-4.0.8/sbin/../lib/RT/ACL.pm line 263 RT::ACL::_DoSearch('RT::ACL=HASH(0x1f1db0d0)') called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm line 504 DBIx::SearchBuilder::Next('RT::ACL=HASH(0x1f1db0d0)') called at /tmp/rt-4.0.8/sbin/../lib/RT/ACL.pm line 228 RT::ACL::Next('RT::ACL=HASH(0x1f1db0d0)') called at ./etc/upgrade/3.9.2/content line 19 RT::Handle::__ANON__() called at /tmp/rt-4.0.8/sbin/../lib/RT/Handle.pm line 769 eval {...} called at /tmp/rt-4.0.8/sbin/../lib/RT/Handle.pm line 769 RT::Handle::InsertData('RT::Handle=HASH(0x1f53e620)', './etc/upgrade/3.9.2/content', 'undef') called at sbin/rt-setup-database line 293 main::action_insert('prompt-for-dba-password', 1, 'datafile', 'undef', 'action', 'upgrade', 'datadir', './etc/upgrade/3.9.2', 'backcompat', ...) called at sbin/rt-setup-database line 399 main::action_upgrade('prompt-for-dba-password', 1, 'action', 'upgrade', 'dba', 'root') called at sbin/rt-setup-database line 198 (/usr/lib/perl5/5.8.8/Carp.pm:272) [Thu Jan 3 16:46:18 2013] [critical]: _DoSearch is not so successful as it still needs redo search, won't call _BuildHash (/tmp/rt-4.0.8/sbin/../lib/RT/ACL.pm:266) Processing 3.9.3 Now populating database schema. [Thu Jan 3 16:46:18 2013] [critical]: DBD::mysql::st execute failed: Can't DROP 'DelegatedBy'; check that column/key exists at /tmp/rt-4.0.8/sbin/../lib/RT/Handle.pm line 515. (/tmp/rt-4.0.8/sbin/../lib/RT.pm:341) DBD::mysql::st execute failed: Can't DROP 'DelegatedBy'; check that column/key exists at /tmp/rt-4.0.8/sbin/../lib/RT/Handle.pm line 515. make: *** [upgrade-database] Error 255 Thanks -- Mike of Many Stories, Ideas, and Ramblings Game Chef 2009, 2010 NaNoWriMo 2008, 2009,2010 http://mikeofmanystories.blogspot.com/ - writings http://mikeofmany.wordpress.com/ - personal bloggery http://securityenmass.blogspot.com/ - Security thoughts with a dose of common sense