org.h2.jdbc.JdbcSQLException: Column "X21.ALLOW_WIKI_EDITING" not found; SQL statement: CREATE FORCE VIEW PUBLIC._1 AS SELECT X21.UPDATED_DATE AS X22, X21.ALLOW_WIKI_EDITING AS X23, X21.EXTERNAL_ISSUES_URL AS X24, X21.PARENT_REPOSITORY_NAME AS X25, X21.EXTERNAL_WIKI_URL AS X26, X21.DEFAULT_BRANCH AS X27, X21.DESCRIPTION AS X28, X21.ORIGIN_REPOSITORY_NAME AS X29, X21.ORIGIN_USER_NAME AS X30, X21.PARENT_USER_NAME AS X31, X21.PRIVATE AS X32, X21.REPOSITORY_NAME AS X33, X21.USER_NAME AS X34, X21.ENABLE_WIKI AS X35, X21.ENABLE_ISSUES AS X36, X21.REGISTERED_DATE AS X37, X21.LAST_ACTIVITY_DATE AS X38 FROM PUBLIC.REPOSITORY X21 [42122-192]

GitHub | uli-heller | 11 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    4.2: Database migration seems to fail for non-empty database - Column "X21.ALLOW_WIKI_EDITING" not found

    GitHub | 11 months ago | uli-heller
    org.h2.jdbc.JdbcSQLException: Column "X21.ALLOW_WIKI_EDITING" not found; SQL statement: CREATE FORCE VIEW PUBLIC._1 AS SELECT X21.UPDATED_DATE AS X22, X21.ALLOW_WIKI_EDITING AS X23, X21.EXTERNAL_ISSUES_URL AS X24, X21.PARENT_REPOSITORY_NAME AS X25, X21.EXTERNAL_WIKI_URL AS X26, X21.DEFAULT_BRANCH AS X27, X21.DESCRIPTION AS X28, X21.ORIGIN_REPOSITORY_NAME AS X29, X21.ORIGIN_USER_NAME AS X30, X21.PARENT_USER_NAME AS X31, X21.PRIVATE AS X32, X21.REPOSITORY_NAME AS X33, X21.USER_NAME AS X34, X21.ENABLE_WIKI AS X35, X21.ENABLE_ISSUES AS X36, X21.REGISTERED_DATE AS X37, X21.LAST_ACTIVITY_DATE AS X38 FROM PUBLIC.REPOSITORY X21 [42122-192]
  2. 0

    playframework JPA.em().merge(this)

    Stack Overflow | 3 years ago | masterdany88
    org.h2.jdbc.JdbcSQLException: Kolumna "MEDICALINC0_._EBEAN_INTERCEPT" nie istnieje Column "MEDICALINC0_._EBEAN_INTERCEPT" not found; SQL statement: select medicalinc0_.id as id1_0_0_, medicalinc0_._ebean_intercept as _ebean_i2_0_0_, medicalinc0_.age as age3_0_0_, medicalinc0_.incident_type as incident4_0_0_, medicalinc0_.month as month5_0_0_, medicalinc0_.place as place6_0_0_, medicalinc0_.unit as unit7_0_0_ from MedicalIncident medicalinc0_ where medicalinc0_.id=? [42122-172]
  3. 0

    playframework JPA.em().merge(this); SQLGrammarException

    Stack Overflow | 3 years ago | masterdany88
    org.h2.jdbc.JdbcSQLException: Kolumna "MEDICALINC0_._EBEAN_INTERCEPT" nie istnieje Column "MEDICALINC0_._EBEAN_INTERCEPT" not found; SQL statement: select medicalinc0_.id as id1_0_0_, medicalinc0_._ebean_intercept as _ebean_i2_0_0_, medicalinc0_.age as age3_0_0_, medicalinc0_.incident_type as incident4_0_0_, medicalinc0_.month as month5_0_0_, medicalinc0_.place as place6_0_0_, medicalinc0_.unit as unit7_0_0_ from MedicalIncident medicalinc0_ where medicalinc0_.id=? [42122-172]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Missing information in Ebean-Stacktrace

    Stack Overflow | 5 years ago | niels
    org.h2.jdbc.JdbcSQLException: Feld "BYLOGINNAME" nicht gefunden Column "BYLOGINNAME" not found; SQL statement: select t0.id c0, t0.loginname c1, t0.email_address c2, t0.lastname c3, t0.firstname c4, t0.description c5, t0.enabled c6, t0.login_failed_count c7, t0.expired_date c8, t0.password c9, t0.last_update c10 from psec_user t0 where byLoginname = ? [42122-158]
  6. 0

    Invalid SQL generated on inner query from GroupBy

    GitHub | 3 years ago | fzakaria
    PUBLIC.PRIMARY_KEY_5: "id" = X158."ideaId" _/ ON 1=1 WHERE (X158."voterId" = 21) AND ((X157."deleted" = FALSE) AND (X158."ideaId" = X157."id")) ORDER BY 9 DESC ) X141 WHERE X141.X148 = X106.X104 [42122-172]]]

    Root Cause Analysis

    1. org.h2.jdbc.JdbcSQLException

      Column "X21.ALLOW_WIKI_EDITING" not found; SQL statement: CREATE FORCE VIEW PUBLIC._1 AS SELECT X21.UPDATED_DATE AS X22, X21.ALLOW_WIKI_EDITING AS X23, X21.EXTERNAL_ISSUES_URL AS X24, X21.PARENT_REPOSITORY_NAME AS X25, X21.EXTERNAL_WIKI_URL AS X26, X21.DEFAULT_BRANCH AS X27, X21.DESCRIPTION AS X28, X21.ORIGIN_REPOSITORY_NAME AS X29, X21.ORIGIN_USER_NAME AS X30, X21.PARENT_USER_NAME AS X31, X21.PRIVATE AS X32, X21.REPOSITORY_NAME AS X33, X21.USER_NAME AS X34, X21.ENABLE_WIKI AS X35, X21.ENABLE_ISSUES AS X36, X21.REGISTERED_DATE AS X37, X21.LAST_ACTIVITY_DATE AS X38 FROM PUBLIC.REPOSITORY X21 [42122-192]

      at org.h2.message.DbException.getJdbcSQLException()
    2. H2 Database Engine
      Select.prepare
      1. org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
      2. org.h2.message.DbException.get(DbException.java:179)
      3. org.h2.message.DbException.get(DbException.java:155)
      4. org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:147)
      5. org.h2.expression.Alias.optimize(Alias.java:51)
      6. org.h2.command.dml.Select.prepare(Select.java:852)
      6 frames