Mantis Bug Tracker - Forums

Hi:

1. I've made a backup of my current Mantis DB
2. Create a new db mantis_1 and restore the backup made in (1)
3. Download mantis 1.0.0rc1 and unzip it.
4. When I try to upgrade I get the following problem regarding
an existent table (obvious because I want to upgrade an existent DB):

BAD
CREATE TABLE mantis_bug_file_table ( id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, bug_id INTEGER UNSIGNED NOT NULL DEFAULT 0, title VARCHAR(250) NOT NULL DEFAULT '', description VARCHAR(250) NOT NULL DEFAULT '', diskfile VARCHAR(250) NOT NULL DEFAULT '', filename VARCHAR(250) NOT NULL DEFAULT '', folder VARCHAR(250) NOT NULL DEFAULT '', filesize INTEGER NOT NULL DEFAULT 0, file_type VARCHAR(250) NOT NULL DEFAULT '', date_added DATETIME NOT NULL DEFAULT '1970-01-01 00:00:01', content LONGBLOB NOT NULL, PRIMARY KEY (id) )TYPE=MyISAM

Table 'mantis_bug_file_table' already exists

Any hint, before start lokking myself at the php code ???

To upgrade from 0.19.2 to 1.0.0, you need to run the 'admin/upgrade.php' script (not the admin/install.php script). This should update the appropriate tables, rather than installing them.

It's what I have done, but upgrade.php redirect me to the other page.

Any hint ?

Somehow the original upgrade has failed.

Could you find the value of a row in the mantis_congif_table where config_id = 'database_version'? Deleting this row should activate the older upgrade.php program.

I will try and inform here the results.

Best Regards