Problems upgrading RTFM to 2.2.0RC4

I’m using RT 3.6.1 with an unknown version of RTFM installed (though I
think it is probably RTFM 2.1.40 based on the time frame installed) and
am trying to migrate to RTFM 2.2.0RC4. Downloaded the file, read the
README file, didn’t seem to fit the upgrade instructions (not upgrading
from a 2.0.x release), … so tried the normal install instructions
(make Makefile.PL, make install), omitted “make initdb” because it
wasn’t an “initial install”, stopped and started the webserver.

Appears I now have an upgraded version, however all previous RTFM
articles, while they still exist, have no content.

Before I muck it up further would appreciate some advice:

  1. How do you tell what version of RTFM is installed? … I can’t seem
    to find it anywhere?
  2. How can I get my article content back & properly complete the
    upgrade? … should I run the “make initdb” command or will this
    overwrite the existing tables in the database?

Any assistance greatly appreciated …

Bill Davis

I’m using RT 3.6.1 with an unknown version of RTFM installed (though I
think it is probably RTFM 2.1.40 based on the time frame installed) and
am trying to migrate to RTFM 2.2.0RC4. Downloaded the file, read the
README file, didn’t seem to fit the upgrade instructions (not upgrading
from a 2.0.x release), … so tried the normal install instructions
(make Makefile.PL, make install), omitted “make initdb” because it
wasn’t an “initial install”, stopped and started the webserver.

Appears I now have an upgraded version, however all previous RTFM
articles, while they still exist, have no content.

Before I muck it up further would appreciate some advice:

  1. How do you tell what version of RTFM is installed? … I can’t seem
    to find it anywhere?
  2. How can I get my article content back & properly complete the
    upgrade? … should I run the “make initdb” command or will this
    overwrite the existing tables in the database?

Notice that /etc/upgrades has three directories:
2.1.0 2.1.30 2.2.0RC2

You must apply the upgrade from these for each version
later than the one you are upgrading. If you are starting with
2.1.40, then you need apply 2.2.0RC2

But also, the README left out a critical piece.
That is, the upgrade will break the association of
which custom fields go with which classes (which is why
your articles now appear to have no content.) To get it back:

Login the RT web interface->
Config->RTFM->Custom Fields->->Apply-> Select the classes
the customfield will apply to (the common is to select all) and then click Send

bobg

Bob Goldstein wrote:

I’m using RT 3.6.1 with an unknown version of RTFM installed (though I
think it is probably RTFM 2.1.40 based on the time frame installed) and
am trying to migrate to RTFM 2.2.0RC4. Downloaded the file, read the
README file, didn’t seem to fit the upgrade instructions (not upgrading

from a 2.0.x release), … so tried the normal install instructions

(make Makefile.PL, make install), omitted “make initdb” because it
wasn’t an “initial install”, stopped and started the webserver.

Appears I now have an upgraded version, however all previous RTFM
articles, while they still exist, have no content.

Before I muck it up further would appreciate some advice:

  1. How do you tell what version of RTFM is installed? … I can’t seem
    to find it anywhere?
  2. How can I get my article content back & properly complete the
    upgrade? … should I run the “make initdb” command or will this
    overwrite the existing tables in the database?

Notice that /etc/upgrades has three directories:
2.1.0 2.1.30 2.2.0RC2

You must apply the upgrade from these for each version
later than the one you are upgrading. If you are starting with
2.1.40, then you need apply 2.2.0RC2

But also, the README left out a critical piece.
That is, the upgrade will break the association of
which custom fields go with which classes (which is why
your articles now appear to have no content.) To get it back:

Login the RT web interface->
Config->RTFM->Custom Fields->->Apply-> Select the classes
the customfield will apply to (the common is to select all) and then click Send

bobg
Thanks for the reply. Since I’d already run “make Makefile.PL” & “make
install”, picked up the update instructions with (producing the
responses indicated):

[root@BlackHole RTFM-2.2.0RC4]# /opt/rt3/sbin/rt-setup-database
--action schema \ --datadir etc/upgrade/2.2.0RC2 --dba root
--dba-password xxxxxx
Creating database schema.
readline() on closed filehandle SCHEMA_LOCAL at
/opt/rt3/sbin/rt-setup-database line 192.
Problem with statement:

