[rt-users] Problems upgrading RTFM to 2.2.0RC4

[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-><CUSTOM FIELD NAME>->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 at 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 at 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 at 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 at 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