Mantis upgrade from 1.2.19 to 2.4.0

General discussion of Mantis.

Moderators: Contributor, Developer

Mantis upgrade from 1.2.19 to 2.4.0

Postby jacebeleran » Jun 11, 2017 11:21 pm

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?
jacebeleran
 
Posts: 8
Joined: Jun 11, 2017 11:13 pm

Re: Mantis upgrade from 1.2.19 to 2.4.0

Postby atrol » Jun 12, 2017 12:56 am

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
Use Mantis2Go to try MantisBT on Windows or to reproduce issues
atrol
Site Admin
 
Posts: 6603
Joined: Mar 26, 2008 4:37 pm
Location: Germany

Re: Mantis upgrade from 1.2.19 to 2.4.0

Postby jacebeleran » Jun 12, 2017 1:41 am

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: Jun 11, 2017 11:13 pm

Re: Mantis upgrade from 1.2.19 to 2.4.0

Postby jacebeleran » Jun 12, 2017 2:15 am

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?
jacebeleran
 
Posts: 8
Joined: Jun 11, 2017 11:13 pm

Re: Mantis upgrade from 1.2.19 to 2.4.0

Postby atrol » Jun 12, 2017 4:37 am

Maybe you missed step 3 "Copy the configuration files" before running install.php, seehttps://www.mantisbt.org/docs/master ... 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
Use Mantis2Go to try MantisBT on Windows or to reproduce issues
atrol
Site Admin
 
Posts: 6603
Joined: Mar 26, 2008 4:37 pm
Location: Germany

Re: Mantis upgrade from 1.2.19 to 2.4.0

Postby jacebeleran » Jun 12, 2017 4:44 am

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?
jacebeleran
 
Posts: 8
Joined: Jun 11, 2017 11:13 pm

Re: Mantis upgrade from 1.2.19 to 2.4.0

Postby atrol » Jun 12, 2017 4:59 am

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
Use Mantis2Go to try MantisBT on Windows or to reproduce issues
atrol
Site Admin
 
Posts: 6603
Joined: Mar 26, 2008 4:37 pm
Location: Germany

Re: Mantis upgrade from 1.2.19 to 2.4.0

Postby jacebeleran » Jun 12, 2017 5:04 am

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
jacebeleran
 
Posts: 8
Joined: Jun 11, 2017 11:13 pm

Re: Mantis upgrade from 1.2.19 to 2.4.0

Postby atrol » Jun 12, 2017 5:26 am

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
Use Mantis2Go to try MantisBT on Windows or to reproduce issues
atrol
Site Admin
 
Posts: 6603
Joined: Mar 26, 2008 4:37 pm
Location: Germany

Re: Mantis upgrade from 1.2.19 to 2.4.0

Postby jacebeleran » Jun 12, 2017 5:29 am

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: Jun 11, 2017 11:13 pm

Re: Mantis upgrade from 1.2.19 to 2.4.0

Postby jacebeleran » Jun 12, 2017 6:11 am

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.
jacebeleran
 
Posts: 8
Joined: Jun 11, 2017 11:13 pm

Re: Mantis upgrade from 1.2.19 to 2.4.0

Postby atrol » Jun 12, 2017 6:26 am

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
Use Mantis2Go to try MantisBT on Windows or to reproduce issues
atrol
Site Admin
 
Posts: 6603
Joined: Mar 26, 2008 4:37 pm
Location: Germany

Re: Mantis upgrade from 1.2.19 to 2.4.0

Postby jacebeleran » Jun 12, 2017 7:04 am

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
jacebeleran
 
Posts: 8
Joined: Jun 11, 2017 11:13 pm


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 10 guests

cron