[rt-users] error upgrading from 3.4.5 to 3.6.4 (via etc/upgrade/3.5.1 script)

[Kenneth Crocker]

Trenton,



	What I found was that I didn't need to BUILD the schema, just upgrade 
it. In fact, there are 3 DB upgrade executions we did (due to 3.5.1), 
which were:

	1) action schema
	2) action acl
	3) action insert

	Turns out, the only one that did anything was action insert. The DB 
changes due to 3.5.1 do not really change any schema design or major 
stuff like that, it merely adds two new queries (10 unowned & my 
tickets) as default and updates the privileges so they can be used. I 
actually upgraded and forgot to run the DB upgrade part and RT worked 
fine, except those two queries were NOT listed or available. I ran the 
three actions and those two queries were available for home page 
selection. I'm not familiar with how MySQL works as a database (in terms 
of schema changes) so perhaps it requires a rebuild. Here's what I used 
as my commands:

	1) Typed “/tools/bin/perl/apps/rt/rt-[3.6.4]/sbin/rt-setup-database 
–dba rtadm –prompt-for-dba-password –action schema –datadir 
etc/upgrade/[3.5.1]” <enter> as one line.
	2) Typed “/tools/bin/perl/apps/rt/rt-[3.6.4]/sbin/rt-setup-database 
–dba rtadm –prompt-for-dba-password –action acl –datadir 
etc/upgrade/[3.5.1]” <enter> as one line.
	3) Typed “/tools/bin/perl/apps/rt/rt-[3.6.4]/sbin/rt-setup-database 
–dba rtadm –prompt-for-dba-password –action insert –datadir 
etc/upgrade/[3.5.1]” <enter> as one line.

	Hope this helps.

Kenn
LBNL

On 4/21/2008 12:10 PM, Trenton Taylor wrote:
> Nope ... 
> 
> Still no upgraded DB. We use Mysql.
> 
> I am basically running a new instance of RT and an additional archive DB
> now. We don't have many tickets on the new DB so I could easily delete
> them if someone could explain to me what is going wrong with the upgrade
> script.
> 
> Kenn ... what did your upgrade command look like? Anything different
> than mine? (/opt/rt3.6/sbin/rt-setup-database --action schema \
> --datadir etc/upgrade/3.5.1 --dba root --prompt-for-dba-password)
> 
> Thanks in advance to anyone who helps out ...
> 
> Trent
> 
> -----Original Message-----
> From: Kenneth Crocker [mailto:KFCrocker at lbl.gov] 
> Sent: Monday, April 21, 2008 12:02 PM
> To: Trenton Taylor
> Cc: rt-users at lists.bestpractical.com
> Subject: Re: [rt-users] error upgrading from 3.4.5 to 3.6.4 (via
> etc/upgrade/3.5.1 script)
> 
> Trenton,
> 
> 
> 	Did you get an answer to this? I just finished the same upgrade.
> We use 
> Oracle.
> 
> Kenn
> LBNL
> 
> On 4/17/2008 8:30 AM, Trenton Taylor wrote:
>> I'm trying to upgrade my RT system from 3.4.5 to 3.6.4 via:
>>
>>  
>>
>> # command:
>>
>> /opt/rt3.6/sbin/rt-setup-database --action schema \ --datadir 
>> etc/upgrade/3.5.1 --dba root --prompt-for-dba-password
>>
>>  
>>
>> But I am getting this error:
>>
>>  
>>
>> #:
>>
>> Creating database schema.
>>
>> 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.6/sbin/rt-setup-database 
>> line 220, <SCHEMA> line 464.
>>
>>  
>>
>>  
>>
>> Thanks in advance -
>>
>> Trent
>>
>>  
>>
>>
>> Important: The information contained in this e-mail message is 
>> confidential and is intended only for the named addressee(s). If the 
>> reader of this e-mail message is not an intended recipient (or the 
>> individual responsible for the delivery of this e-mail message to an 
>> intended recipient), please be advised that any re-use, dissemination,
> 
>> distribution or copying of this e-mail message is prohibited. If you 
>> have received this e-mail message in error, please reply to the sender
> 
>> that you have received the message in error and then delete it. Thank
> you.
>>
>>
> ------------------------------------------------------------------------
>> _______________________________________________
>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>
>> Community help: http://wiki.bestpractical.com
>> Commercial support: sales at bestpractical.com
>>
>>
>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
>> Buy a copy at http://rtbook.bestpractical.com
> 
> 
> 
> Important: The information contained in this e-mail message is confidential and is intended only for the named addressee(s). If the reader of this e-mail message is not an intended recipient (or the individual responsible for the delivery of this e-mail message to an intended recipient), please be advised that any re-use, dissemination, distribution or copying of this e-mail message is prohibited. If you have received this e-mail message in error, please reply to the sender that you have received the message in error and then delete it. Thank you. 
> 
>