CREATE TABLE Attachments (
  id INTEGER NOT NULL  AUTO_INCREMENT,
  TransactionId integer NOT NULL  ,
  Parent integer NOT NULL DEFAULT 0  ,
  MessageId varchar(160) NULL  ,
  Subject varchar(255) NULL  ,
  Filename varchar(255) NULL  ,
  ContentType varchar(80) NULL  ,
  ContentEncoding varchar(80) NULL  ,
  Content LONGTEXT NULL  ,
  Headers LONGTEXT NULL  ,
  Creator integer NOT NULL DEFAULT 0  ,
  Created DATETIME NULL  ,
  PRIMARY KEY (id)
) TYPE=InnoDB
Table 'Attachments' already exists at
/opt/rt3/sbin/rt-setup-database line 212.
[root@BlackHole RTFM-2.2.0RC4]# /opt/rt3/sbin/rt-setup-database
--action acl \ - -datadir etc/upgrade/2.2.0RC2 --dba root
--dba-password xxxxxx
Done setting up database ACLs.
[root@BlackHole RTFM-2.2.0RC4]# /opt/rt3/sbin/rt-setup-database
--action insert \ --datadir etc/upgrade/2.2.0RC2 --dba root
--dba-password xxxxxx
Use of uninitialized value in concatenation (.) or string at
/opt/rt3/sbin/rt-se tup-database line 162.
[Tue Dec 19 09:25:12 2006] [crit]: Can't locate /content in @INC
(@INC contains:  /opt/rt3/lib /opt/rt3/local/lib
/usr/lib/perl5/site_perl/5.8.8/i386-linux-threa d-multi
/usr/lib/perl5/site_perl/5.8.7/i386-linux-thread-multi
/usr/lib/perl5/si te_perl/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.5/i386-linux- thread-multi
/usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi
/usr/lib/per l5/site_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.8 /usr/l ib/perl5/site_perl/5.8.7
/usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl /5.8.5
/usr/lib/perl5/site_perl/5.8.4 /usr/lib/perl5/site_perl/5.8.3
/usr/lib/pe rl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi /usr/lib/
perl5/vendor_perl/5.8.7/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.6 /i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-mult i
/usr/lib/perl5/vendor_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/vendor _perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/pe rl5/vendor_perl/5.8.7
/usr/lib/perl5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_per l/5.8.5
/usr/lib/perl5/vendor_perl/5.8.4 /usr/lib/perl5/vendor_perl/5.8.3
/usr/l ib/perl5/vendor_perl
/usr/lib/perl5/5.8.8/i386-linux-thread-multi /usr/lib/perl5 /5.8.8
.) at /opt/rt3/sbin/rt-setup-database line 456.
(/opt/rt3/lib/RT.pm:317)
Can't locate /content in @INC (@INC contains: /opt/rt3/lib
/opt/rt3/local/lib /u
sr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5. 8.7/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-mul ti
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/site_pe rl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.3/i386-linux-threa d-multi
/usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl/5.8.7
/usr/lib/p erl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5
/usr/lib/perl5/site_perl/5.8 .4 /usr/lib/perl5/site_perl/5.8.3
/usr/lib/perl5/site_perl /usr/lib/perl5/vendor
_perl/5.8.8/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.7/i386-linux- thread-multi
/usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi
/usr/lib/p erl5/vendor_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.4/ i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi 
/usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl/5.8.7
/usr/lib/perl 5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_perl/5.8.5
/usr/lib/perl5/vendor_perl/ 5.8.4 /usr/lib/perl5/vendor_perl/5.8.3
/usr/lib/perl5/vendor_perl /usr/lib/perl5
/5.8.8/i386-linux-thread-multi /usr/lib/perl5/5.8.8 .) at
/opt/rt3/sbin/rt-setup -database line 456.
[root@BlackHole RTFM-2.2.0RC4]#
This collection of errors messages didn't give me a warm fuzzy
feeling & stopping & restarting the webserver, I'm seeing the same
results:  previous articles listed, but with no contents.  The
configuration for RTFM also seems to have no custom fields listed.

Ideas welcome ...
Bill Davis

