<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-2022-jp">
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"MS Mincho";
panose-1:2 2 6 9 4 2 5 8 3 4;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"\@MS Mincho";
panose-1:2 2 6 9 4 2 5 8 3 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-GB link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal>Regarding this previous post, did anyone find the answer as
I have this exact issue as well.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>RTFM was upgraded from an unknown version and we lost all
the content of the RTFM articles.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Thanks<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Michael.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>---------- Start of article<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal style='background:white'><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'>Bill Davis<br>
</span><b><span lang=JA style='font-size:12.0pt;font-family:"MS Mincho"'>日付</span></b><b><span
style='font-size:12.0pt;font-family:"Times New Roman","serif"'>: </span></b><span
style='font-size:12.0pt;font-family:"Times New Roman","serif"'>
2006-12-19 09:56 -000<br>
<b>To: </b>rt-users<br>
</span><b><span lang=JA style='font-size:12.0pt;font-family:"MS Mincho"'>題目</span></b><b><span
style='font-size:12.0pt;font-family:"Times New Roman","serif"'>: </span></b><span
style='font-size:12.0pt;font-family:"Times New Roman","serif"'>Re: [rt-users]
Problems upgrading RTFM to 2.2.0RC4<o:p></o:p></span></p>
<p class=MsoNormal style='background:white'><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'>Bob Goldstein wrote:<i> <br>
>> I'm using RT 3.6.1 with an unknown version of RTFM installed (though I
<br>
>> think it is probably RTFM 2.1.40 based on the time frame installed)
and <br>
>> am trying to migrate to RTFM 2.2.0RC4. Downloaded the file, read the <br>
>> README file, didn't seem to fit the upgrade instructions (not
upgrading <br>
>> <br>
> >from a 2.0.x release), ... so tried the normal install instructions <br>
> <br>
>> (make Makefile.PL, make install), omitted "make initdb"
because it <br>
>> wasn't an "initial install", stopped and started the
webserver. <br>
>> <br>
>> Appears I now have an upgraded version, however all previous RTFM <br>
>> articles, while they still exist, have no content. <br>
>> <br>
>> Before I muck it up further would appreciate some advice: <br>
>> <br>
>> 1. How do you tell what version of RTFM is installed? ... I can't seem
<br>
>> to find it anywhere? <br>
>> 2. How can I get my article content back & properly complete the <br>
>> upgrade? ... should I run the "make initdb" command or will
this <br>
>> overwrite the existing tables in the database? <br>
>> <br>
>> <br>
> <br>
> Notice that /etc/upgrades has three directories: <br>
> 2.1.0 2.1.30 2.2.0RC2 <br>
> <br>
> You must apply the upgrade from these for each version <br>
> later than the one you are upgrading. If you are starting with <br>
> 2.1.40, then you need apply 2.2.0RC2 <br>
> <br>
> But also, the README left out a critical piece. <br>
> That is, the upgrade will break the association of <br>
> which custom fields go with which classes (which is why <br>
> your articles now appear to have no content.) To get it back: <br>
> <br>
> Login the RT web interface-> <br>
> Config->RTFM->Custom Fields-><CUSTOM FIELD
NAME>->Apply-> Select the classes <br>
> the customfield will apply to (the common is to select all) and then click
Send <br>
> <br>
> bobg</i> <br>
Thanks for the reply. Since I'd already run "make Makefile.PL" &
"make <br>
install", picked up the update instructions with (producing the <br>
responses indicated): <br>
<i><br>
> [root@BlackHole RTFM-2.2.0RC4]# /opt/rt3/sbin/rt-setup-database <br>
> --action schema \ --datadir etc/upgrade/2.2.0RC2 --dba root <br>
> --dba-password xxxxxx <br>
> Creating database schema. <br>
> readline() on closed filehandle SCHEMA_LOCAL at <br>
> /opt/rt3/sbin/rt-setup-database line 192. <br>
> Problem with statement: <br>
> <br>
> CREATE TABLE Attachments ( <br>
> id INTEGER NOT NULL AUTO_INCREMENT, <br>
> TransactionId integer NOT NULL , <br>
> Parent integer NOT NULL DEFAULT 0 , <br>
> MessageId varchar(160) NULL , <br>
> Subject varchar(255) NULL , <br>
> Filename varchar(255) NULL , <br>
> ContentType varchar(80) NULL , <br>
> ContentEncoding varchar(80) NULL , <br>
> Content LONGTEXT NULL , <br>
> Headers LONGTEXT NULL , <br>
> Creator integer NOT NULL DEFAULT 0 , <br>
> Created DATETIME NULL , <br>
> PRIMARY KEY (id) <br>
> ) TYPE=InnoDB <br>
> Table 'Attachments' already exists at <br>
> /opt/rt3/sbin/rt-setup-database line 212. <br>
> [root@BlackHole RTFM-2.2.0RC4]# /opt/rt3/sbin/rt-setup-database <br>
> --action acl \ - -datadir etc/upgrade/2.2.0RC2 --dba root <br>
> --dba-password xxxxxx <br>
> Done setting up database ACLs. <br>
> [root@BlackHole RTFM-2.2.0RC4]# /opt/rt3/sbin/rt-setup-database <br>
> --action insert \ --datadir etc/upgrade/2.2.0RC2 --dba root <br>
> --dba-password xxxxxx <br>
> Use of uninitialized value in concatenation (.) or string at <br>
> /opt/rt3/sbin/rt-se tup-database line 162. <br>
> [Tue Dec 19 09:25:12 2006] [crit]: Can't locate /content in @INC <br>
> (@INC contains: /opt/rt3/lib /opt/rt3/local/lib <br>
> /usr/lib/perl5/site_perl/5.8.8/i386-linux-threa d-multi <br>
> /usr/lib/perl5/site_perl/5.8.7/i386-linux-thread-multi <br>
> /usr/lib/perl5/si te_perl/5.8.6/i386-linux-thread-multi <br>
> /usr/lib/perl5/site_perl/5.8.5/i386-linux- thread-multi <br>
> /usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi <br>
> /usr/lib/per l5/site_perl/5.8.3/i386-linux-thread-multi <br>
> /usr/lib/perl5/site_perl/5.8.8 /usr/l ib/perl5/site_perl/5.8.7 <br>
> /usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl /5.8.5 <br>
> /usr/lib/perl5/site_perl/5.8.4 /usr/lib/perl5/site_perl/5.8.3 <br>
> /usr/lib/pe rl5/site_perl <br>
> /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi /usr/lib/ <br>
> perl5/vendor_perl/5.8.7/i386-linux-thread-multi <br>
> /usr/lib/perl5/vendor_perl/5.8.6 /i386-linux-thread-multi <br>
> /usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-mult i <br>
> /usr/lib/perl5/vendor_perl/5.8.4/i386-linux-thread-multi <br>
> /usr/lib/perl5/vendor _perl/5.8.3/i386-linux-thread-multi <br>
> /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/pe rl5/vendor_perl/5.8.7 <br>
> /usr/lib/perl5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_per l/5.8.5 <br>
> /usr/lib/perl5/vendor_perl/5.8.4 /usr/lib/perl5/vendor_perl/5.8.3 <br>
> /usr/l ib/perl5/vendor_perl <br>
> /usr/lib/perl5/5.8.8/i386-linux-thread-multi /usr/lib/perl5 /5.8.8 <br>
> .) at /opt/rt3/sbin/rt-setup-database line 456. <br>
> (/opt/rt3/lib/RT.pm:317) <br>
> Can't locate /content in @INC (@INC contains: /opt/rt3/lib <br>
> /opt/rt3/local/lib /u <br>
> sr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi <br>
> /usr/lib/perl5/site_perl/5. 8.7/i386-linux-thread-multi <br>
> /usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-mul ti <br>
> /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi <br>
> /usr/lib/perl5/site_pe rl/5.8.4/i386-linux-thread-multi <br>
> /usr/lib/perl5/site_perl/5.8.3/i386-linux-threa d-multi <br>
> /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl/5.8.7 <br>
> /usr/lib/p erl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5 <br>
> /usr/lib/perl5/site_perl/5.8 .4 /usr/lib/perl5/site_perl/5.8.3 <br>
> /usr/lib/perl5/site_perl /usr/lib/perl5/vendor <br>
> _perl/5.8.8/i386-linux-thread-multi <br>
> /usr/lib/perl5/vendor_perl/5.8.7/i386-linux- thread-multi <br>
> /usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi <br>
> /usr/lib/p erl5/vendor_perl/5.8.5/i386-linux-thread-multi <br>
> /usr/lib/perl5/vendor_perl/5.8.4/ i386-linux-thread-multi <br>
> /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi <br>
> /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl/5.8.7 <br>
> /usr/lib/perl 5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_perl/5.8.5 <br>
> /usr/lib/perl5/vendor_perl/ 5.8.4 /usr/lib/perl5/vendor_perl/5.8.3 <br>
> /usr/lib/perl5/vendor_perl /usr/lib/perl5 <br>
> /5.8.8/i386-linux-thread-multi /usr/lib/perl5/5.8.8 .) at <br>
> /opt/rt3/sbin/rt-setup -database line 456. <br>
> [root@BlackHole RTFM-2.2.0RC4]#</i> <br>
This collection of errors messages didn't give me a warm fuzzy <br>
feeling & stopping & restarting the webserver, I'm seeing the same <br>
results: previous articles listed, but with no contents. The <br>
configuration for RTFM also seems to have no custom fields listed. <br>
<br>
Ideas welcome ... <br>
Bill Davis <o:p></o:p></span></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>---------- End of article<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</body>
<!--[object_id=#c4406a7fdb9cb3499e4fcc588b6e2301#]--><P align=left><FONT face=Tahoma size=2><FONT color=#0000ff>
<HR>
</FONT></FONT></P>
<P align=left><FONT face=Tahoma color=#0000ff size=4><STRONG>Our ethos: protecting the future of your business</STRONG></FONT></P>
<P align=left><FONT face=Tahoma size=2><FONT color=#0000ff>This is an e-mail from Ethos Information Solutions Limited and is intended only for the addressee named above. The contents of this message should not be disclosed to any other person nor copies taken or forwarded without written permission. Any views or opinions presented are solely those of the sender and do not necessarily represent the views of Ethos Information Solutions Limited.</FONT></FONT></P>
<P align=left><FONT face=Tahoma size=2><FONT color=#0000ff>We do not accept any responsibility for the contents of this message and although this message has been scanned for viruses prior to transmission we would recommend that you check before opening any attachments as we cannot accept liability for any damage sustained as a result of any software viruses. </FONT></FONT><FONT face=Tahoma size=2><FONT color=#0000ff>Please notify the sender immediately if you have received this e-mail by mistake and delete it from your systems, or report it to our support database at <A href="mailto:support@ethos-is.net">support@ethos-is.net</A></FONT></FONT></P>
<P align=left><FONT face=Tahoma size=2><FONT color=#0000ff>For more information about the services we provide please visit our web site at <A href="http://www.ethos-is.com">http://www.ethos-is.com</A></FONT></FONT></P>
<P align=left><IMG alt="" hspace=0 src="http://www.ethos-is.com/images/mslogo.png" align=baseline border=0></P></html>