search

sismics / reader

Free and open source feeds reader, including all major Google Reader features
https://www.sismics.com/reader/
GNU General Public License v2.0
400 stars 98 forks source link

Errors on database upgrade #153

Closed jendib closed 7 years ago

jendib commented 7 years ago 

05 Jul 2017 19:31:11,983 INFO com.sismics.util.jpa.DbOpenHelper.open(DbOpenHelper.java:112) Found database version 5, new version is 6, executing database incremental update scripts
05 Jul 2017 19:31:11,989 INFO com.sismics.util.jpa.DbOpenHelper.executeAllScript(DbOpenHelper.java:167) Executing script: dbupdate-006-0.sql
05 Jul 2017 19:31:11,994 ERROR com.sismics.util.jpa.DbOpenHelper.executeScript(DbOpenHelper.java:201) Error executing SQL statement: {}create  index FK_ART_IDFEED_C on T_ARTICLE (
org.postgresql.util.PSQLException: ERROR: syntax error at end of input
  Position: 45
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288)
        at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430)
        at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356)
        at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:303)
        at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:289)
        at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:266)
        at org.postgresql.jdbc.PgStatement.executeUpdate(PgStatement.java:246)
        at com.sismics.util.jpa.DbOpenHelper.executeScript(DbOpenHelper.java:190)
        at com.sismics.util.jpa.DbOpenHelper.executeAllScript(DbOpenHelper.java:170)
        at com.sismics.util.jpa.EMF$1.onUpgrade(EMF.java:50)
        at com.sismics.util.jpa.DbOpenHelper.open(DbOpenHelper.java:113)```