Where are the upgrade packages?

[sundance]

Hi all,

I recently downloaded a specific upgrade package for 1.1.8->1.2.4. Now I need one from 1.1.1->1.2.8. I can't find the download page anymore.

I tried downloading the full 1.2.8 package and started install.php. But that routine does not work. I tries to create tables that already exist.

Can anyone help?

Best regards,
Sundance

[atrol]

I recently downloaded a specific upgrade package for 1.1.8->1.2.4.

I am not aware that we deliver any special upgrade packages. Please post the download link.

I tried downloading the full 1.2.8 package and started install.php.

Did you follow the upgrade instructions in file doc/INSTALL of you download?

[sundance]

Damn, thats weird. I could swear it was a page with links in the form of <fromversion>-><toversion>. Cant find it anymore.
I will do the reading again. Maybe I missed something. Thanks for the help.

[sundance]

Ok, I did as described in the UPGRADE paragraph in the install doc file.

I copied 1.2.8 in a new folder on the server.
I copied my config files to the new directory.
I launched /new-mantis/admin/install.php
I provided db user and password
I clicked Install/Upgrade
Process fails with the following error:

Code: Select all

BAD
CREATE TABLE mantis_bug_history_table ( id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, user_id INTEGER UNSIGNED NOT NULL DEFAULT 0, bug_id INTEGER UNSIGNED NOT NULL DEFAULT 0, date_modified DATETIME NOT NULL DEFAULT '1970-01-01 00:00:01', field_name VARCHAR(32) NOT NULL DEFAULT '', old_value VARCHAR(128) NOT NULL DEFAULT '', new_value VARCHAR(128) NOT NULL DEFAULT '', type SMALLINT NOT NULL DEFAULT 0, PRIMARY KEY (id) )ENGINE=MyISAM DEFAULT CHARSET=utf8
Table 'mantis_bug_history_table' already exists

And that makes sense to me because of course this table already exists. When I delete that specific table the upgrade fails on the next CREATE. All tables already exist.

Next thing I tried is changing the CREATE statements into CREATE IF NOT EXISTS. But then the ALTER statements fail because they are e.g. trying to add a second primary index to an already existing table.

Next thing I tried is installing a new installation and import my old data into the new DB. That does not work cause the column count does not match anymore.

What else can I do?

[atrol]

you should restore your database to 1.1.8 and have a look at mantis_config_table before starting any upgrade process

Code: Select all

select value from mantis_config_table where config_id = 'database_version';

[donkuhlman]

Hi folks. I'm new here, new to Mantis, and new to mySQL. I'm working on trying to upgrade from a 1.1.8 version of Mantis to 1.2.8. We have done the following:
1) Built a new Linux server
2) Installed a fresh/blank version of Mantis 1.2.8 which is working
3) I have made a mysqldump from the old server db
4) Copied the mysql backup file to the new server

Can someone tell me what to do next? I've tried to find the update/install docs on the new server and searched through the forums for the steps, but can't seem to find the right documents. I don't know whether I need to copy other configuration files from the old server to the new one, or do a mysql restore, etc. Also, when I load the http://newmantisserver/mantis/admin/install.php it doesn't seem to let me point to the old database.

Thanks

Don K

[atrol]

Did you follow the upgrade instructions in file doc/INSTALL of you download?

[donkuhlman]

Thanks for the reply atrol. Yes I've searched through the sgml files on the new server and can't seem to find the right doc for how to do a server migration and upgrade of the old database to a new one.

Can someone provide any other suggestions on how to import the old db into a new db installed on a separate server running 1.2.8 please?

[atrol]

Can someone provide any other suggestions on how to import the old db into a new db installed on a separate server running 1.2.8 please?

This is not possible. You can't import an old db to a new db. The database schema changed from version 1.1.x of MantisBT to version 1.2.x. You have to export the old db, import the old db on new server, unpack MantisBT 1.2.8 on new server and run admin/install.php.