[rt-users] One more time, Upgrading RT from ancient version to current

[Simon Gao]

Thanks for all the suggestions. I will try read upgrade and upgrade.mysql a
few more times.

I tried command rt-setup-database for upgrading MySQL database, but had
following error.

# /opt/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password
--action upgrade
In order to create or update your RT database, this script needs to connect
to your  mysql instance on localhost as root
Please specify that user's database password below. If the user has no
database
password, just press return.

Password:
Working with:
Type:   mysql
Host:   localhost
Name:   rt3
User:   rt_user
DBA:    root
Enter RT version you're upgrading from: 3.2.3

Going to apply following upgrades:
* 3.3.0
* 3.3.11
* 3.5.1
* 3.7.1
* 3.7.3
* 3.7.10
* 3.7.15
* 3.7.19
* 3.7.81
* 3.7.82
* 3.7.85
* 3.7.86
* 3.7.87
* 3.8.0
* 3.8.1
* 3.8.2
* 3.8.3
* 3.8.4
* 3.8.6
* 3.8.8
* 3.8.9

Enter RT version if you want to stop upgrade at some point,
  or leave it blank if you want apply above upgrades:

IT'S VERY IMPORTANT TO BACK UP BEFORE THIS STEP

Proceed [y/N]:y
Processing 3.3.0
Now populating database schema.
DBD::mysql::st execute failed: Duplicate column name 'ObjectType' at
/wstore/www/rt3/sbin/../lib/RT/Handle.pm line 515.

Do I really need to start from RT version 3.2.3? How do I find out certain
columns are already in the database?

Simon
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110322/4962f05b/attachment.htm>