Page 2 of 2
Re: Upgrade from 1.1.1 to 1.2.4
Posted: 21 Apr 2011, 11:54
by plass.rom
Ok thanks anyway.
Re: Upgrade from 1.1.1 to 1.2.4
Posted: 21 Apr 2011, 12:00
by atrol
Is there any data in table mantis_category_table after you restored your original 1.1.1 dump?
Re: Upgrade from 1.1.1 to 1.2.4
Posted: 21 Apr 2011, 12:06
by plass.rom
Yes there is 427 rows in the table as well as in my production server in 1.1.1.
Re: Upgrade from 1.1.1 to 1.2.4
Posted: 21 Apr 2011, 12:35
by 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?
Re: Upgrade from 1.1.1 to 1.2.4
Posted: 21 Apr 2011, 12:38
by plass.rom
Yes it is exactly the same. We are just using plugins, that's the only difference from a stock install.
Re: Upgrade from 1.1.1 to 1.2.4
Posted: 21 Apr 2011, 12:54
by 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
Re: Upgrade from 1.1.1 to 1.2.4
Posted: 21 Apr 2011, 12:59
by 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 ( ?, ?, ? ).
Re: Upgrade from 1.1.1 to 1.2.4
Posted: 21 Apr 2011, 13:53
by 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
Re: Upgrade from 1.1.1 to 1.2.4
Posted: 21 Apr 2011, 13:59
by 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.
Re: Upgrade from 1.1.1 to 1.2.4
Posted: 21 Apr 2011, 14:16
by atrol
plass.rom wrote:
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 !
Re: Upgrade from 1.1.1 to 1.2.4
Posted: 21 Apr 2011, 14:18
by plass.rom
Sorry I meant a newer version. I already tried to change all my tables in UTF8 without any success.
Re: Upgrade from 1.1.1 to 1.2.4
Posted: 26 Sep 2011, 11:05
by 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
Re: Upgrade from 1.1.1 to 1.2.4
Posted: 26 Sep 2011, 11:42
by atrol
Liandella wrote:
I am using Latest Mantis - 1.2.3,
Latest stable MantisBT is 1.2.8 at the moment
http://www.mantisbt.org/download.php
Liandella wrote:
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.
Re: Upgrade from 1.1.1 to 1.2.4
Posted: 26 Apr 2012, 13:43
by 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?