Problems upgrading to 4.0.0 from 3.8.10

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.

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.

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.

What version of Postgres are you running?

postgresql-server-8.1.23-1.el5_6.1

Thanks, Daniel.

Hello,

We’ve reproduced this problem with BasedOn column. Patch is ready,
however still need some testing. Failure is not critical. People
either would have to manually set BasedOn for custom fields or patch
and re-apply an upgrade step.On Fri, Apr 29, 2011 at 5:41 PM, Daniel De Marco ddm@bartol.udel.edu wrote:

postgresql-server-8.1.23-1.el5_6.1

Thanks, Daniel.

On Fri 29.Apr’11 at 9:29:34 -0400, Daniel De Marco wrote:

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.

What version of Postgres are you running?

Best regards, Ruslan.

Great! I’ll wait for the patch then. Meanwhile I’m continuing to run
3.8.10 on the old DB…

Thank you for the very fast turnaround.
Daniel.

Dnia 2011-04-29, pią o godzinie 20:49 +0400, Ruslan Zakirov pisze:

Hello,

We’ve reproduced this problem with BasedOn column. Patch is ready,
however still need some testing. Failure is not critical. People
either would have to manually set BasedOn for custom fields or patch
and re-apply an upgrade step.

Hi, is there any chance the patch will be released some time soon?
I’ve run into the same problem.

Robert Wysocki
CONTIUM S.A., http://www.contium.pl

Dnia 2011-04-29, pią o godzinie 20:49 +0400, Ruslan Zakirov pisze:

Hello,

We’ve reproduced this problem with BasedOn column. Patch is ready,
however still need some testing. Failure is not critical. People
either would have to manually set BasedOn for custom fields or patch
and re-apply an upgrade step.

Hi, is there any chance the patch will be released some time soon?
I’ve run into the same problem.

It will be released as 4.0.1rc1 with other important fixes. You can
extract fix from github, test and report back:


Robert Wysocki
CONTIUM S.A., http://www.contium.pl

Best regards, Ruslan.