Upgrade from 1.1.6 to 1.2.4

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
nabmed
Posts: 6
Joined: 17 Jan 2011, 17:57

Upgrade from 1.1.6 to 1.2.4

Post by 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
forumMantis.png (43.46 KiB) Viewed 20705 times
Please help me in order to run clean upgrade of my system,

Thank you
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: Upgrade from 1.1.6 to 1.2.4

Post by 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.
Please use Search before posting and read the Manual
nabmed
Posts: 6
Joined: 17 Jan 2011, 17:57

Re: Upgrade from 1.1.6 to 1.2.4

Post by 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
What I did
forumMantis1.png (20.04 KiB) Viewed 20695 times
but i get the results shown in this print screen :
What i get
What i get
forumMantis.png (43.46 KiB) Viewed 20695 times
Thank you for your help
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: Upgrade from 1.1.6 to 1.2.4

Post by 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
Please use Search before posting and read the Manual
nabmed
Posts: 6
Joined: 17 Jan 2011, 17:57

Re: Upgrade from 1.1.6 to 1.2.4

Post by 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) :
Image

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

Thank you very mutch for your help,
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: Upgrade from 1.1.6 to 1.2.4

Post by atrol »

nabmed wrote: Should i Do something additional (recomendation...) after that step?
Run admin/check.php
Please use Search before posting and read the Manual
nabmed
Posts: 6
Joined: 17 Jan 2011, 17:57

Re: Upgrade from 1.1.6 to 1.2.4

Post by nabmed »

I Run the check script and i get this results :( :
Image
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: Upgrade from 1.1.6 to 1.2.4

Post by atrol »

Please use Search before posting and read the Manual
nabmed
Posts: 6
Joined: 17 Jan 2011, 17:57

Re: Upgrade from 1.1.6 to 1.2.4

Post by 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
check.png (22.17 KiB) Viewed 20683 times
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: Upgrade from 1.1.6 to 1.2.4

Post by atrol »

nabmed wrote: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
Please use Search before posting and read the Manual
nabmed
Posts: 6
Joined: 17 Jan 2011, 17:57

Re: Upgrade from 1.1.6 to 1.2.4

Post by nabmed »

thank you for All
Post Reply