org.postgresql.util.PSQLException

ERROR: syntax error at or near "AUTO_IN CREMENT" Position: 50

Samebug tips1

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: <postgresql.version>9.4.1211</postgresql.version>

Don't give up yet. Our experts can help. Paste your full stack trace to get a solution.

Solutions on the web3097

  • via GitHub by warlockopy
    , 1 year ago
    ERROR: syntax error at or near "AUTO_IN CREMENT" Position: 50
  • via Stack Overflow by Unknown author, 1 year ago
    ERROR: syntax error at or near "." Position: 27 at
  • ERROR: syntax error at or near "asc" Position: 677
  • Stack trace

    • org.postgresql.util.PSQLException: ERROR: syntax error at or near "AUTO_IN CREMENT" Position: 50 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:420) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:366) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:410) at org.traccar.database.QueryBuilder.executeUpdate(QueryBuilder.java:412) at org.traccar.database.DataManager.initDatabaseSchema(DataManager.java:181) at org.traccar.database.DataManager.<init>(DataManager.java:64) at org.traccar.Context.init(Context.java:98) at org.traccar.Main.main(Main.java:26) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:325) at java.lang.Thread.run(Thread.java:745)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Once, 4 hours ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    2 times, 1 month ago
    25 times, 7 months ago
    93 more bugmates