com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'bDeleted' in 'field list'

Atlassian JIRA | Bogdan Dziedzic [Atlassian] | 7 years ago
  1. 0

    {panel:title=Update|borderStyle=solid|borderColor=#3C78B5| titleBGColor=#3C78B5| bgColor=#E7F4FA} 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|http://confluence.atlassian.com/display/JIRA/Migrating+from+Other+Issue+Trackers]. {panel} \\ Import from Fogbugz 7.x fails with the following error. {noformat} 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) {noformat} 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 {noformat} 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) {noformat} and the same for the 6.1.x release {noformat} 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 {noformat}

    Atlassian JIRA | 7 years ago | Bogdan Dziedzic [Atlassian]
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'bDeleted' in 'field list'
  2. 0

    {panel:title=Update|borderStyle=solid|borderColor=#3C78B5| titleBGColor=#3C78B5| bgColor=#E7F4FA} 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|http://confluence.atlassian.com/display/JIRA/Migrating+from+Other+Issue+Trackers]. {panel} \\ Import from Fogbugz 7.x fails with the following error. {noformat} 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) {noformat} 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 {noformat} 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) {noformat} and the same for the 6.1.x release {noformat} 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 {noformat}

    Atlassian JIRA | 7 years ago | Bogdan Dziedzic [Atlassian]
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'bDeleted' in 'field list'
  3. 0

    GitHub comment 12#161541759

    GitHub | 1 year ago | GoogleCodeExporter
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Spring 4.3.0.RELEASE + Hibernate 5.2.0.Final - GeneratedValue on mysql

    Stack Overflow | 5 months ago | Guyb
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'searcherdb.hibernate_sequence' doesn't exist
  6. 0

    Reindex problem when admin portlets in Italian language

    GitHub | 2 years ago | linuxatico
    com.dotmarketing.exception.DotRuntimeException: Could not execute query

  1. Kialandei 1 times, last 2 weeks ago
  2. davidvanlaatum 8 times, last 2 months ago
  3. AndrewProg 2 times, last 3 months ago
  4. kuldeep 2 times, last 3 months ago
  5. tvrmsmith 1 times, last 4 months ago
27 more registered users
64 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException

    Unknown column 'bDeleted' in 'field list'

    at sun.reflect.NativeConstructorAccessorImpl.newInstance0()
  2. Java RT
    Constructor.newInstance
    1. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2. sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    3. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    4. java.lang.reflect.Constructor.newInstance(Constructor.java:532)
    4 frames
  3. MySQL jdbc
    PreparedStatement.executeQuery
    1. com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
    2. com.mysql.jdbc.Util.getInstance(Util.java:381)
    3. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
    4. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
    5. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558)
    6. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490)
    7. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
    8. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109)
    9. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)
    10. com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2077)
    11. com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2228)
    11 frames
  4. com.atlassian.jira
    ImporterThread.run
    1. com.atlassian.jira.web.action.util.DatabaseConnectionBean.queryDb(DatabaseConnectionBean.java:276)
    2. com.atlassian.jira.web.action.util.DatabaseConnectionBean.queryDb(DatabaseConnectionBean.java:260)
    3. com.atlassian.jira.imports.fogbugz.FogBugzDataBean.getVersions(FogBugzDataBean.java:56)
    4. com.atlassian.jira.imports.importer.impl.DefaultJiraDataImporter.importVersions(DefaultJiraDataImporter.java:371)
    5. com.atlassian.jira.imports.importer.impl.DefaultJiraDataImporter.doImport(DefaultJiraDataImporter.java:127)
    6. com.atlassian.jira.imports.importer.impl.ImporterThread.run(ImporterThread.java:21)
    6 frames