Re: [rt-users] Problems upgrading RTFM to 2.2.0RC4

2006-12-20 Thread Bill Davis
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 [EMAIL PROTECTED]
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-CUSTOM FIELD NAME-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: [EMAIL PROTECTED]


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


RE: [rt-users] Problems upgrading RTFM to 2.2.0RC4

2006-12-20 Thread John Parker
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: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] 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 [EMAIL PROTECTED]
 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-CUSTOM FIELD NAME-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: [EMAIL PROTECTED]


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:[EMAIL PROTECTED] 

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

Re: [rt-users] Problems upgrading RTFM to 2.2.0RC4

2006-12-20 Thread Bob Goldstein
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



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: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] 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 [EMAIL PROTECTED]
 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

Re: [rt-users] Problems upgrading RTFM to 2.2.0RC4

2006-12-20 Thread Bill Davis




That helps ..., thanks  :-) 

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: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] 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 [EMAIL PROTECTED]
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-CUSTOM FIELD NAME-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: [EMAIL PROTECTED]


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:[EMAIL PROTECTED] 

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.


***

Re: [rt-users] Problems upgrading RTFM to 2.2.0RC4

2006-12-19 Thread 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):



[EMAIL PROTECTED] RTFM-2.2.0RC4]# /opt/rt3/sbin/rt-setup-database
--action schema \ --datadir etc/upgrade/2.2.0RC2 --dba root
--dba-password xx
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 xx
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 xx
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 

Re: [rt-users] Problems upgrading RTFM to 2.2.0RC4

2006-12-19 Thread 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-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 the following
(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 xx
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 xx
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 xx
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

Re: [rt-users] Problems upgrading RTFM to 2.2.0RC4

2006-12-19 Thread Bob Goldstein
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
___
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


Re: [rt-users] Problems upgrading RTFM to 2.2.0RC4

2006-12-19 Thread Bill Davis




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

  



___
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

Re: [rt-users] Problems upgrading RTFM to 2.2.0RC4

2006-12-19 Thread Jesse Vincent
The readme mentions a special post-2.0 upgrade script. Did the output from that 
look ok?

--- Original message ---
From: Bill Davis [EMAIL PROTECTED]
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-CUSTOM FIELD NAME-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: [EMAIL PROTECTED]


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


Re: [rt-users] Problems upgrading RTFM to 2.2.0RC4

2006-12-18 Thread Bob Goldstein
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

___
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