-
Type:
Bug
-
Resolution: Fixed
-
Priority:
High
-
Affects Version/s: 4.0.1
-
Component/s: Import / Export [Deprecated]
-
4
Update
Update: we now have two importers, one for FogBugz Server and one for FogBugz OnDemand. The latest documentation is at Migrating from Other Issue Trackers.
Import from Fogbugz 7.x fails with the following error.
2009-12-07 12:44:42,282 Thread-57 ERROR lewisd 45881x1022x1 g2exvv http://jira4.mindbrix.com/secure/admin/views/FogBugzImport!import.jspa [web.action.util.DatabaseConnectionBean] SQL Exception accessing data. com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'bDeleted' in 'field list' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:532) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2077) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2228) at com.atlassian.jira.web.action.util.DatabaseConnectionBean.queryDb(DatabaseConnectionBean.java:276) at com.atlassian.jira.web.action.util.DatabaseConnectionBean.queryDb(DatabaseConnectionBean.java:260) at com.atlassian.jira.imports.fogbugz.FogBugzDataBean.getVersions(FogBugzDataBean.java:56) at com.atlassian.jira.imports.importer.impl.DefaultJiraDataImporter.importVersions(DefaultJiraDataImporter.java:371) at com.atlassian.jira.imports.importer.impl.DefaultJiraDataImporter.doImport(DefaultJiraDataImporter.java:127) at com.atlassian.jira.imports.importer.impl.ImporterThread.run(ImporterThread.java:21)
The problem is caused by the database schema change introduced in the 7.0 release of Fogbugz. Basically, the bDeleted column doesn't exist any longer.
FixFor in Fogbugz 7.0
mysql> describe FixFor; +------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+--------------+------+-----+---------+----------------+ | ixFixFor | int(11) | NO | PRI | NULL | auto_increment | | sFixFor | varchar(255) | YES | | NULL | | | dt | datetime | YES | | NULL | | | fDeleted | int(11) | YES | | 0 | | | ixProject | int(11) | YES | | 0 | | | fInactive | smallint(6) | YES | | 0 | | | dtStart | datetime | YES | | NULL | | | sStartNote | varchar(255) | YES | | NULL | | +------------+--------------+------+-----+---------+----------------+ 8 rows in set (0.00 sec)
and the same for the 6.1.x release
COLUMN_NAME TYPE_NAME LENGTH IS_NULLABLE ixFixFor int identity 4 NO sFixFor nvarchar 510 YES dt datetime 16 YES bDeleted int 4 YES ixProject int 4 YES
