Upgrade problem... 3.2 > 3.4

RT Users
1

I’m trying to upgrade my 3.2 > 3.4 of RT. All was going well till I tried
to run some of those database scripts. I took a peak at the files, and i
understand that it can’t find something, but i’m not sure what "/content"
is. A little direction would be most appreciated.

[root@localhost rt-3.4.0]# /opt/rt3/sbin/rt-setup-database --action insert \
–datadir etc/upgrade/3.3.11
Use of uninitialized value in concatenation (.) or string at
/opt/rt3/sbin/rt-setup-database line 155.
[Wed Feb 9 15:54:21 2005] [crit]: Can’t locate /content in @INC (@INC
contains: /opt/rt3/lib /opt/rt3/lib/ /usr/local/lib/perl5/5.8.5/i686-linux
/usr/local/lib/perl5/5.8.5 /usr/local/lib/perl5/site_perl/5.8.5/i686-linux
/usr/local/lib/perl5/site_perl/5.8.5 /usr/local/lib/perl5/site_perl .) at
/opt/rt3/sbin/rt-setup-database line 451.
(/opt/rt3/lib/RT.pm:285)

  • Mat W.
2

did you run the upgrade to 3.30 first? If not you need to upgrade to
3.30 and then 3.3.11.On Wed, 2005-02-09 at 11:53 -0500, Mathew Walker wrote:

I’m trying to upgrade my 3.2 > 3.4 of RT. All was going well till I tried
to run some of those database scripts. I took a peak at the files, and i
understand that it can’t find something, but i’m not sure what “/content”
is. A little direction would be most appreciated.

[root@localhost rt-3.4.0]# /opt/rt3/sbin/rt-setup-database --action insert \
–datadir etc/upgrade/3.3.11
Use of uninitialized value in concatenation (.) or string at
/opt/rt3/sbin/rt-setup-database line 155.
[Wed Feb 9 15:54:21 2005] [crit]: Can’t locate /content in @INC (@INC
contains: /opt/rt3/lib /opt/rt3/lib/ /usr/local/lib/perl5/5.8.5/i686-linux
/usr/local/lib/perl5/5.8.5 /usr/local/lib/perl5/site_perl/5.8.5/i686-linux
/usr/local/lib/perl5/site_perl/5.8.5 /usr/local/lib/perl5/site_perl .) at
/opt/rt3/sbin/rt-setup-database line 451.
(/opt/rt3/lib/RT.pm:285)

  • Mat W.

The rt-users Archives

RT Administrator and Developer training is coming to your town soon! (Boston, San Francisco, Austin, Sydney) Contact training@bestpractical.com for details.

Be sure to check out the RT Wiki at http://wiki.bestpractical.com
Scott T. Hildreth shildret@scotth.emsphone.com

3

i get the exact same error w/ the 3.3.0 and the 3.3.11 … i just don’t know
what/where “/content” is?

4

Did you run schema & acl update first?On Wed, 2005-02-09 at 13:51 -0500, Mathew Walker wrote:

i get the exact same error w/ the 3.3.0 and the 3.3.11 … i just don’t know
what/where “/content” is?

did you run the upgrade to 3.30 first? If not you need to upgrade to
3.30 and then 3.3.11.

On Wed, 2005-02-09 at 11:53 -0500, Mathew Walker wrote:

I’m trying to upgrade my 3.2 > 3.4 of RT. All was going well till I
tried
to run some of those database scripts. I took a peak at the files, and
i
understand that it can’t find something, but i’m not sure what
“/content”
is. A little direction would be most appreciated.

[root@localhost rt-3.4.0]# /opt/rt3/sbin/rt-setup-database --action
insert
–datadir etc/upgrade/3.3.11
Use of uninitialized value in concatenation (.) or string at
/opt/rt3/sbin/rt-setup-database line 155.
[Wed Feb 9 15:54:21 2005] [crit]: Can’t locate /content in @INC (@INC
contains: /opt/rt3/lib /opt/rt3/lib/
/usr/local/lib/perl5/5.8.5/i686-linux
/usr/local/lib/perl5/5.8.5
/usr/local/lib/perl5/site_perl/5.8.5/i686-linux
/usr/local/lib/perl5/site_perl/5.8.5 /usr/local/lib/perl5/site_perl .)
at
/opt/rt3/sbin/rt-setup-database line 451.
(/opt/rt3/lib/RT.pm:285)

  • Mat W.

The rt-users Archives

RT Administrator and Developer training is coming to your town soon!
(Boston, San Francisco, Austin, Sydney) Contact training@bestpractical.com
for details.

Be sure to check out the RT Wiki at http://wiki.bestpractical.com
–
Scott T. Hildreth shildret@scotth.emsphone.com