I’m stuck, can’t seem to go forward to 2.2.RC4, can’t seem to go back to
where I was, even though I suspect my articles are still in the database
somewhere …

Still hoping somebody (with more knowledge of RTFM & RT than me) can
help …

Bill Davis

Bob Goldstein wrote:

I’m using RT 3.6.1 with an unknown version of RTFM installed (though I
think it is probably RTFM 2.1.40 based on the time frame installed) and
am trying to migrate to RTFM 2.2.0RC4. Downloaded the file, read the
README file, didn’t seem to fit the upgrade instructions (not upgrading

from a 2.0.x release), … so tried the normal install instructions

(make Makefile.PL, make install), omitted “make initdb” because it
wasn’t an “initial install”, stopped and started the webserver.

Appears I now have an upgraded version, however all previous RTFM
articles, while they still exist, have no content.

Before I muck it up further would appreciate some advice:

  1. How do you tell what version of RTFM is installed? … I can’t seem
    to find it anywhere?
  2. How can I get my article content back & properly complete the
    upgrade? … should I run the “make initdb” command or will this
    overwrite the existing tables in the database?

Notice that /etc/upgrades has three directories:
2.1.0 2.1.30 2.2.0RC2

You must apply the upgrade from these for each version
later than the one you are upgrading. If you are starting with
2.1.40, then you need apply 2.2.0RC2

But also, the README left out a critical piece.
That is, the upgrade will break the association of
which custom fields go with which classes (which is why
your articles now appear to have no content.) To get it back:

Login the RT web interface->
Config->RTFM->Custom Fields->->Apply-> Select the classes
the customfield will apply to (the common is to select all) and then click Send

bobg

Thanks for the reply. Since I’d already run “make Makefile.PL” & “make
install”, picked up the update instructions with the following
(producing the responses indicated):

[root@BlackHole RTFM-2.2.0RC4]# /opt/rt3/sbin/rt-setup-database
--action schema \ --datadir etc/upgrade/2.2.0RC2 --dba root
--dba-password xxxxxx
Creating database schema.
readline() on closed filehandle SCHEMA_LOCAL at
/opt/rt3/sbin/rt-setup-database line 192.
Problem with statement:

CREATE TABLE Attachments (
  id INTEGER NOT NULL  AUTO_INCREMENT,
  TransactionId integer NOT NULL  ,
  Parent integer NOT NULL DEFAULT 0  ,
  MessageId varchar(160) NULL  ,
  Subject varchar(255) NULL  ,
  Filename varchar(255) NULL  ,
  ContentType varchar(80) NULL  ,
  ContentEncoding varchar(80) NULL  ,
  Content LONGTEXT NULL  ,
  Headers LONGTEXT NULL  ,
  Creator integer NOT NULL DEFAULT 0  ,
  Created DATETIME NULL  ,
  PRIMARY KEY (id)
) TYPE=InnoDB
Table 'Attachments' already exists at
/opt/rt3/sbin/rt-setup-database line 212.
[root@BlackHole RTFM-2.2.0RC4]# /opt/rt3/sbin/rt-setup-database
--action acl \ - -datadir etc/upgrade/2.2.0RC2 --dba root
--dba-password xxxxxx
Done setting up database ACLs.
[root@BlackHole RTFM-2.2.0RC4]# /opt/rt3/sbin/rt-setup-database
--action insert \ --datadir etc/upgrade/2.2.0RC2 --dba root
--dba-password xxxxxx
Use of uninitialized value in concatenation (.) or string at
/opt/rt3/sbin/rt-se tup-database line 162.
[Tue Dec 19 09:25:12 2006] [crit]: Can't locate /content in @INC
(@INC contains:  /opt/rt3/lib /opt/rt3/local/lib
/usr/lib/perl5/site_perl/5.8.8/i386-linux-threa d-multi
/usr/lib/perl5/site_perl/5.8.7/i386-linux-thread-multi
/usr/lib/perl5/si te_perl/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.5/i386-linux- thread-multi
/usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi
/usr/lib/per l5/site_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.8 /usr/l ib/perl5/site_perl/5.8.7
/usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl /5.8.5
/usr/lib/perl5/site_perl/5.8.4 /usr/lib/perl5/site_perl/5.8.3
/usr/lib/pe rl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi /usr/lib/
perl5/vendor_perl/5.8.7/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.6 /i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-mult i
/usr/lib/perl5/vendor_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/vendor _perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/pe rl5/vendor_perl/5.8.7
/usr/lib/perl5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_per l/5.8.5
/usr/lib/perl5/vendor_perl/5.8.4 /usr/lib/perl5/vendor_perl/5.8.3
/usr/l ib/perl5/vendor_perl
/usr/lib/perl5/5.8.8/i386-linux-thread-multi /usr/lib/perl5 /5.8.8
.) at /opt/rt3/sbin/rt-setup-database line 456.
(/opt/rt3/lib/RT.pm:317)
Can't locate /content in @INC (@INC contains: /opt/rt3/lib
/opt/rt3/local/lib /u
sr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5. 8.7/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-mul ti
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/site_pe rl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.3/i386-linux-threa d-multi
/usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl/5.8.7
/usr/lib/p erl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5
/usr/lib/perl5/site_perl/5.8 .4 /usr/lib/perl5/site_perl/5.8.3
/usr/lib/perl5/site_perl /usr/lib/perl5/vendor
_perl/5.8.8/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.7/i386-linux- thread-multi
/usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi
/usr/lib/p erl5/vendor_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.4/ i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi 
/usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl/5.8.7
/usr/lib/perl 5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_perl/5.8.5
/usr/lib/perl5/vendor_perl/ 5.8.4 /usr/lib/perl5/vendor_perl/5.8.3
/usr/lib/perl5/vendor_perl /usr/lib/perl5
/5.8.8/i386-linux-thread-multi /usr/lib/perl5/5.8.8 .) at
/opt/rt3/sbin/rt-setup -database line 456.
[root@BlackHole RTFM-2.2.0RC4]#
This collection of errors messages didn't give me a warm fuzzy
feeling & stopping & restarting the webserver, I'm seeing the same
results:  previous articles listed, but with no contents.  The
configuration for RTFM also seems to have no custom fields listed.

