Migration depuis Mantis 1.2.0a1 : Table 'mantis.mantis_project_category_table' doesn't exist

Added by Jean-Michel André about 11 years ago

Hi there,
I'm trying to migrate my issues from mantis to redmine with migrate_from_mantis.rake (cool to have it :)).
My mantis version is 1.2.0a1

I've got error:

 
rake aborted!
Mysql::Error: #42S02Table 'mantis.mantis_project_category_table' doesn't exist: SELECT * FROM `mantis_project_category_table`     WHERE (`mantis_project_category_table`.project_id = 1)

Indeed, I haven't table "mantis_project_category_table" in my mantis db, but a "mantis_category_table" table.

I tried to substitue the names but I have this error:

rake aborted!
undefined method `category' for #<MantisMigrate::MantisCategory:0x2b10e8d5b258>

Someone could help?

(Translated, edited, textilized by Thomas LECAVELIER)

Replies (9)

RE: Migration depuis Mantis 1.2.0a1 : Table 'mantis.mantis_project_category_table' doesn't exist - Added by Jean-Michel André about 11 years ago

oops ... sorry for my post in french. I have been abused by my french interface.
Can't edit my original post.

RE: Migration depuis Mantis 1.2.0a1 : Table 'mantis.mantis_project_category_table' doesn't exist - Added by Thomas Lecavelier about 11 years ago

You want to migrate a pre-release mantis? :) Are you sure you have such issues to migrate? Joke apart, mantis site is not very user friendly, and I havn't seen informations on db modifications between 1.1.X and 1.2.X. Could you look for it please?

RE: Migration depuis Mantis 1.2.0a1 : Table 'mantis.mantis_project_category_table' doesn't exist - Added by Jean-Michel André about 11 years ago

Thanks, Thomas. Yes, I chose this prerelease because I have used previous versions of Mantis before and I expected some improvements. As you can see I am not fully satisfied and after a quick tour I decided to migrate to Redmine. I have only 90 issues in this project so far with 5 users, ... but it would be very "cool" if I could migrate these issues into Redmine.

By the way, don't be to severe with Mantis. They have been pionneers in web-based bug tracking systems, they have done a really good job, and they can still compete with the best tools (including Redmine).

The change log of Mantis 1.2.0a1 doesn't say much (http://www.mantisbt.org/bugs/changelog_page.php). In the "admin" directory which is used to install Mantis, they change the packaging of the installation files. In 1.1.x they used a db_table_names_inc.php file for the table's names. Now (in 1.2.0a1) the schema is in a file named schema.php and the table names (as well as fiel names) are hard coded.

I'm afraid I have to investigate further myself if I wish to find a migration path. If somebody here has already done the job ... I welcome all advices !

RE: Migration depuis Mantis 1.2.0a1 : Table 'mantis.mantis_project_category_table' doesn't exist - Added by Jean-Michel André about 11 years ago

I have found a workaround : I have commented all lines related to categories in the migration script and it worked like that.
As I wished to refine my categories anyway, it is not a great lost.
A more annoying issue : all strings with accents have been truncated during the import. I have left the "uft-8" param for the migration but it was not the good choice probably. :(

RE: Migration depuis Mantis 1.2.0a1 : Table 'mantis.mantis_project_category_table' doesn't exist - Added by Jean-Michel André about 11 years ago

Après avoir à nouveau vidé les tables de Redmine (issues, users, ...), j'ai relancé le script avec latin1 comme encodage et cette fois les anomalies et les users ont été correctement transférés (sans les catégories). Merci beaucoup pour ce script !

RE: Migration depuis Mantis 1.2.0a1 : Table 'mantis.mantis_project_category_table' doesn't exist - Added by Jean-Michel André about 11 years ago

Oops ... again in french ... sorry.
I said : I emptied the Redmine tables again and re-launched the migration script and set "latin1" as mantis DB encoding. And it worked well. :)

RE: Migration depuis Mantis 1.2.0a1 : Table 'mantis.mantis_project_category_table' doesn't exist - Added by Louis Antoine over 9 years ago

Hello,

For those who (like me) would be interested in importing a Mantis 1.2.0rc1 database into Redmine without tearing their hair out, here is a very simple howto:

http://www.webismymind.be/page/fr/17/migrate-mantis-120rc1-to-redmine.html

RE: Migration depuis Mantis 1.2.0a1 : Table 'mantis.mantis_project_category_table' doesn't exist - Added by Sebastien Tagg about 7 years ago

I can't believe I'm posting to a four-year-old forum post, but there doesn't seem to be very many posts on this subject :(

I'm trying to import Mantis 1.2.2 (stable), and I get the error in the first post above.

The script from webismymind.be doesn't work at all, it doesn't look like it has been updated in a very long time.

Does anyone know of an updated migrate script that actually works?

RE: Migration depuis Mantis 1.2.0a1 : Table 'mantis.mantis_project_category_table' doesn't exist - Added by Viral Patel over 5 years ago

Follow the steps on webismymind.be website where the link is posted above and run the below migration script. It will work. Post the errors here if you get any.

(1-9/9)