Scott T. Hildreth shildreth@allantgroup.com

5

It helps if I read your email =8^). It is saying it can’t find the
content file, which is in the dist dir etc/upgrade/, but you
can ignore that, the content files are empty for the 3.3.* upgrades.On Wed, 2005-02-09 at 13:21 -0600, Scott T. Hildreth wrote:

Did you run schema & acl update first?

On Wed, 2005-02-09 at 13:51 -0500, Mathew Walker wrote:

i get the exact same error w/ the 3.3.0 and the 3.3.11 … i just don’t know
what/where “/content” is?

did you run the upgrade to 3.30 first? If not you need to upgrade to
3.30 and then 3.3.11.

On Wed, 2005-02-09 at 11:53 -0500, Mathew Walker wrote:

I’m trying to upgrade my 3.2 > 3.4 of RT. All was going well till I
tried
to run some of those database scripts. I took a peak at the files, and
i
understand that it can’t find something, but i’m not sure what
“/content”
is. A little direction would be most appreciated.

[root@localhost rt-3.4.0]# /opt/rt3/sbin/rt-setup-database --action
insert
–datadir etc/upgrade/3.3.11
Use of uninitialized value in concatenation (.) or string at
/opt/rt3/sbin/rt-setup-database line 155.
[Wed Feb 9 15:54:21 2005] [crit]: Can’t locate /content in @INC (@INC
contains: /opt/rt3/lib /opt/rt3/lib/
/usr/local/lib/perl5/5.8.5/i686-linux
/usr/local/lib/perl5/5.8.5
/usr/local/lib/perl5/site_perl/5.8.5/i686-linux
/usr/local/lib/perl5/site_perl/5.8.5 /usr/local/lib/perl5/site_perl .)
at
/opt/rt3/sbin/rt-setup-database line 451.
(/opt/rt3/lib/RT.pm:285)

  • Mat W.

The rt-users Archives

RT Administrator and Developer training is coming to your town soon!
(Boston, San Francisco, Austin, Sydney) Contact training@bestpractical.com
for details.

Be sure to check out the RT Wiki at http://wiki.bestpractical.com
–
Scott T. Hildreth shildret@scotth.emsphone.com

Scott T. Hildreth shildret@scotth.emsphone.com

6

I think I got my RT upgraded. But now when i look at RT or RTFM items, i
see no history at all. Everything else seems to have been maintained, but
no more ticket history. Any ideas where to start?

7

I think I got my RT upgraded. But now when i look at RT or RTFM items, i
see no history at all. Everything else seems to have been maintained, but
no more ticket history. Any ideas where to start?

I had to remove the following lines from etc/upgrade/3.3.0/schema.Pg:

drop index ticketcustomfieldvalues1;
drop index ticketcustomfieldvalues2;

Then ran the updates again. That fixed it for me. I was upgrading from
3.0.5 to 3.4.0 on Postgresql.

Les

The rt-users Archives

RT Administrator and Developer training is coming to your town soon! (Boston, San Francisco, Austin, Sydney) Contact training@bestpractical.com for details.

Be sure to check out the RT Wiki at http://wiki.bestpractical.com
Les Driggers :: Systems Engineer
ldriggers@fncinc.com

Phone 662/236-2020 x326 :: Fax 662/236-3607
1214 Office Park Drive :: Oxford, MS 38655

FNC Inc.
Change the way you think about collateral™
www.fncinc.com

8

I had to remove the following lines from etc/upgrade/3.3.0/schema.Pg:

drop index ticketcustomfieldvalues1;
drop index ticketcustomfieldvalues2;

Then ran the updates again. That fixed it for me. I was upgrading from
3.0.5 to 3.4.0 on Postgresql.

Do you perhaps mean 3.4.0rc something? Those were (afaik) removed before
3.4.0.

9

I had to remove the following lines from etc/upgrade/3.3.0/schema.Pg:

drop index ticketcustomfieldvalues1;
drop index ticketcustomfieldvalues2;

Then ran the updates again. That fixed it for me. I was upgrading from
3.0.5 to 3.4.0 on Postgresql.

Do you perhaps mean 3.4.0rc something? Those were (afaik) removed before
3.4.0.

Sorry. It was 3.4.0rc6.

Les

Les Driggers :: Systems Engineer
ldriggers@fncinc.com

Phone 662/236-2020 x326 :: Fax 662/236-3607
1214 Office Park Drive :: Oxford, MS 38655

FNC Inc.
Change the way you think about collateral™
www.fncinc.com

10

Not being a DBA or anything… I figure it might be smart to look into my
database to see if the data is even in there. But, what should I query for
to see if the ticket has history and it’s not being displayed or if the
history somehow got dropped.