Ideas welcome ...
Bill Davis

I’m stuck, can’t seem to go forward to 2.2.RC4, can’t seem to go back to
where I was, even though I suspect my articles are still in the database
somewhere …

Still hoping somebody (with more knowledge of RTFM & RT than me) can
help …

Did you try this?

Login the RT web interface->
Config->RTFM->Custom Fields->->Apply-> Select the classes
the customfield will apply to (the common is to select all) and then click S
end

bobg

Thanks Bob …,

Yes I did, … but it has no effect because there are now no custom
fields listed under Config->RTFM->Custom Fields->

… the drop-down list is empty.

Bill Davis

Bob Goldstein wrote:

I'm stuck, can't seem to go forward to 2.2.RC4, can't seem to go back to
where I was, even though I suspect my articles are still in the database
somewhere ...

Still hoping somebody (with more knowledge of RTFM & RT than me) can
help …

</pre></blockquote>
    Did you try this?
  
Login the RT web interface->
Config->RTFM->Custom Fields-><CUSTOM FIELD NAME>->Apply-> Select the classes
the customfield will apply to (the common is to select all) and then click S
      
end
    
    bobg
  

The readme mentions a special post-2.0 upgrade script. Did the output from that look ok?------- Original message -------
From: Bill Davis daviswj@comcast.net
Sent: 12/19, 22:49

Thanks Bob …,

Yes I did, … but it has no effect because there are now no custom fields listed under Config->RTFM->Custom Fields->

… the drop-down list is empty.

Bill Davis

Bob Goldstein wrote:
I’m stuck, can’t seem to go forward to 2.2.RC4, can’t seem to go back to
where I was, even though I suspect my articles are still in the database
somewhere …

Still hoping somebody (with more knowledge of RTFM & RT than me) can
help …

Did you try this?

Login the RT web interface->
Config->RTFM->Custom Fields->->Apply-> Select the classes
the customfield will apply to (the common is to select all) and then click S

end

bobg

After scratching my head a bit trying to figure out what “special
post-2.0 upgrade script”, decided it had to be the 2nd step in the
README’s upgrade procedures:

