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.sm...@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. _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com