[Rt-devel] Question concerning upgrade from 3.6.3 to 3.8

[Curtis Bruneau]

Ruslan Zakirov wrote:
> On Wed, Aug 6, 2008 at 9:31 PM, Curtis Bruneau <curtisb at vianet.ca> wrote:
>   
>>> Date: Tue, 5 Aug 2008 14:06:41 -0700
>>> From: "Greg Petras" <gpetme at gmail.com>
>>> Subject: Re: [Rt-devel] Question concerning upgrade from 3.6.3 to 3.8
>>> To: "Ruslan Zakirov" <ruz at bestpractical.com>
>>> Cc: Jay Lee <jlee at pbu.edu>, rt-devel at lists.bestpractical.com
>>> Message-ID:
>>>       <ffa2dce10808051406p369b4e34h661fd81e43e68e99 at mail.gmail.com>
>>> Content-Type: text/plain; charset=ISO-8859-1
>>>
>>> On Tue, Aug 5, 2008 at 1:37 PM, Ruslan Zakirov <ruz at bestpractical.com> wrote:
>>>
>>>       
>>>> Then somehow you've missed etc/upgrade/3.7.82/content
>>>>
>>>>         
>>> Strange. I ran rt-setup-database as instructed. Regardless, I ran the
>>> content for each version needed, and the bookmarks section shows up
>>> now.
>>>
>>> Thanks guys!
>>>
>>> Greg
>>>       
>> I have had the same issue, basically the rt-setup-database upgrade
>> scripts complain that's it's not the new schema, you have to do the
>> alter table schema updates before you can run it, unfortunately the
>> documentation isn't very specific in that regard, the instruction is
>> confusing with the documents cross referencing.
>>     
> What exactly is confusing? Please provide us more info, we really
> would like to improve documentation to make it easier.Curtis
> _______________________________________________
> List info: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel
>
>   
>
>
>
>   
It's not exactly bad, there's just 3 documents to refer when upgrading 
w/ mysql .. the part that confused me was in the README when you get to 
step 7 it says read UPGRADE. There's a few things to check in there, 
some things say to do before the upgrade, I assume it's safe to also run 
the shrink_cgm_table.pl before an upgrade, or is it? So on to 
UPGRADING.mysql.. it says

3) Apply changes described in the seven step, but only up to version 3.8.0.

4) Apply mysql 4.0->4.1 schema changes. RT tarball has script
etc/upgrade/schema.mysql-4.0-4.1.pl that generates SQL queries to 
upgrade schema of
the DB. Run it:

    perl etc/upgrade/schema.mysql-4.0-4.1.pl > sql.queries


The problem here is you have to run step 4 in (UPGRADING.mysql) before 
doing the end of step 7 in (README).. then it says to go back to 7 after 
it's done .. which is fine .. I think the STEP 3) in UPGRADING.mysql is 
misleading because rt-setup-database scripts simply won't work until 
schema.mysql-4.0.4.1.pl is ran and executed.

Sorry if this doesn't make sense.. basically it might help to make a 
single upgrade document where the step order is a little more defined.

Curtis.