org.postgresql.util.PSQLException: ERROR: syntax error at or near "AUTO_IN CREMENT" Position: 50

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

,
Expert tip

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>

Solutions on the web

via GitHub by warlockopy
, 1 year ago
ERROR: syntax error at or near "AUTO_IN CREMENT" Position: 50
via GitHub by MihaiBogdanEugen
, 2 years ago
ERROR: type &quot;double&quot; does not exist Position: 560
via Stack Overflow by Zsolt J&#225;nos
, 4 months ago
ERROR: syntax error at or near "$2" Position: 177
via stackexchange.com by Unknown author, 1 year ago
via Google Groups by Michael Paesold, 5 months ago
ERROR: syntax error at or near "$2"
via GitHub by jayp
, 2 years ago
ERROR: column "data" is of type json but expression is of type character varying Hint: You will need to rewrite or cast the expression. Position: 51
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.traccar.database.QueryBuilder.executeUpdate(QueryBuilder.java:412)
at org.traccar.database.DataManager.initDatabaseSchema(DataManager.java:181)
at org.traccar.database.DataManager.(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 java.lang.Thread.run(Thread.java:745)

Users with the same issue

37 times, 1 week ago
3 times, 1 month ago
Once, 2 months ago
Once, 2 months ago
32 times, 2 months ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.