Mantis upgrade from 1.2.19 to 2.4.0

General discussion of Mantis.

Moderators: Developer, Contributor

Post Reply
jacebeleran
Posts: 8
Joined: 12 Jun 2017, 04:13

Mantis upgrade from 1.2.19 to 2.4.0

Post 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?
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: Mantis upgrade from 1.2.19 to 2.4.0

Post 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)
Please use Search before posting and read the Manual
jacebeleran
Posts: 8
Joined: 12 Jun 2017, 04:13

Re: Mantis upgrade from 1.2.19 to 2.4.0

Post 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?
jacebeleran
Posts: 8
Joined: 12 Jun 2017, 04:13

Re: Mantis upgrade from 1.2.19 to 2.4.0

Post 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?
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: Mantis upgrade from 1.2.19 to 2.4.0

Post 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
Please use Search before posting and read the Manual
jacebeleran
Posts: 8
Joined: 12 Jun 2017, 04:13

Re: Mantis upgrade from 1.2.19 to 2.4.0

Post 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?
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: Mantis upgrade from 1.2.19 to 2.4.0

Post 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';
Please use Search before posting and read the Manual
jacebeleran
Posts: 8
Joined: 12 Jun 2017, 04:13

Re: Mantis upgrade from 1.2.19 to 2.4.0

Post 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
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: Mantis upgrade from 1.2.19 to 2.4.0

Post 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.
Please use Search before posting and read the Manual
jacebeleran
Posts: 8
Joined: 12 Jun 2017, 04:13

Re: Mantis upgrade from 1.2.19 to 2.4.0

Post 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
jacebeleran
Posts: 8
Joined: 12 Jun 2017, 04:13

Re: Mantis upgrade from 1.2.19 to 2.4.0

Post 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.
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: Mantis upgrade from 1.2.19 to 2.4.0

Post 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
Please use Search before posting and read the Manual
jacebeleran
Posts: 8
Joined: 12 Jun 2017, 04:13

Re: Mantis upgrade from 1.2.19 to 2.4.0

Post 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
Post Reply