Upgrade from 0.19.4 to 1.0.0rc5 fails?

[bartv]

Hi,

I'm trying to upgrade a 0.19.4 installation to 1.0.0rc5. I have imported my database tables into the test installation and then run the upgrade script. After filling out the database parameters I press Install/Upgrade button, but instead of upgrading the installation the installer tries to create the tables. Of course this fails but I cannot continue with the upgrade.

Did I miss something? Any pointers would be very welcome.

Cheers,

Bart

[rata]

Bart

You need to go into the Admin directory and run Upgrade your installation. This will make the necessary database changes - not create a new database like Install does.

I hope this info isn't too late for you.

[bartv]

Hi rata,

I tried that, but when I go to mantis/admin/upgrade.php , I get redirected to mantis/admin/install.php and I run into the same problem.

Any ideas?

Thanks,

bart

[drcolombo]

Bart

You need to go into the Admin directory and run Upgrade your installation. This will make the necessary database changes - not create a new database like Install does.

I hope this info isn't too late for you.

I've also tried to upgrade (but from 0.19.1) to 1.0.0 and upgrade.php also redirected me to install.php that tried to create all the tables instead of altering them, i.e.:
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

Of course it already exists because I want to upgrade!
BTW, 1.0.0rc5 upgraded 0.19.1 well (with some errors but anyway, it upgraded).

[faScinATIon]

hi,

it gives me the same error when i want to upgrade:

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

[faScinATIon]

i want to update from 0.19.0 -> 1.0.0

[Guest]

Me Too, Same problem

[Guest]

Had the same Problem.
I used the "old upgrade page":
http://YOURSever/mantis-1.0.0/admin/

Thats only possible if you don't run into the trouble of the posting above.

When you ran into that trouble, the fix for me was to drop the table 'mantis_config_table'. And start the upgrade again.

[xanadu1215]

Yes dropping the table works. Of course you might have to drop them all. A good tool that will help is Navicat. It's about $30 a year and WELL worth it.

[dcomo]

You can also use PHPMyAdmin, which is a nice, clean and free tool!
(I've personally never used Navicat, so I can't judge it...)