Upgrade trouble (from 1.0.7 to 1.2.1)

[flintg]

Hello,

I'm trying to upgrade our MantisBT from version 1.0.7 to 1.2.1. To make matters worse, we're also moving from an old Ubuntu laptop (acting as a server) to a new robust Win 2008 dedicated web server while simultaneously upgrading MySQL, PHP, and Apache.

I have finally moved the database from the old system to the new system under the old 1.0.7 schema. When I run ../admin/install.php, it produces an error when trying to create the tables (because they already exist, you see, I moved the database before I installed MantisBT). It fails on the first CREATE ...

Table 'config_table' already exists.

Any help would be greatly appreciated!

System specifications:

Old Mantis

• Mantis: 1.0.7

• MySQL: 5.0.45

• PHP: 5.2.3

• OS: Linux 2.6.22-16-generic

New Mantis

• Mantis: 1.2.1

• MySQL: 5.1.48

• PHP: 5.3.2

• OS: Windows 2008 Standard SP2 x64

Regards,
Flint

[flintg]

I got this resolved ... if you wish to know how I did it, read on.

I first installed the *old* version of Mantis with all the new supporting technologies (PHP, MySQL, etc.). Then as a test I installed a fresh database, and upgraded that version to the build I wanted. For whatever reason, this worked just fine.

So, I did the same thing with my real data:

• Created a new database with the admin/install.php script.

• Imported my old data into the new database (because I was moving to a different physical server).

• Verified that my new installation of the old version of Mantis BT worked.

• Upgraded per the instructions in the Manual: http://www.mantisbt.org/manual/manual.i ... rading.php.

• Verified that my new installation of the new version of Mantis BT worked.

- Flint