[rt-users] DB upgrade for RT 3.8 fails

[Andy Smith]

Anybody? :S

Without any other clues, and out of curiosity, and not really  
following exactly what is supposed to be the correct upgrade procedure  
:P I tried the following:

run schema.mysql-4.0-4.1.pl and apply the generate SQL
go to each directory in the source under etc/upgrade and apply any  
schema.mysql files to my DB

After this on the face of it I have a working RT3.8, but I dont really  
know if this is a robust way of upgrading and how likely I am to  
encounter problems later :S For example I complete ignored all the  
"content" files as I dont know what they are for :S

thanks, Andy.

Quoting Andy Smith <a.smith at ukgrid.net>:

> Hi,
>
>   I am testing an upgrade on FreeBSD of RT 3.6.7 to RT 3.8.1 and I  
> am getting an error when attempting to upgrade the MySQL DB.
>
> I am running the command:
>
> rt-setup-database --dba=root --action upgrade
>
> And after answering the various questions it starts to execute then  
> bombs out with this error:
>
> Proceed [y/N]:y
> Processing 3.7.1
> Now inserting data
> Processing 3.7.3
> Now populating database schema.
> [Wed Jan 14 17:09:06 2009] [crit]: DBD::mysql::st execute failed:  
> Table 'Attachments' already exists at  
> /usr/local/lib/perl5/site_perl/5.8.8/RT/Handle.pm line 470.  
> (/usr/local/lib/perl5/site_perl/5.8.8/RT.pm:379)
> DBD::mysql::st execute failed: Table 'Attachments' already exists at  
> /usr/local/lib/perl5/site_perl/5.8.8/RT/Handle.pm line 470.
>
> Can anyone help? I couldn't see any related problems searching via google :S
>
> thanks for any replies!
>
> Andy.
>
> ----------------------------------------------------------------
> This message was sent using IMP, the Internet Messaging Program.
>



----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.