[rt-users] problems upgrading to 4.0.0 from 3.8.10

[Daniel De Marco]

I forgot to mention: I'm using postgres and the db is the default rt4. I
dumped the old rt3 and reimported it as rt4.

Thanks, Daniel.

* Daniel De Marco <ddm at bartol.udel.edu> [04/29/2011 09:09]:
> 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.
>