"Upgrade instructions (From any  2.0.x release):
1) perl Makefile.PL
2) perl -I/path/to/your/rt/lib sbin/migrate-2.0-to-2.1
3) Type "make install"
4) Type "ls etc/upgrade"; For each item in that directory whose name
   is greater than your previously installed RT version, run:

            /opt/rt3/sbin/rt-setup-database --action schema \
                --datadir etc/upgrade/<version>
            /opt/rt3/sbin/rt-setup-database --action acl \
                --datadir etc/upgrade/<version>
            /opt/rt3/sbin/rt-setup-database --action insert \
                 --datadir etc/upgrade/<version>

5) stop and start your web server"

I had omitted that step because my best guess had been that the original
RTFM install was already a 2.1.xx version (still wondering how the user
can tell for sure which RTFM version is currently installed?) & was
unsure if it applied because the upgrade instructions are labeled “(From
any 2.0.x release)”. Decided to retrace my steps and go thru the
upgrade instructions step by step (omitting nothing) including executing
step 4 for 2.1.0, 2.1.30, & 2.2.0RC2.

Step 1 threw up the warning: Warning: prerequisite RT 3.4.2 not found.
We have 3.006001. … ignored.
Step 2 appeared to properly migrate my custom fields & transactions.
Step 4 warned that for each version’s “–action schema” command that
"Table ‘Attachments’ already exists at /opt/rt3/sbin/rt-setup-database
line 212." & for each version’s “–action insert” command that “Use of
uninitialized value in concatenation (.) or string at
/opt/rt3/sbin/rt-setup-database line 162.
[Wed Dec 20 08:53:08 2006] [crit]: Can’t locate /content in @INC …”

At the end of the process followed Bob’s advice and reassociated my RTFM
custom fields (which were now again present) with the appropriate
classes. My articles are now back & I appear to have a fully operable
version 2.2 RTFM. Mega-thanks to both Bob & Jesse for your assistance.

Suggestion: the upgrade instructions could be much clearer as to which
procedures apply to which versions.

Thanks again for both the help & an outstanding piece of software …
Bill Davis

Jesse Vincent wrote:

You can see the RTFM version by going to the configuration tab and
choosing system configuration from the tools menu. On my box this is
http://myrtserver.mydomain/Admin/Tools/Configuration.html.

Loaded perl modules
Perl v5.8.8 under freebsd

RT v3.6.0;
RT::FM v2.2.0RC2;
RT::Interface::Email v1.02;

Regards

JohnFrom: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Bill
Davis
Sent: 20 December 2006 09:50
To: Jesse Vincent
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Problems upgrading RTFM to 2.2.0RC4

After scratching my head a bit trying to figure out what “special
post-2.0 upgrade script”, decided it had to be the 2nd step in the
README’s upgrade procedures:

"Upgrade instructions (From any  2.0.x release):
1) perl Makefile.PL
2) perl -I/path/to/your/rt/lib sbin/migrate-2.0-to-2.1
3) Type "make install"
4) Type "ls etc/upgrade"; For each item in that directory whose name
   is greater than your previously installed RT version, run:

            /opt/rt3/sbin/rt-setup-database --action schema \
                --datadir etc/upgrade/<version>
            /opt/rt3/sbin/rt-setup-database --action acl \
                --datadir etc/upgrade/<version>
            /opt/rt3/sbin/rt-setup-database --action insert \
                 --datadir etc/upgrade/<version>

5) stop and start your web server"

I had omitted that step because my best guess had been that the original

RTFM install was already a 2.1.xx version (still wondering how the user
can tell for sure which RTFM version is currently installed?) & was
unsure if it applied because the upgrade instructions are labeled "(From

any 2.0.x release)". Decided to retrace my steps and go thru the
upgrade instructions step by step (omitting nothing) including executing

step 4 for 2.1.0, 2.1.30, & 2.2.0RC2.

Step 1 threw up the warning: Warning: prerequisite RT 3.4.2 not found.
We have 3.006001. … ignored.
Step 2 appeared to properly migrate my custom fields & transactions.
Step 4 warned that for each version’s “–action schema” command that
“Table ‘Attachments’ already exists at /opt/rt3/sbin/rt-setup-database
line 212.” & for each version’s “–action insert” command that “Use of
uninitialized value in concatenation (.) or string at
/opt/rt3/sbin/rt-setup-database line 162.
[Wed Dec 20 08:53:08 2006] [crit]: Can’t locate /content in @INC …”

