Page 1 of 1

Mantis upgrade from 1.2.19 to 2.4.0

Posted: 12 Jun 2017, 04:21
by jacebeleran
Good day.
I have an old server with mantis 1.2.19. i created new virtual server with windows 2012. installed MySQL ver 5.5, PHP ver 7.1.1, IIS. Installed mantis ver 2.4.0. How can i export and import my old mantis DB. please can you give me manual instruction?

Re: Mantis upgrade from 1.2.19 to 2.4.0

Posted: 12 Jun 2017, 05:56
by atrol
jacebeleran wrote:Installed mantis
Do not install a new Mantis, you have to uprade by following these steps
See viewtopic.php?f=3&t=24636&p=62034&hilit=export#p62034
jacebeleran wrote:PHP ver 7.1.1
Not a good one, use latest 7.0.x or latest 7.1.x
jacebeleran wrote:mantis ver 2.4.0.
Not a good one, use 2.4.2 (do not use latest 2.5.0)

Re: Mantis upgrade from 1.2.19 to 2.4.0

Posted: 12 Jun 2017, 06:41
by jacebeleran
1. i export my old database with this:mysqldump -u root -p --max_allowed_p
acket=10000M mantis_128 > mantisexport.sql
2. Then import my DB to new server:mysql -u root -p mantisbt < mantisexport.sql
3. what should i do next?

Re: Mantis upgrade from 1.2.19 to 2.4.0

Posted: 12 Jun 2017, 07:15
by jacebeleran
ok .
1. i export my current DB with command: mysqldump -u root -p --max_allowed_p
acket=10000M mantis_128 > mantisexport.sql

2. Then i import my DB into new server: mysql -u root -p mantisbt < mantisexport.sql

3. then i put new release of mantis int C:\inetpub\wwwroot\Mantis and run c:\localhost/mantis/admin/install.php

4. all seems good, but when i logged into mantis i didnt see my data and tasks and so on.

What should i do now?

Re: Mantis upgrade from 1.2.19 to 2.4.0

Posted: 12 Jun 2017, 09:37
by atrol
Maybe you missed step 3 "Copy the configuration files" before running install.php, seehttps://www.mantisbt.org/docs/master/en-US/Admi ... ll.upgrade
After copying config_inc.php to folder config, you have to adjust the database options in it.

You might have two databases at the moment:
- a new installation, but empty
- your old database, not upgraded

Re: Mantis upgrade from 1.2.19 to 2.4.0

Posted: 12 Jun 2017, 09:44
by jacebeleran
Now it says: Checking PHP support for database type BAD
database is not supported by PHP. Check that it has been compiled into your server

What should i do now?

Re: Mantis upgrade from 1.2.19 to 2.4.0

Posted: 12 Jun 2017, 09:59
by atrol
I assume you have set

Code: Select all

$g_db_type				= 'mysql';
If so, change it to

Code: Select all

$g_db_type				= 'mysqli';

Re: Mantis upgrade from 1.2.19 to 2.4.0

Posted: 12 Jun 2017, 10:04
by jacebeleran
thanks, changed to mysqli.
now it says:
Checking there is no 'config_inc.php' file in 1.2.x location. BAD
Move config_inc.php to config/config_inc.php.

where should i put config? i put config from my old mantis to C:\inetpub\wwwroot\mantis\config

Re: Mantis upgrade from 1.2.19 to 2.4.0

Posted: 12 Jun 2017, 10:26
by atrol
It seems there are two config_inc.php.
You should remove the one under C:\inetpub\wwwroot\mantis.
Keep the one in config subfolder.

Re: Mantis upgrade from 1.2.19 to 2.4.0

Posted: 12 Jun 2017, 10:29
by jacebeleran
yes i already did it, but now is there another bad news(

Schema step 195: UpdateFunction ( stored_filter_migrate ) BAD

i tryed to delete all values from mantis_filters_table as man told here https://www.mantisbt.org/bugs/view.php?id=21376, but it didnt help

Re: Mantis upgrade from 1.2.19 to 2.4.0

Posted: 12 Jun 2017, 11:11
by jacebeleran
Ok, im totally drop this table, and now it says:
APPLICATION ERROR #2900

For security reasons MantisBT will not operate when $g_crypto_master_salt is not specified correctly in config_inc.php or is shorter than 16 characters long.

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.

Re: Mantis upgrade from 1.2.19 to 2.4.0

Posted: 12 Jun 2017, 11:26
by atrol
jacebeleran wrote:Ok, im totally drop this table
Really drop? You will get problems at a later time. You should just delete all data from the table.

Concerning $g_crypto_master_salt:
Add a line to file config_inc.php which sets $g_crypto_master_salt according the rules from https://www.mantisbt.org/docs/master/en ... g.security

Re: Mantis upgrade from 1.2.19 to 2.4.0

Posted: 12 Jun 2017, 12:04
by jacebeleran
Thanks, i did as you said. delete all data from table but not drop it. Then add $g_crypto_master_salt into config file. and it upgaded without erorrs.
i need to check it for errors. if something wrong ill write