[rt-users] Upgrading to 3.8.0: schema.mysql, column_info selection problem

[Tim Cutts]

On 21 Jul 2008, at 4:57 pm, Emmanuel Lacour wrote:

> On Wed, Jul 16, 2008 at 10:09:52PM +0400, Ruslan Zakirov wrote:
>> Let's make it clear:
>> * you still must upgrade DB using files in etc/upgrade/x.x.x/
>> * however in 3.8.0 you can do it using one command:
>>
>> rt-setup-database --dba root --prompt-for-dba-password --action  
>> upgrade
>>
>> it will ask for the old version (for example you can enter 3.6.7) and
>> will apply all steps up to the installed version (in this case it's
>> 3.8.0)
>>
>> * then you do mysql schema changes using the script
>> * these schema changes are required for all mysql versions greater
>> than mysql 4.1.0
>>
>
> I have some problems about this here:
>
> - I ran the 4.0-4.1 script on the DB, no errors

You ran the script, which generates the SQL commands, and you then ran  
those SQL commands on the database, right?  It's a two-step process.

Tim


-- 
 The Wellcome Trust Sanger Institute is operated by Genome Research 
 Limited, a charity registered in England with number 1021457 and a 
 company registered in England with number 2742969, whose registered 
 office is 215 Euston Road, London, NW1 2BE.