Upgrade problems (seems to be between 4.0.18 and 4.1.0)

I am in the process of doing a long-needed upgrade, but have hit
a stumbling block. Any help would be appreciated!

/usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib sbin/rt-setup-database
–action upgrade --prompt-for-dba-password
In order to create or update your RT database, this script needs to connect to
your mysql instance on localhost (port ‘’) as root
Please specify that user’s database password below. If the user has no database
password, just press return.

Password: Working with:
Type: mysql
Host: localhost
Port:
Name: rt3
User: root
DBA: root
Enter RT version you’re upgrading from: 3.8.7

Going to apply following upgrades:

  • 3.8.8
  • 3.8.9
  • 3.9.1
  • 3.9.2
  • 3.9.3
  • 3.9.5
  • 3.9.6
  • 3.9.7
  • 3.9.8
  • 4.0.0rc2
  • 4.0.0rc4
  • 4.0.0rc7
  • 4.0.1
  • 4.0.3
  • 4.0.4
  • 4.0.6
  • 4.0.9
  • 4.0.12
  • 4.0.13
  • 4.0.18
  • 4.1.0
  • 4.1.1
  • 4.1.4
  • 4.1.5
  • 4.1.6
  • 4.1.7
  • 4.1.8
  • 4.1.9
  • 4.1.10
  • 4.1.11
  • 4.1.12
  • 4.1.13
  • 4.1.14
  • 4.1.15
  • 4.1.16
  • 4.1.17
  • 4.1.18
  • 4.1.19
  • 4.1.20
  • 4.1.21
  • 4.1.22
  • 4.1.23
  • 4.2.1

Enter RT version if you want to stop upgrade at some point,
or leave it blank if you want apply above upgrades:

IT’S VERY IMPORTANT TO BACK UP BEFORE THIS STEP
Proceed [y/N]:y
Processing 3.8.8
Now inserting data.
Processing 3.8.9
Now inserting data.
[7072] [Thu Dec 19 21:15:26 2013] [warning]: Use of uninitialized value in
string eq at /local/linroot/rt-4.2.1/sbin/…/lib/RT/Template.pm line 750, <>
line 4. (/local/linroot/rt-4.2.1/sbin/…/lib/RT/Template.pm:750)
[7072] [Thu Dec 19 21:15:26 2013] [warning]: Use of uninitialized value in
string eq at /local/linroot/rt-4.2.1/sbin/…/lib/RT/Template.pm line 750, <>
line 4. (/local/linroot/rt-4.2.1/sbin/…/lib/RT/Template.pm:750)
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.
Processing 3.9.8
Now populating database schema.
Now inserting data.
Processing 4.0.0rc2
Now populating database schema.
Processing 4.0.0rc4
Now populating database schema.
Processing 4.0.0rc7
Now inserting data.
Processing 4.0.1
Now inserting data.
[7072] [Thu Dec 19 21:15:44 2013] [error]: Invalid right. Couldn’t canonicalize
right ‘DelegateRights’ (/local/linroot/rt-4.2.1/sbin/…/lib/RT/ACE.pm:456)
[7072] [Thu Dec 19 21:15:44 2013] [error]: Invalid right. Couldn’t canonicalize
right ‘DelegateRights’ (/local/linroot/rt-4.2.1/sbin/…/lib/RT/ACE.pm:456)
[7072] [Thu Dec 19 21:15:44 2013] [error]: Invalid right. Couldn’t canonicalize
right ‘DelegateRights’ (/local/linroot/rt-4.2.1/sbin/…/lib/RT/ACE.pm:456)
Processing 4.0.3
Now inserting data.
Processing 4.0.4
Now inserting data.
Processing 4.0.6
Now populating database schema.
Now inserting data.
Processing 4.0.9
Now inserting data.
Processing 4.0.12
Now populating database schema.
Processing 4.0.13
Now populating database schema.
Processing 4.0.18
Now inserting data.
Processing 4.1.0
Now inserting data.
Couldn’t finish ‘upgrade’ step.

ERROR: One of initial functions failed: Can’t call method “Content” on an
undefined value at ./etc/upgrade/4.1.0/content line 35, <> line 18.

make: *** [upgrade-database] Error 255

James Craig

James Craig, Department of Computer Science, RIT
102 Lomb Memorial Drive, Rochester, NY 14623
mailto:jmc@cs.rit.edu, voice: (585) 475-5254

CONFIDENTIALITY NOTE: The information transmitted, including attachments, is
intended only for the person(s) or entity to which it is addressed and may
contain confidential and/or privileged material. Any review, retransmission,
dissemination or other use of, or taking of any action in reliance upon this
information by persons or entities other than the intended recipient is
prohibited. If you received this in error, please contact the sender and
destroy any copies of this information.

I am in the process of doing a long-needed upgrade, but have hit
a stumbling block. Any help would be appreciated!
Processing 4.1.0
Now inserting data.
Couldn’t finish ‘upgrade’ step.

ERROR: One of initial functions failed: Can’t call method “Content” on an
undefined value at ./etc/upgrade/4.1.0/content line 35, <> line 18.

This implies you don’t have a default homepage setting.
I’m not sure how the front page of your RT works without it
(presumably all of your privileged users have a customized one, but
you must have errors when adding new privileged users who log in for
the first time).

Examine the results of
select id, Name, Description, Creator from Attributes where Name like ‘%HomepageSettings%’;

using sbin/rt-attributes-viewer as needed to peek inside those that
exist.

The upgrade script expects that one exists at the system, not user
level, it would look like this:

6 | HomepageSettings | HomepageSettings | 1

-kevin

I am in the process of doing a long-needed upgrade, but have hit
a stumbling block. Any help would be appreciated!
Processing 4.1.0
Now inserting data.
Couldn’t finish ‘upgrade’ step.

ERROR: One of initial functions failed: Can’t call method “Content” on an
undefined value at ./etc/upgrade/4.1.0/content line 35, <> line 18.

This implies you don’t have a default homepage setting.
I’m not sure how the front page of your RT works without it
(presumably all of your privileged users have a customized one, but
you must have errors when adding new privileged users who log in for
the first time).

With our very old version, we didn't have any errors of any sort that
I saw or was aware of.
(the hardware we were running died, and so we opted to
 do an upgrade of hardware and software, hoping to import a
 cold file of the database)

I was hoping that getting it to upgrade from our version would put
stuff that was missing into place.

Examine the results of
select id, Name, Description, Creator from Attributes where Name like ‘%HomepageSettings%’;

using sbin/rt-attributes-viewer as needed to peek inside those that
exist.

The upgrade script expects that one exists at the system, not user
level, it would look like this:

6 | HomepageSettings | HomepageSettings | 1

I will admit that I do very little database stuff; It'll take me a
bit of time to figure this out.

Thank you for the quick response!

James Craig

James Craig, Department of Computer Science, RIT
102 Lomb Memorial Drive, Rochester, NY 14623
mailto:jmc@cs.rit.edu, voice: (585) 475-5254

CONFIDENTIALITY NOTE: The information transmitted, including attachments, is
intended only for the person(s) or entity to which it is addressed and may
contain confidential and/or privileged material. Any review, retransmission,
dissemination or other use of, or taking of any action in reliance upon this
information by persons or entities other than the intended recipient is
prohibited. If you received this in error, please contact the sender and
destroy any copies of this information.

    Just to follow up,

    it turns out the documentation I had was wrong; the old version was
    3.4.2

    your comment about the HomepageSettings made me question the notes I

was working from.

Once I started the upgrade from 3.4.2 instead of 3.8.7,
the make upgrade-database completed.

Glad to hear it was something that simple.

-kevin