Thanks for all the suggestions. I will try read upgrade and upgrade.mysql a few more times.<br><br>I tried command rt-setup-database for upgrading MySQL database, but had following error.<br><br># /opt/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password --action upgrade<br>
In order to create or update your RT database, this script needs to connect to your mysql instance on localhost as root<br>Please specify that user's database password below. If the user has no database<br>password, just press return.<br>
<br>Password: <br>Working with:<br>Type: mysql<br>Host: localhost<br>Name: rt3<br>User: rt_user<br>DBA: root<br>Enter RT version you're upgrading from: 3.2.3<br><br>Going to apply following upgrades:<br>* 3.3.0<br>
* 3.3.11<br>* 3.5.1<br>* 3.7.1<br>* 3.7.3<br>* 3.7.10<br>* 3.7.15<br>* 3.7.19<br>* 3.7.81<br>* 3.7.82<br>* 3.7.85<br>* 3.7.86<br>* 3.7.87<br>* 3.8.0<br>* 3.8.1<br>* 3.8.2<br>* 3.8.3<br>* 3.8.4<br>* 3.8.6<br>* 3.8.8<br>* 3.8.9<br>
<br>Enter RT version if you want to stop upgrade at some point,<br> or leave it blank if you want apply above upgrades: <br><br>IT'S VERY IMPORTANT TO BACK UP BEFORE THIS STEP<br><br>Proceed [y/N]:y<br>Processing 3.3.0<br>
Now populating database schema.<br>DBD::mysql::st execute failed: Duplicate column name 'ObjectType' at /wstore/www/rt3/sbin/../lib/RT/Handle.pm line 515.<br><br>Do I really need to start from RT version 3.2.3? How do I find out certain columns are already in the database?<br>
<br>Simon<br>