· 9 years ago · Oct 03, 2016, 11:52 AM
1try {
2 logger.debug("Trying to create table powerperms_permissions if not exists");
3 statement.execute("CREATE TABLE IF NOT EXISTS powerperms_permissions ( "
4 + "id INT NOT NULL AUTOINCREMENT,"
5 + "uuid VARCHAR ( 64 ) NOT NULL,"
6 + "permission VARCHAR ( 64 ) NOT NULL,"
7 + "world VARCHAR ( 32 ) NULL,"
8 + "PRIMARY KEY ( id ) );");
9 } catch (SQLException e) {
10 logger.error("Couldn't create permissions table",e);
11 }
12
13[07:49:17 ERROR]: [PowerPerms] Couldn't create permissions table
14java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (near "AUTOINCREMENT": syntax error)
15 at org.sqlite.DB.newSQLException(DB.java:383) ~[spigot-1.10.jar:git-Spigot-6016ac7-10c10b3]
16 at org.sqlite.DB.newSQLException(DB.java:387) ~[spigot-1.10.jar:git-Spigot-6016ac7-10c10b3]
17 at org.sqlite.DB.throwex(DB.java:374) ~[spigot-1.10.jar:git-Spigot-6016ac7-10c10b3]
18 at org.sqlite.NativeDB.prepare(Native Method) ~[spigot-1.10.jar:git-Spigot-6016ac7-10c10b3]
19 at org.sqlite.DB.prepare(DB.java:123) ~[spigot-1.10.jar:git-Spigot-6016ac7-10c10b3]
20 at org.sqlite.Stmt.execute(Stmt.java:113) ~[spigot-1.10.jar:git-Spigot-6016ac7-10c10b3]
21 at eu.taigacraft.powerperms.Main.registerSqlite(Main.java:240) [PowerPerms_v1.0.jar:?]
22 at eu.taigacraft.powerperms.Main$2.run(Main.java:48) [PowerPerms_v1.0.jar:?]
23 at org.bukkit.craftbukkit.v1_10_R1.scheduler.CraftTask.run(CraftTask.java:71) [spigot-1.10.jar:git-Spigot-6016ac7-10c10b3]
24 at org.bukkit.craftbukkit.v1_10_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53) [spigot-1.10.jar:git-Spigot-6016ac7-10c10b3]
25 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_72]
26 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_72]
27 at java.lang.Thread.run(Thread.java:745) [?:1.8.0_72]