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 :
Please help me in order to run clean upgrade of my system,
Thank you
Upgrade from 1.1.6 to 1.2.4
Moderators: Developer, Contributor
Re: Upgrade from 1.1.6 to 1.2.4
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.
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.
Re: Upgrade from 1.1.6 to 1.2.4
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 : but i get the results shown in this print screen : Thank you for your help
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 : but i get the results shown in this print screen : Thank you for your help
Re: Upgrade from 1.1.6 to 1.2.4
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
So one more turn:
Recover your database backup, change the value from 64 to 63, run admin/install.php
Re: Upgrade from 1.1.6 to 1.2.4
- 1- I recovered the batabase;
- 2- I updated the value by 63 instead of 64;
- 3- I called again the script (.../admin/install.php)
Should i Do something additional (recomendation...) after that step?
Thank you very mutch for your help,
Re: Upgrade from 1.1.6 to 1.2.4
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
Re: Upgrade from 1.1.6 to 1.2.4
The checking is a little bit to strict (seems to be from older versions when MantisBT had no bundled graph library )nabmed wrote:Should i add the path of jpgraph to "include_path" ?
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