MMBase

Virtual NODE type field, error during creation of table.

Details

  • Type: Bug Bug
  • Status: Resolved Resolved
  • Priority: Major Major
  • Resolution: Fixed
  • Affects Version/s: 1.7.0
  • Fix Version/s: 1.7.1
  • Component/s: Database Layer
  • Description:
    Hide
    original bugid: #6486
    11:22:23,583 ERR 18056 kb storage.implementation.database.DatabaseStorageManager create.1302 - java.sql.SQLException: ERROR: column "channel" does not exist

            at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131)
            at org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:505)
            at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:320)
            at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:48)
            at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:197)
            at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:183)
            at org.mmbase.module.database.MultiStatement.executeUpdate(MultiStatement.java:54)
            at org.mmbase.storage.implementation.database.DatabaseStorageManager.create(DatabaseStorageManager.java:1299)
            at org.mmbase.storage.implementation.database.JDBC2NodeWrapper.create(JDBC2NodeWrapper.java:214)
            at org.mmbase.module.core.MMObjectBuilder.create(MMObjectBuilder.java:427)



    It tries to create an index on this field, which it can't because it is virtual.
     if (
                        (field.getDBState() == FieldDefs.DBSTATE_PERSISTENT || field.getDBState() == FieldDefs.DBSTATE_SYSTEM) &&
    Show
    original bugid: #6486 11:22:23,583 ERR 18056 kb storage.implementation.database.DatabaseStorageManager create.1302 - java.sql.SQLException: ERROR: column "channel" does not exist         at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131)         at org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:505)         at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:320)         at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:48)         at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:197)         at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:183)         at org.mmbase.module.database.MultiStatement.executeUpdate(MultiStatement.java:54)         at org.mmbase.storage.implementation.database.DatabaseStorageManager.create(DatabaseStorageManager.java:1299)         at org.mmbase.storage.implementation.database.JDBC2NodeWrapper.create(JDBC2NodeWrapper.java:214)         at org.mmbase.module.core.MMObjectBuilder.create(MMObjectBuilder.java:427) It tries to create an index on this field, which it can't because it is virtual.  if (                     (field.getDBState() == FieldDefs.DBSTATE_PERSISTENT || field.getDBState() == FieldDefs.DBSTATE_SYSTEM) &&

Activity

There are no subversion log entries for this issue yet.

People

Dates

  • Created:
    2004-06-02 11:37
    Updated:
    2006-11-24 13:41
    Resolved:
    2006-11-24 13:41