[rt-users] upgrading from .88 to 408 sql issues

[Mike S]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130103/f6986540/attachment.htm>