At the end of the process followed Bob’s advice and reassociated my RTFM

custom fields (which were now again present) with the appropriate
classes. My articles are now back & I appear to have a fully operable
version 2.2 RTFM. Mega-thanks to both Bob & Jesse for your assistance.

Suggestion: the upgrade instructions could be much clearer as to which
procedures apply to which versions.

Thanks again for both the help & an outstanding piece of software …
Bill Davis

Jesse Vincent wrote:

The readme mentions a special post-2.0 upgrade script. Did the output
from that look ok?

------- Original message -------
From: Bill Davis daviswj@comcast.net
Sent: 12/19, 22:49

Thanks Bob …,

Yes I did, … but it has no effect because there are now no custom
fields listed under Config->RTFM->Custom Fields->

… the drop-down list is empty.

Bill Davis

Bob Goldstein wrote:
I’m stuck, can’t seem to go forward to 2.2.RC4, can’t seem to go back
to
where I was, even though I suspect my articles are still in the
database
somewhere …

Still hoping somebody (with more knowledge of RTFM & RT than me) can
help …

Did you try this?

Login the RT web interface->
Config->RTFM->Custom Fields->->Apply-> Select the
classes
the customfield will apply to (the common is to select all) and then
click S

end

bobg

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Have you received exemplary service from one of our employees? You can nominate them for Spirit06 awards by emailing us at mailto:spirit06@fmgsupport.com

The awards are designed to recognise and celebrate those employees who make a difference to the company by living the FMG Support values as they carry out their role.

We have taken all reasonable precautions to ensure that no viruses are transmitted from FMG Support to any third party. FMG Support accept no responsibility for any damage or loss resulting directly or indirectly from the use of this e-mail or its contents.

This e-mail and any files transmitted with it are confidential and solely for the use of the addressee. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on this e-mail, is prohibited and may be unlawful. Opinions expressed in this e-mail are those of the individual and not those of the Company unless specifically indicated to that effect.

If you have received this e-mail in error please inform us and delete it from your mailbox and/or any other storage mechanism.

FMG Support Ltd T:0870 830 3830 mailto:support@fmgsupport.com.

You can see the RTFM version by going to the configuration tab and
choosing system configuration from the tools menu. On my box this is
http://myrtserver.mydomain/Admin/Tools/Configuration.html.

This works for RTFM 2.2.0RC2.
Not for 2.0.x. I don’t know about 2.1.x

In 2.2, the FM.pm file has a $VERSION defined,
but it’s missing in 2.0

I also had a difficult time upgrading RTFM (in my case, from
RT 3.4.2 / RTFM 2.0) I’d suggest a few small changes in this
procedure before removing the ‘RC’:

 - State clearly in the README that the 'migrate'
   script must be run *before* installing the new RTFM code.
   Yes, this is implied by the order of operations.  But I, for one,
   would have found this warning useful.  (My RT install is customized
   for multiple instances with common code, so I need to coordinate
   the upgrades for all the instances.  It isn't only that I can't read :-)

 - Write the 'migrate' script so that it works for any base RTFM version.
   If it sniffs out a version for which it doesn't need to run, that's fine.
   But this would have saved Bill some grief, particularly since the early
   versions of RTFM didn't have their versions well marked.

 - Note in the README about manually re-associating classes and custom fields.
   I don't know if this is always needed.  But I nearly gave up on RTFM,
   and was lucky enough to see a post helping someone else on this point.
   (Sorry, I've lost the name of the person to thank for that post. But THANK YOU anyway!)



 bobg

That helps …, thanks :slight_smile:

Bill Davis

John Parker wrote:

You can see the RTFM version by going to the configuration tab and
choosing system configuration from the tools menu. On my box this is
http://myrtserver.mydomain/Admin/Tools/Configuration.html.

Loaded perl modules
Perl v5.8.8 under freebsd
<lots of modules>
RT v3.6.0;
RT::FM v2.2.0RC2;
RT::Interface::Email v1.02;

Regards

John-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Bill
Davis
Sent: 20 December 2006 09:50
To: Jesse Vincent
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Problems upgrading RTFM to 2.2.0RC4

After scratching my head a bit trying to figure out what “special
post-2.0 upgrade script”, decided it had to be the 2nd step in the
README’s upgrade procedures:

"Upgrade instructions (From any  2.0.x release):
1) perl Makefile.PL
2) perl -I/path/to/your/rt/lib sbin/migrate-2.0-to-2.1
3) Type "make install"
4) Type "ls etc/upgrade"; For each item in that directory whose name
   is greater than your previously installed RT version, run:

            /opt/rt3/sbin/rt-setup-database --action schema \
                --datadir etc/upgrade/&lt;version&gt;
            /opt/rt3/sbin/rt-setup-database --action acl \
                --datadir etc/upgrade/&lt;version&gt;
            /opt/rt3/sbin/rt-setup-database --action insert \
                 --datadir etc/upgrade/&lt;version&gt;

