Issue Details (XML | Word | Printable)

Key: JRA-8721
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Dylan Etkin [Atlassian]
Reporter: Brian Nguyen
Votes: 2
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
JIRA

Mantis Importer ignores projects with id = 1

Created: 05/Dec/05 09:34 PM   Updated: 30/Jul/06 07:37 PM
Component/s: Import / Export
Affects Version/s: None
Fix Version/s: 3.4.3

Time Tracking:
Not Specified

Participants: Brian Nguyen, Dylan Etkin [Atlassian] and Rob Kearey
Since last comment: 2 years, 40 weeks, 3 days ago
Resolution Date: 28/Dec/05 07:27 PM
Labels:


 Description  « Hide
Previously this parameter was added to overcome the problem with a separator added in as a project. We need to investigate if this is still the case.

-------------- From Email -----------------
This is for anyone having issues importing from Mantis. I was trying to import several projects using the built in importer but one of my Mantis projects wasn't showing up in the list of projects (my first and most important one). Looking at the importer code there was a simple query to search for projects but for some reason it explicitly ignored project id #1. (Perhaps for some historical reason). Anyway, if you are having a problem with your first Mantis project, just change this line in the importer:

PreparedStatement preparedStatement = connectionBean.getConnection().prepareStatement("select * from mantis_project_table where id <> 1");

and remove "where id <> 1".

Rebuild with this updated class and the problem goes away.



 All   Comments   Work Log   Change History      Sort Order: Ascending order - Click to sort in descending order
Rob Kearey added a comment - 08/Dec/05 05:36 PM
Excellent timing - this is biting us right now. Is there a quick fix for the Jira standalone, or do I need to play with maven etc?

Brian Nguyen added a comment - 09/Dec/05 02:02 AM
HI Rob,

If you want to change this you will need to edit the source unfortunately.

But if you tell us what version you are using I can upload a patch for you.

Thanks,
Brian


Dylan Etkin [Atlassian] added a comment - 28/Dec/05 07:27 PM
It seems that mantis no longer uses the project with id=1 as a separator. If you are running an older version of mantis, then this fix will just create a bogus project with the name of the separator which you should delete. With more modern versions of mantis, you will no longer have the first project ignored.

In the process of this fix, I also made another fix which seems to effect importing into a non-mysql db, the datatype for stepId was being set in the generic value as a string, it should be an integer and now is.