java.sql.SQLException: Unknown column 'spacedescr0_.VERSIONCOMMENT' in 'field list'

Atlassian JIRA | Dave Loeng [Atlassian] | 1 decade ago
  1. 0

    For example, this error can be thrown during a 1.4.4 to 2.0 upgrade: 2005-11-17 04:03:00,068 ERROR [sf.hibernate.util.JDBCExceptionReporter] Unknown column 'spacedescr0_.VERSIONCOMMENT' in 'field list' 2005-11-17 04:03:00,068 ERROR [sf.hibernate.util.JDBCExceptionReporter] Unknown column 'spacedescr0_.VERSIONCOMMENT' in 'field list' 2005-11-17 04:03:00,069 ERROR [sf.hibernate.util.JDBCExceptionReporter] Unknown column 'spacedescr0_.VERSIONCOMMENT' in 'field list' 2005-11-17 04:03:00,069 ERROR [sf.hibernate.util.JDBCExceptionReporter] Unknown column 'spacedescr0_.VERSIONCOMMENT' in 'field list' 2005-11-17 04:03:00,072 ERROR [sf.hibernate.util.JDBCExceptionReporter] could not load: [com.atlassian.confluence.spaces.SpaceDescription#1] java.sql.SQLException: Unknown column 'spacedescr0_.VERSIONCOMMENT' in 'field list' at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2001) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1168) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279) at com.mysql.jdbc.Connection.execSQL(Connection.java:2281) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1634) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:75) at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:87) at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:875) at net.sf.hibernate.loader.Loader.doQuery(Loader.java:269) at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133) at net.sf.hibernate.loader.Loader.loadEntity(Loader.java:911) If the scheduled job responsible for polling mail accounts is started before Confluence has had a chance to upgrade the CONTENT table.

    Atlassian JIRA | 1 decade ago | Dave Loeng [Atlassian]
    java.sql.SQLException: Unknown column 'spacedescr0_.VERSIONCOMMENT' in 'field list'
  2. 0

    For example, this error can be thrown during a 1.4.4 to 2.0 upgrade: 2005-11-17 04:03:00,068 ERROR [sf.hibernate.util.JDBCExceptionReporter] Unknown column 'spacedescr0_.VERSIONCOMMENT' in 'field list' 2005-11-17 04:03:00,068 ERROR [sf.hibernate.util.JDBCExceptionReporter] Unknown column 'spacedescr0_.VERSIONCOMMENT' in 'field list' 2005-11-17 04:03:00,069 ERROR [sf.hibernate.util.JDBCExceptionReporter] Unknown column 'spacedescr0_.VERSIONCOMMENT' in 'field list' 2005-11-17 04:03:00,069 ERROR [sf.hibernate.util.JDBCExceptionReporter] Unknown column 'spacedescr0_.VERSIONCOMMENT' in 'field list' 2005-11-17 04:03:00,072 ERROR [sf.hibernate.util.JDBCExceptionReporter] could not load: [com.atlassian.confluence.spaces.SpaceDescription#1] java.sql.SQLException: Unknown column 'spacedescr0_.VERSIONCOMMENT' in 'field list' at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2001) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1168) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279) at com.mysql.jdbc.Connection.execSQL(Connection.java:2281) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1634) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:75) at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:87) at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:875) at net.sf.hibernate.loader.Loader.doQuery(Loader.java:269) at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133) at net.sf.hibernate.loader.Loader.loadEntity(Loader.java:911) If the scheduled job responsible for polling mail accounts is started before Confluence has had a chance to upgrade the CONTENT table.

    Atlassian JIRA | 1 decade ago | Dave Loeng [Atlassian]
    java.sql.SQLException: Unknown column 'spacedescr0_.VERSIONCOMMENT' in 'field list'
  3. 0

    What is causing a Hibernate SQL query exception?

    Stack Overflow | 6 years ago | Dark Star1
    java.lang.Exception: org.hibernate.exception.SQLGrammarException: could not execute query
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    i am getting Hibernate error

    Stack Overflow | 2 years ago | Raji
    org.hibernate.exception.SQLGrammarException: could not execute query

  1. Kialandei 1 times, last 2 weeks ago
  2. poroszd 1 times, last 1 year ago
11 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. java.sql.SQLException

    Unknown column 'spacedescr0_.VERSIONCOMMENT' in 'field list'

    at com.mysql.jdbc.MysqlIO.checkErrorPacket()
  2. MySQL jdbc
    PreparedStatement.executeQuery
    1. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2001)
    2. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1168)
    3. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)
    4. com.mysql.jdbc.Connection.execSQL(Connection.java:2281)
    5. com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1634)
    5 frames
  3. c3p0:JDBC DataSources/Resource Pools
    NewProxyPreparedStatement.executeQuery
    1. com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:75)
    1 frame
  4. net.sf.hibernate
    Loader.loadEntity
    1. net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:87)
    2. net.sf.hibernate.loader.Loader.getResultSet(Loader.java:875)
    3. net.sf.hibernate.loader.Loader.doQuery(Loader.java:269)
    4. net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
    5. net.sf.hibernate.loader.Loader.loadEntity(Loader.java:911)
    5 frames