Upgrade from 1.1.6 to 1.2.4

[nabmed]

Hello,

I tried to upgrade from 1.1.6 to 1.2.4 and i followed this tutorial http://www.mantisbt.org/manual/manual.i ... rading.php but i get the error message bellow in the step (Schema InsertData ( mantis_plugin_table) ) :

BAD
INSERT INTO mantis_plugin_table ( basename, enabled ) VALUES ( 'MantisCoreFormatting', '1' )
Table 'jobadm_db.mantis_plugin_table' doesn't exist

after all the following sucessefull tests :

Setting Database Hostname GOOD
Setting Database Type GOOD
Checking PHP support for database type GOOD
Setting Database Username GOOD
Setting Database Password GOOD
Setting Database Name GOOD
Setting Admin Username GOOD
Setting Admin Password GOOD
Attempting to connect to database as admin GOOD
Attempting to connect to database as user GOOD
Checking Database Server Version
Running mysql version 5.1.36-community-log GOOD
Installing Database
Create database if it does not exist GOOD
Checking Database Server Version
Running mysql version 5.1.36-community-log GOOD
Attempting to connect to database as user GOOD
Schema CreateTableSQL ( mantis_category_table ) GOOD
Schema CreateIndexSQL ( idx_category_project_name ) GOOD
Schema InsertData ( mantis_category_table ) GOOD
Schema AddColumnSQL ( mantis_bug_table ) GOOD
Schema UpdateFunction ( category_migrate ) GOOD
Schema DropColumnSQL ( mantis_bug_table ) GOOD
Schema DropTableSQL ( mantis_project_category_table ) GOOD
Schema AddColumnSQL ( mantis_project_table ) GOOD
Schema CreateIndexSQL ( idx_project_id ) GOOD
Schema CreateIndexSQL ( idx_config ) GOOD

See the screen shot in attachement :

forumMantis.png (43.46 KiB) Viewed 1608 times

Please help me in order to run clean upgrade of my system,

Thank you

[atrol]

The link you mentioned is from version 1.1.x of MantisBT
I don't think that there are a lot of differences, but have also a look at file doc/INSTALL of your version 1.2.4

I recommend the following steps
- recover your database backup (I hope you did a backup)
- have a look at column value of table mantis_config_table where config_id = 'database_version'
- come back here and tell the value (should be 63 if you are running a clean 1.1.6 installation)

If the value is 63 you can try another run of admin/install.php
Do NOT enable the checkbox "Print SQL Queries instead of Writing to the Database", there are known issues when using it.

[nabmed]

Hello,
Yes i backed up the dtabase and the web pages

There is one row in the mantis_config_table and this is its fields and its content :

config_id = database_version
project_id = 0
user_id = 0
access_reqd = 90
type = 1
value = 64


I recovered the database, then i Run the upgrade page as described in INTALL file (...admin/install.php), I didn't used the check box (Print SQl queries instead of writing to Database ) as shown in this print screen :

What I did

forumMantis1.png (20.04 KiB) Viewed 1598 times

but i get the results shown in this print screen :

What i get

forumMantis.png (43.46 KiB) Viewed 1598 times

Thank you for your help

[atrol]

I have no idea why the value in the table is 64, this should be 63
So one more turn:
Recover your database backup, change the value from 64 to 63, run admin/install.php

[nabmed]

• 1- I recovered the batabase;
• 2- I updated the value by 63 instead of 64;
• 3- I called again the script (.../admin/install.php)

And i get as result the web page i made pdf in this file (i used 4shared to upload the result page in pdf file because it's not possible to upload many pictures) :


Should i Do something additional (recomendation...) after that step?

Thank you very mutch for your help,

[atrol]

Should i Do something additional (recomendation...) after that step?

Run admin/check.php

[nabmed]

I Run the check script and i get this results :

[atrol]

Not that bad
viewtopic.php?f=3&t=10029

[nabmed]

Thank you for all your help and sharing,

• I changed the collation of tables using the sql statment from the topin you gived me above,
• I changed the php pload_max_filesize value in php.ini

Still the "bad" line (checking we can find jpgraph class files...) shown in the print screen bellow, Should i add the path of jpgraph to "include_path" ?

check.png (22.17 KiB) Viewed 1586 times

[atrol]

Should i add the path of jpgraph to "include_path" ?

The checking is a little bit to strict (seems to be from older versions when MantisBT had no bundled graph library )
You have to add the path if you want to use the Mantis Graphs plugin and you do not want to use the bundled graph library.
Or you can copy your JpGraph to <yourMantisInstallation>/library
There is also a plugin configuration option "JpGraph library system path" but don't try this as there is a known bug when using this setting

[nabmed]

thank you for All