[rt-users] problems upgrading to 4.0.0 from 3.8.10

[Daniel De Marco]

Hi,

I just tried updating to 4.0.0 from 3.8.10 and when I go to update the
DB I get the following error message. Any ideas?
(I didn't have any RTFM installed)

Thank you, Daniel.




Processing 3.9.1
Now inserting data.
Processing 3.9.2
Now inserting data.
Processing 3.9.3
Now populating database schema.
Processing 3.9.5
Now populating database schema.
Processing 3.9.6
Now populating database schema.
Processing 3.9.7
Now populating database schema.
Now inserting data.
[Fri Apr 29 13:05:31 2011] [warning]: DBD::Pg::st execute failed: ERROR:  column "basedon" is of type integer but expression is of type text
HINT:  You will need to rewrite or cast the expression. at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 509. (/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:509)
[Fri Apr 29 13:05:31 2011] [warning]: RT::Handle=HASH(0xba39200) couldn't execute the query 'UPDATE CustomFields SET BasedOn = (SELECT Content FROM Attributes WHERE Name = ? AND ObjectType = ? AND CustomFields.id = Attributes.ObjectId)' at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 522
        DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xba39200)', 'UPDATE CustomFields SET BasedOn = (SELECT Content FROM Attrib...', 'BasedOn', 'RT::CustomField') called at ./etc/upgrade/3.9.7/content line 15
        RT::Handle::__ANON__('CustomFields', 'RT::CustomField', 'BasedOn') called at ./etc/upgrade/3.9.7/content line 35
        RT::Handle::__ANON__() called at /opt/rt4/sbin/../lib/RT/Handle.pm line 753
        eval {...} called at /opt/rt4/sbin/../lib/RT/Handle.pm line 753
        RT::Handle::InsertData('RT::Handle=HASH(0xba39200)', './etc/upgrade/3.9.7/content', 'undef') called at /opt/rt4/sbin/rt-setup-database line 285
        main::action_insert('prompt-for-dba-password', 1, 'datafile', 'undef', 'action', 'upgrade', 'datadir', './etc/upgrade/3.9.7', 'backcompat', ...) called at /opt/rt4/sbin/rt-setup-database line 387
        main::action_upgrade('prompt-for-dba-password', 1, 'action', 'upgrade', 'dba', 'postgres') called at /opt/rt4/sbin/rt-setup-database line 190 (/usr/lib/perl5/5.8.8/Carp.pm:272)
[Fri Apr 29 13:05:31 2011] [error]: Failed to move BasedOn on RT::CustomField from Attributes into CustomFields table (./etc/upgrade/3.9.7/content:17)
Processing 3.9.8
Now populating database schema.
Now inserting data.
[Fri Apr 29 13:05:36 2011] [error]: You appear to be upgrading from RTFM 2.0 - We don't support upgrading this old of an RTFM yet (./etc/upgrade/3.9.8/content:12)
[Fri Apr 29 13:05:36 2011] [error]: We found RTFM tables in your database.  Checking for content. (./etc/upgrade/3.9.8/content:15)
[Fri Apr 29 13:05:36 2011] [warning]: DBD::Pg::db selectall_arrayref failed: ERROR:  relation "fm_articles" does not exist at ./etc/upgrade/3.9.8/content line 17. (./etc/upgrade/3.9.8/content:17)
Processing 4.0.0rc2
Processing 4.0.0rc4
Now populating database schema.
Processing 4.0.0rc7
Now inserting data.
Done.