5) stop and start your web server"

I had omitted that step because my best guess had been that the original

RTFM install was already a 2.1.xx version (still wondering how the user
can tell for sure which RTFM version is currently installed?) & was
unsure if it applied because the upgrade instructions are labeled "(From

any 2.0.x release)". Decided to retrace my steps and go thru the
upgrade instructions step by step (omitting nothing) including executing

step 4 for 2.1.0, 2.1.30, & 2.2.0RC2.

Step 1 threw up the warning: Warning: prerequisite RT 3.4.2 not found.
We have 3.006001. … ignored.
Step 2 appeared to properly migrate my custom fields & transactions.
Step 4 warned that for each version’s “–action schema” command that
“Table ‘Attachments’ already exists at /opt/rt3/sbin/rt-setup-database
line 212.” & for each version’s “–action insert” command that “Use of
uninitialized value in concatenation (.) or string at
/opt/rt3/sbin/rt-setup-database line 162.
[Wed Dec 20 08:53:08 2006] [crit]: Can’t locate /content in @INC …”

At the end of the process followed Bob’s advice and reassociated my RTFM

custom fields (which were now again present) with the appropriate
classes. My articles are now back & I appear to have a fully operable
version 2.2 RTFM. Mega-thanks to both Bob & Jesse for your assistance.

Suggestion: the upgrade instructions could be much clearer as to which
procedures apply to which versions.

Thanks again for both the help & an outstanding piece of software …
Bill Davis

Jesse Vincent wrote:

The readme mentions a special post-2.0 upgrade script. Did the output
    
from that look ok?
  
------- Original message -------
From: Bill Davis <daviswj@comcast.net>
Sent: 12/19,  22:49
</pre>
Thanks Bob ....,

Yes I did, … but it has no effect because there are now no custom

fields listed under Config->RTFM->Custom Fields->
  
... the drop-down list is empty.

Bill Davis

Bob Goldstein wrote:
I’m stuck, can’t seem to go forward to 2.2.RC4, can’t seem to go back

to
  
where I was, even though I suspect my articles are still in the
      
database
  
somewhere ...

Still hoping somebody (with more knowledge of RTFM & RT than me) can
help …

Did you try this?

Login the RT web interface->
Config->RTFM->Custom Fields-><CUSTOM FIELD NAME>->Apply-> Select the

classes
  
the customfield will apply to (the common is to select all) and then
      
click S
  
      

end

bobg




  </pre></blockquote>

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Have you received exemplary service from one of our employees? You can nominate them for Spirit06 awards by emailing us at mailto:spirit06@fmgsupport.com

The awards are designed to recognise and celebrate those employees who make a difference to the company by living the FMG Support values as they carry out their role.

We have taken all reasonable precautions to ensure that no viruses are transmitted from FMG Support to any third party. FMG Support accept no responsibility for any damage or loss resulting directly or indirectly from the use of this e-mail or its contents.

This e-mail and any files transmitted with it are confidential and solely for the use of the addressee. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on this e-mail, is prohibited and may be unlawful. Opinions expressed in this e-mail are those of the individual and not those of the Company unless specifically indicated to that effect.

If you have received this e-mail in error please inform us and delete it from your mailbox and/or any other storage mechanism.

FMG Support Ltd T:0870 830 3830 mailto:support@fmgsupport.com.