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 <[email protected]> [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. >
