SQLITE_ERROR - SQL error or missing database (near "AUTOINCREMENT": syntax error)

Question

I'm trying to create a table in my newly created SQLite database. For some reason I'm getting an SQLException:

try {
        logger.debug("Trying to create table powerperms_permissions if not exists");
        statement.execute("CREATE TABLE IF NOT EXISTS powerperms_permissions ( "
                + "id INT NOT NULL AUTOINCREMENT,"
                + "uuid VARCHAR ( 64 ) NOT NULL,"
                + "permission VARCHAR ( 64 ) NOT NULL,"
                + "world VARCHAR ( 32 ) NULL,"
                + "PRIMARY KEY ( id ) );");
    } catch (SQLException e) {
        logger.error("Couldn't create permissions table",e);
    }

throws

[07:49:17 ERROR]: [PowerPerms] Couldn't create permissions table
java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (near "AUTOINCREMENT": syntax error)
    at org.sqlite.DB.newSQLException(DB.java:383) ~[spigot-1.10.jar:git-Spigot-6016ac7-10c10b3]
    at org.sqlite.DB.newSQLException(DB.java:387) ~[spigot-1.10.jar:git-Spigot-6016ac7-10c10b3]
    at org.sqlite.DB.throwex(DB.java:374) ~[spigot-1.10.jar:git-Spigot-6016ac7-10c10b3]
    at org.sqlite.NativeDB.prepare(Native Method) ~[spigot-1.10.jar:git-Spigot-6016ac7-10c10b3]
    at org.sqlite.DB.prepare(DB.java:123) ~[spigot-1.10.jar:git-Spigot-6016ac7-10c10b3]
    at org.sqlite.Stmt.execute(Stmt.java:113) ~[spigot-1.10.jar:git-Spigot-6016ac7-10c10b3]
    at eu.taigacraft.powerperms.Main.registerSqlite(Main.java:240) [PowerPerms_v1.0.jar:?]
    at eu.taigacraft.powerperms.Main$2.run(Main.java:48) [PowerPerms_v1.0.jar:?]
    at org.bukkit.craftbukkit.v1_10_R1.scheduler.CraftTask.run(CraftTask.java:71) [spigot-1.10.jar:git-Spigot-6016ac7-10c10b3]
    at org.bukkit.craftbukkit.v1_10_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53) [spigot-1.10.jar:git-Spigot-6016ac7-10c10b3]
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_72]
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_72]
    at java.lang.Thread.run(Thread.java:745) [?:1.8.0_72]

Why?

laalto · Accepted Answer · 2016-10-03 11:51:42Z

10

You can use the AUTOINCREMENT keyword only with INTEGER PRIMARY KEY, not INT NOT NULL.

answered Oct 3, 2016 at 11:51

laalto

153k68 gold badges293 silver badges306 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vax Okagbare · Accepted Answer · 2018-05-18 19:33:55Z

0

Ensure the primary key comes before the auto_increment then it will work

answered May 18, 2018 at 19:33

Vax Okagbare

811 silver badge2 bronze badges

Comments

KwstasMost · Accepted Answer · 2016-10-03 11:53:55Z

-2

There must be a database, auto increment is spelled like AUTO_INCREMENT and not null may affect your code depending on your dbms

answered Oct 3, 2016 at 11:53

KwstasMost

1301 silver badge10 bronze badges

1 Comment

J R Over a year ago

this answer does not apply to SQLITE, it would e.g. apply to MySQL

Collectives™ on Stack Overflow

SQLITE_ERROR - SQL error or missing database (near "AUTOINCREMENT": syntax error)

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related