Upgrade from 1.1.1 to 1.2.4

[plass.rom]

Ok thanks anyway.

[atrol]

Is there any data in table mantis_category_table after you restored your original 1.1.1 dump?

[plass.rom]

Yes there is 427 rows in the table as well as in my production server in 1.1.1.

[atrol]

I checked again one of my 1.1.x installations (1.1.6)
There is no mantis_category_table

The structure of this table in version 1.2.x is

Code: Select all

id int(10)             
project_id int(10)             
user_id int(10)               
name varchar(128)             
status int(10)

Is this the same in your database?

[plass.rom]

Yes it is exactly the same. We are just using plugins, that's the only difference from a stock install.

[atrol]

This is the latest version of the 1.1.x code which creates/updates the database schema
http://git.mantisbt.org/?p=mantisbt.git ... ster-1.1.x
There is no mantis_category_table

This table has been introduced in a very early state of 1.2.x developing.

It's not possible that you have a version 1.1.x which is able to fill the mantis_category_table.

Have a look at file admin/schema.php of your 1.1.x installation.
There should be no mantis_category_table

[plass.rom]

Ok, I haven't problems to believe you, but even if I drop the mantis_category_table before the upgrade I still have the following error :

Échec de la requête de base de données. L'erreur renvoyée par la base de données était #1062 : Duplicate entry '114-Demande de développement' for key 2 pour la requête : INSERT INTO mantis_category_table ( name, project_id, user_id ) VALUES ( ?, ?, ? ).

[atrol]

Have a look at
http://www.mantisbt.org/bugs/view.php?id=11416
Especially the note of user ngombe might be a hint for your problem

[plass.rom]

So my mysql version could be the problem as I'm running the 5.0.77 version and my production server is in 5.0.32.

I'll try to reinstall mysql with an earlierversion and will keep you informed.

Thanks a lot for your support.

[atrol]

I'll try to reinstall mysql with an earlierversion and will keep you informed.

I wouldn't do that, because I don't think that the older version is able to deal better with UTF-8 than the newer one.
Why not try what ngombe wrote?

Code: Select all

As we speak french here I simply modified the mantis_category_table DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs, then the upgrade worked !


[plass.rom]

Sorry I meant a newer version. I already tried to change all my tables in UTF8 without any success.

[Liandella]

Hello,
I am using Latest Mantis - 1.2.3, PHP-5.2.13,
I just tried to install Plugin cell phone spy software manager as instructed, I copied all the files from the zip into mantis directory and browsed the plugins manager link but it says plugin version - 0.3.0 but I copied all the files from 0.4.0 folder.
Also, As per one of the post, I saw my SQL tables
1. mantis_plugins_pm_dependencies_table - empty
2. mantis_plugins_pm_function_overwrite_table - empty
3. mantis_plugins_pm_list_table - 1 record which has pluginmanager
How should i proceed further. Also how to use the package format to install the plugins using FTP

[atrol]

I am using Latest Mantis - 1.2.3,

Latest stable MantisBT is 1.2.8 at the moment
http://www.mantisbt.org/download.php

I just tried to install Plugin manager

This is a 3rd party development which is is not compatible with version 1.2.x of MantisBT.

[myrjan]

Hello. I am trying to upgrade to 1.2.10 and gets exactly the same error. I have spent hours reading this forum but no help. I have tried to upgrade on two different servers and gets the same error every time..

BAD
CREATE TABLE mantis_plugin_table ( basename VARCHAR(40) NOT NULL, enabled TINYINT NOT NULL DEFAULT '0', PRIMARY KEY (basename) )ENGINE=MyISAM DEFAULT CHARSET=utf8
Table 'mantis_plugin_table' already exists

What to do?