first thanks for maintaining and taking care of this awesome simple tool!!
We have a Mantis Installation running stable for a long time.
Now we face the issue of moving everything to a new server with a fresh setup. So i basically followed these steps https://www.mantisbt.org/wiki/doku.php/ ... mp_restore to create the dump files.
On the new machine i did
- Install latest Mantis
- Setup new Database with new root user
- Loggin into the database
- mysql -uroot -ppw bugtracker < mantisdb_files.sql
- mysql -uroot -ppw bugtracker < mantisdb.sql
- using the config_inc.php from the new installation
When i type in the new admin credentials and press the install/upgrade button i get this error message
It seems like the php process is looking for some wrong columns since in the table descriptions are different column names. However in the schema file there are some renamings happening. Might the upgrade process failed?APPLICATION ERROR #401
Database query failed. Error received from database was #1054: Unknown column 'date_submitted_int' in 'where clause' for the query: SELECT id, date_submitted,due_date,last_updated FROM mantis_bug_table WHERE date_submitted_int = 1 OR due_date_int = 1 OR last_updated_int = 1.
Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section.
Old table format (from sql dump file)
Code: Select all
CREATE TABLE `mantis_bug_table` (
`id` int(7) unsigned NOT NULL AUTO_INCREMENT,
`project_id` int(7) unsigned NOT NULL DEFAULT '0',
`reporter_id` int(7) unsigned NOT NULL DEFAULT '0',
`handler_id` int(7) unsigned NOT NULL DEFAULT '0',
`duplicate_id` int(7) unsigned NOT NULL DEFAULT '0',
`priority` int(2) NOT NULL DEFAULT '30',
`severity` int(2) NOT NULL DEFAULT '50',
`reproducibility` int(2) NOT NULL DEFAULT '10',
`status` int(2) NOT NULL DEFAULT '10',
`resolution` int(2) NOT NULL DEFAULT '10',
`projection` int(2) NOT NULL DEFAULT '10',
`eta` int(2) NOT NULL DEFAULT '10',
`bug_text_id` int(7) unsigned NOT NULL DEFAULT '0',
`os` varchar(32) NOT NULL DEFAULT '',
`os_build` varchar(32) NOT NULL DEFAULT '',
`platform` varchar(32) NOT NULL DEFAULT '',
`version` varchar(64) NOT NULL DEFAULT '',
`fixed_in_version` varchar(64) NOT NULL DEFAULT '',
`build` varchar(32) NOT NULL DEFAULT '',
`profile_id` int(7) unsigned NOT NULL DEFAULT '0',
`view_state` int(2) NOT NULL DEFAULT '10',
`summary` varchar(128) NOT NULL DEFAULT '',
`sponsorship_total` int(7) NOT NULL DEFAULT '0',
`sticky` tinyint(1) NOT NULL DEFAULT '0',
`target_version` varchar(64) NOT NULL DEFAULT '',
`category_id` int(10) unsigned NOT NULL DEFAULT '1',
`due_date` int(10) unsigned NOT NULL DEFAULT '1',
`last_updated` int(10) unsigned NOT NULL DEFAULT '1',
`date_submitted` int(10) unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
KEY `sponsorship_total` (`sponsorship_total`),
KEY `fixed_in_version` (`fixed_in_version`),
KEY `status` (`status`),
KEY `project_id` (`project_id`)
)
However the old users and all projects are correctly importet but not the issues. The summary page does show some statistics. When i click there on a specific id (longest open issue) i get the following message:
Which i can confirm, that is column does not exists in the old tableAPPLICATION ERROR #401
Database query failed. Error received from database was #1054: Unknown column 'bugnote_id' in 'field list' for the query: SELECT id, title, diskfile, filename, filesize, file_type, date_added, user_id, bugnote_id
FROM mantis_bug_file_table
WHERE bug_id=?
ORDER BY date_added.
Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section.
old setup:
Mantis: 1.2.25 Schema: 89
target setup:
Mantis: 2.2.23 Schema: 210
Thanks for any advice on how to handle the (schema)-migration and resolve these issues