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):
[EMAIL PROTECTED] 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.
[EMAIL PROTECTED] 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.
[EMAIL PROTECTED] 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.
[EMAIL PROTECTED] 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
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
