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.