<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.apple-style-span
{mso-style-name:apple-style-span;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-GB link=blue vlink=purple><div class=WordSection1><p class=MsoNormal>Hi,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>We have upgraded from RT 3.8.6 (Ubuntu 8.0.4, Mysql,Posfix,Apache) to 4.0.1 but ran into a problem whilst upgrading the database. We created a new RT4 database with ‘make initialize-database’ and imported an rt3 dump with ‘mysql -p rt4 < rt3.dump’.<o:p></o:p></p><p class=MsoNormal><span class=apple-style-span><span style='color:black'><o:p> </o:p></span></span></p><p class=MsoNormal><span class=apple-style-span><span style='color:black'>We then ran ‘/opt/rt4/sbin/rt-setup-database --prompt-for-dba-password --action upgrade’ to upgrade the database but received the error below at the upgrading 3.9.1. stage</span></span>.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Has anyone experienced the same problem or did I maybe miss something out?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Regards,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Wikus<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Enter RT version you're upgrading from: 3.8.6<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Going to apply following upgrades:<o:p></o:p></p><p class=MsoNormal>* 3.8.8<o:p></o:p></p><p class=MsoNormal>* 3.8.9<o:p></o:p></p><p class=MsoNormal>* 3.9.1<o:p></o:p></p><p class=MsoNormal>* 3.9.2<o:p></o:p></p><p class=MsoNormal>* 3.9.3<o:p></o:p></p><p class=MsoNormal>* 3.9.5<o:p></o:p></p><p class=MsoNormal>* 3.9.6<o:p></o:p></p><p class=MsoNormal>* 3.9.7<o:p></o:p></p><p class=MsoNormal>* 3.9.8<o:p></o:p></p><p class=MsoNormal>* 4.0.0rc2<o:p></o:p></p><p class=MsoNormal>* 4.0.0rc4<o:p></o:p></p><p class=MsoNormal>* 4.0.0rc7<o:p></o:p></p><p class=MsoNormal>* 4.0.1<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Enter RT version if you want to stop upgrade at some point,<o:p></o:p></p><p class=MsoNormal> or leave it blank if you want apply above upgrades: <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>IT'S VERY IMPORTANT TO BACK UP BEFORE THIS STEP<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Proceed [y/N]:y<o:p></o:p></p><p class=MsoNormal>Processing 3.8.8<o:p></o:p></p><p class=MsoNormal>Now inserting data.<o:p></o:p></p><p class=MsoNormal>Processing 3.8.9<o:p></o:p></p><p class=MsoNormal>Now inserting data.<o:p></o:p></p><p class=MsoNormal>Processing 3.9.1<o:p></o:p></p><p class=MsoNormal>Now inserting data.<o:p></o:p></p><p class=MsoNormal>[Fri Jul 29 08:03:16 2011] [warning]: Couldn't change Type of Template #1: That is already the current value (./etc/upgrade/3.9.1/content:28)<o:p></o:p></p><p class=MsoNormal>[Fri Jul 29 08:03:16 2011] [warning]: Couldn't change Type of Template #2: That is already the current value (./etc/upgrade/3.9.1/content:28)<o:p></o:p></p><p class=MsoNormal>[Fri Jul 29 08:03:16 2011] [warning]: Couldn't change Type of Template #3: That is already the current value (./etc/upgrade/3.9.1/content:28)<o:p></o:p></p><p class=MsoNormal>[Fri Jul 29 08:03:16 2011] [warning]: Couldn't change Type of Template #4: That is already the current value (./etc/upgrade/3.9.1/content:28)<o:p></o:p></p><p class=MsoNormal>[Fri Jul 29 08:03:16 2011] [warning]: Couldn't change Type of Template #5: That is already the current value (./etc/upgrade/3.9.1/content:28)<o:p></o:p></p><p class=MsoNormal>[Fri Jul 29 08:03:16 2011] [warning]: Couldn't change Type of Template #6: That is already the current value (./etc/upgrade/3.9.1/content:28)<o:p></o:p></p><p class=MsoNormal>[Fri Jul 29 08:03:16 2011] [warning]: Couldn't change Type of Template #7: That is already the current value (./etc/upgrade/3.9.1/content:28)<o:p></o:p></p><p class=MsoNormal>[Fri Jul 29 08:03:16 2011] [warning]: Couldn't change Type of Template #8: That is already the current value (./etc/upgrade/3.9.1/content:28)<o:p></o:p></p><p class=MsoNormal>[Fri Jul 29 08:03:16 2011] [warning]: Couldn't change Type of Template #9: That is already the current value (./etc/upgrade/3.9.1/content:28)<o:p></o:p></p><p class=MsoNormal>[Fri Jul 29 08:03:16 2011] [warning]: Couldn't change Type of Template #10: That is already the current value (./etc/upgrade/3.9.1/content:28)<o:p></o:p></p><p class=MsoNormal>[Fri Jul 29 08:03:16 2011] [warning]: Couldn't change Type of Template #11: That is already the current value (./etc/upgrade/3.9.1/content:28)<o:p></o:p></p><p class=MsoNormal>[Fri Jul 29 08:03:16 2011] [warning]: Couldn't change Type of Template #12: That is already the current value (./etc/upgrade/3.9.1/content:28)<o:p></o:p></p><p class=MsoNormal>[Fri Jul 29 08:03:16 2011] [warning]: Couldn't change Type of Template #13: That is already the current value (./etc/upgrade/3.9.1/content:28)<o:p></o:p></p><p class=MsoNormal>[Fri Jul 29 08:03:16 2011] [warning]: Couldn't change Type of Template #14: That is already the current value (./etc/upgrade/3.9.1/content:28)<o:p></o:p></p><p class=MsoNormal>[Fri Jul 29 08:03:16 2011] [warning]: Couldn't change Type of Template #15: That is already the current value (./etc/upgrade/3.9.1/content:28)<o:p></o:p></p><p class=MsoNormal>[Fri Jul 29 08:03:16 2011] [warning]: Couldn't change Type of Template #16: That is already the current value (./etc/upgrade/3.9.1/content:28)<o:p></o:p></p><p class=MsoNormal>[Fri Jul 29 08:03:16 2011] [warning]: Couldn't change Type of Template #17: That is already the current value (./etc/upgrade/3.9.1/content:28)<o:p></o:p></p><p class=MsoNormal>[Fri Jul 29 08:03:16 2011] [warning]: Couldn't change Type of Template #18: That is already the current value (./etc/upgrade/3.9.1/content:28)<o:p></o:p></p><p class=MsoNormal>[Fri Jul 29 08:03:16 2011] [warning]: Couldn't change Type of Template #19: That is already the current value (./etc/upgrade/3.9.1/content:28)<o:p></o:p></p><p class=MsoNormal>[Fri Jul 29 08:03:16 2011] [warning]: Couldn't change Type of Template #20: That is already the current value (./etc/upgrade/3.9.1/content:28)<o:p></o:p></p><p class=MsoNormal>[Fri Jul 29 08:03:16 2011] [warning]: Couldn't change Type of Template #21: That is already the current value (./etc/upgrade/3.9.1/content:28)<o:p></o:p></p><p class=MsoNormal>[Fri Jul 29 08:03:16 2011] [warning]: Couldn't change Type of Template #22: That is already the current value (./etc/upgrade/3.9.1/content:28)<o:p></o:p></p><p class=MsoNormal>Processing 3.9.2<o:p></o:p></p><p class=MsoNormal>Now inserting data.<o:p></o:p></p><p class=MsoNormal>[Fri Jul 29 08:03:19 2011] [warning]: DBD::mysql::st execute failed: Unknown column 'main.DelegatedBy' in 'where clause' at /usr/local/share/perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 509, <> line 1. (/usr/local/share/perl/5.8.8/DBIx/SearchBuilder/Handle.pm:509)<o:p></o:p></p><p class=MsoNormal>[Fri Jul 29 08:03:19 2011] [warning]: RT::Handle=HASH(0xa706830) couldn't execute the query 'SELECT main.* FROM ACL main WHERE (main.DelegatedBy > '0') AND (main.DelegatedFrom > '0') ' at /usr/local/share/perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 522<o:p></o:p></p><p class=MsoNormal> DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xa706830)', 'SELECT main.* FROM ACL main WHERE (main.DelegatedBy > \'0\')...') called at /usr/local/share/perl/5.8.8/DBIx/SearchBuilder.pm line 235<o:p></o:p></p><p class=MsoNormal> DBIx::SearchBuilder::_DoSearch('RT::ACL=HASH(0xae93978)') called at /opt/rt4/sbin/../lib/RT/SearchBuilder.pm line 320<o:p></o:p></p><p class=MsoNormal> RT::SearchBuilder::_DoSearch('RT::ACL=HASH(0xae93978)') called at /opt/rt4/sbin/../lib/RT/ACL.pm line 260<o:p></o:p></p><p class=MsoNormal> RT::ACL::_DoSearch('RT::ACL=HASH(0xae93978)') called at /usr/local/share/perl/5.8.8/DBIx/SearchBuilder.pm line 503<o:p></o:p></p><p class=MsoNormal> DBIx::SearchBuilder::Next('RT::ACL=HASH(0xae93978)') called at /opt/rt4/sbin/../lib/RT/ACL.pm line 225<o:p></o:p></p><p class=MsoNormal> RT::ACL::Next('RT::ACL=HASH(0xae93978)') called at ./etc/upgrade/3.9.2/content line 19<o:p></o:p></p><p class=MsoNormal> RT::Handle::__ANON__() called at /opt/rt4/sbin/../lib/RT/Handle.pm line 767<o:p></o:p></p><p class=MsoNormal> eval {...} called at /opt/rt4/sbin/../lib/RT/Handle.pm line 767<o:p></o:p></p><p class=MsoNormal> RT::Handle::InsertData('RT::Handle=HASH(0xa706830)', './etc/upgrade/3.9.2/content', 'undef') called at /opt/rt4/sbin/rt-setup-database line 292<o:p></o:p></p><p class=MsoNormal> main::action_insert('prompt-for-dba-password', 1, 'datafile', 'undef', 'action', 'upgrade', 'datadir', './etc/upgrade/3.9.2', 'backcompat', ...) called at /opt/rt4/sbin/rt-setup-database line 398<o:p></o:p></p><p class=MsoNormal> main::action_upgrade('prompt-for-dba-password', 1, 'action', 'upgrade', 'dba', 'root') called at /opt/rt4/sbin/rt-setup-database line 197 (/usr/share/perl/5.8/Carp.pm:105)<o:p></o:p></p><p class=MsoNormal>[Fri Jul 29 08:03:19 2011] [crit]: _DoSearch is not so successful as it still needs redo search, won't call _BuildHash (/opt/rt4/sbin/../lib/RT/ACL.pm:263)<o:p></o:p></p><p class=MsoNormal>Processing 3.9.3<o:p></o:p></p><p class=MsoNormal>Now populating database schema.<o:p></o:p></p><p class=MsoNormal>[Fri Jul 29 08:03:19 2011] [crit]: DBD::mysql::st execute failed: Can't DROP 'DelegatedBy'; check that column/key exists at /opt/rt4/sbin/../lib/RT/Handle.pm line 517. (/opt/rt4/sbin/../lib/RT.pm:340)<o:p></o:p></p><p class=MsoNormal>DBD::mysql::st execute failed: Can't DROP 'DelegatedBy'; check that column/key exists at /opt/rt4/sbin/../lib/RT/Handle.pm line 517.Jul 29 08:04:10 2011] [warning]: Couldn't change Type of Template #15: That is already the current value (./etc/upgrade/3.9.1/content:28)<o:p></o:p></p><p class=MsoNormal>[Fri Jul 29 08:04:10 2011] [warning]: Couldn't change Type of Template #16: That is already the current value (./etc/upgrade/3.9.1/content:28)<o:p></o:p></p><p class=MsoNormal>[Fri Jul 29 08:04:10 2011] [warning]: Couldn't change Type of Template #17: That is already the current value (./etc/upgrade/3.9.1/content:28)<o:p></o:p></p><p class=MsoNormal>[Fri Jul 29 08:04:10 2011] [warning]: Couldn't change Type of Template #18: That is already the current value (./etc/upgrade/3.9.1/content:28)<o:p></o:p></p><p class=MsoNormal>[Fri Jul 29 08:04:10 2011] [warning]: Couldn't change Type of Template #19: That is already the current value (./etc/upgrade/3.9.1/content:28)<o:p></o:p></p><p class=MsoNormal>[Fri Jul 29 08:04:10 2011] [warning]: Couldn't change Type of Template #20: That is already the current value (./etc/upgrade/3.9.1/content:28)<o:p></o:p></p><p class=MsoNormal>[Fri Jul 29 08:04:10 2011] [warning]: Couldn't change Type of Template #21: That is already the current value (./etc/upgrade/3.9.1/content:28)<o:p></o:p></p><p class=MsoNormal>[Fri Jul 29 08:04:10 2011] [warning]: Couldn't change Type of Template #22: That is already the current value (./etc/upgrade/3.9.1/content:28)<o:p></o:p></p><p class=MsoNormal>Processing 3.9.2<o:p></o:p></p><p class=MsoNormal>Now inserting data.<o:p></o:p></p><p class=MsoNormal>[Fri Jul 29 08:04:13 2011] [warning]: DBD::mysql::st execute failed: Unknown column 'main.DelegatedBy' in 'where clause' at /usr/local/share/perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 509, <> line 1. (/usr/local/share/perl/5.8.8/DBIx/SearchBuilder/Handle.pm:509)<o:p></o:p></p><p class=MsoNormal>[Fri Jul 29 08:04:13 2011] [warning]: RT::Handle=HASH(0xa706830) couldn't execute the query 'SELECT main.* FROM ACL main WHERE (main.DelegatedBy > '0') AND (main.DelegatedFrom > '0') ' at /usr/local/share/perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 522<o:p></o:p></p><p class=MsoNormal> DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xa706830)', 'SELECT main.* FROM ACL main WHERE (main.DelegatedBy > \'0\')...') called at /usr/local/share/perl/5.8.8/DBIx/SearchBuilder.pm line 235<o:p></o:p></p><p class=MsoNormal> DBIx::SearchBuilder::_DoSearch('RT::ACL=HASH(0xae93978)') called at /opt/rt4/sbin/../lib/RT/SearchBuilder.pm line 320<o:p></o:p></p><p class=MsoNormal> RT::SearchBuilder::_DoSearch('RT::ACL=HASH(0xae93978)') called at /opt/rt4/sbin/../lib/RT/ACL.pm line 260<o:p></o:p></p><p class=MsoNormal> RT::ACL::_DoSearch('RT::ACL=HASH(0xae93978)') called at /usr/local/share/perl/5.8.8/DBIx/SearchBuilder.pm line 503<o:p></o:p></p><p class=MsoNormal> DBIx::SearchBuilder::Next('RT::ACL=HASH(0xae93978)') called at /opt/rt4/sbin/../lib/RT/ACL.pm line 225<o:p></o:p></p><p class=MsoNormal> RT::ACL::Next('RT::ACL=HASH(0xae93978)') called at ./etc/upgrade/3.9.2/content line 19<o:p></o:p></p><p class=MsoNormal> RT::Handle::__ANON__() called at /opt/rt4/sbin/../lib/RT/Handle.pm line 767<o:p></o:p></p><p class=MsoNormal> eval {...} called at /opt/rt4/sbin/../lib/RT/Handle.pm line 767<o:p></o:p></p><p class=MsoNormal> RT::Handle::InsertData('RT::Handle=HASH(0xa706830)', './etc/upgrade/3.9.2/content', 'undef') called at /opt/rt4/sbin/rt-setup-database line 292<o:p></o:p></p><p class=MsoNormal> main::action_insert('prompt-for-dba-password', 1, 'datafile', 'undef', 'action', 'upgrade', 'datadir', './etc/upgrade/3.9.2', 'backcompat', ...) called at /opt/rt4/sbin/rt-setup-database line 398<o:p></o:p></p><p class=MsoNormal> main::action_upgrade('prompt-for-dba-password', 1, 'action', 'upgrade', 'dba', 'root') called at /opt/rt4/sbin/rt-setup-database line 197 (/usr/share/perl/5.8/Carp.pm:105)<o:p></o:p></p><p class=MsoNormal>[Fri Jul 29 08:04:13 2011] [crit]: _DoSearch is not so successful as it still needs redo search, won't call _BuildHash (/opt/rt4/sbin/../lib/RT/ACL.pm:263)<o:p></o:p></p><p class=MsoNormal>Processing 3.9.3<o:p></o:p></p><p class=MsoNormal>Now populating database schema.<o:p></o:p></p><p class=MsoNormal>[Fri Jul 29 08:04:13 2011] [crit]: DBD::mysql::st execute failed: Can't DROP 'DelegatedBy'; check that column/key exists at /opt/rt4/sbin/../lib/RT/Handle.pm line 517. (/opt/rt4/sbin/../lib/RT.pm:340)<o:p></o:p></p><p class=MsoNormal>DBD::mysql::st execute failed: Can't DROP 'DelegatedBy'; check that column/key exists at /opt/rt4/sbin/../lib/RT/Handle.pm line 517.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>