Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [jcastro@chunk HyperConomy]$ more errors.log
- HyperConomy[0.974.56], CraftBukkit[git-Spigot-1604 (MC: 1.7.10)], [2014-08-21 10:49:31.41]
- SQL write failed 1 time(s). The failing SQL statement is in the following brackets:
- [INSERT INTO hyperconomy_players_temp (NAME, UUID, ECONOMY, BALANCE, X, Y, Z, WORLD, HASH, SALT) SELECT NAME, UUID, ECONOMY, BALANCE, X, Y, Z, WORLD, HASH, SALT FROM hyperconomy_players]
- java.sql.SQLException: Field 'ID' doesn't have a default value
- at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
- at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
- at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
- at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
- at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
- at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
- at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
- at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2407)
- at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2325)
- at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2310)
- at regalowl.hyperconomy.databukkit.sql.DatabaseConnection.write(DatabaseConnection.java:43)
- at regalowl.hyperconomy.databukkit.sql.SyncSQLWrite.writeQueue(SyncSQLWrite.java:30)
- at regalowl.hyperconomy.util.DatabaseUpdater.updateTables(DatabaseUpdater.java:378)
- at regalowl.hyperconomy.DataManager$1.run(DataManager.java:90)
- at org.bukkit.craftbukkit.v1_7_R4.scheduler.CraftTask.run(CraftTask.java:71)
- at org.bukkit.craftbukkit.v1_7_R4.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
- at java.lang.Thread.run(Thread.java:745)
- HyperConomy[0.974.56], CraftBukkit[git-Spigot-1604 (MC: 1.7.10)], [2014-08-21 10:49:31.435]
- SQL write failed 1 time(s). The failing SQL statement is in the following brackets:
- [CREATE TABLE IF NOT EXISTS hyperconomy_shops_temp (NAME VARCHAR(100) NOT NULL PRIMARY KEY, TYPE VARCHAR(255) NOT NULL, ECONOMY VARCHAR(255) NOT NULL, OWNER VARCHAR(255) NOT NULL, WORLD VARCHAR(255) NO
- T NULL, USE_ECONOMY_STOCK TINYTEXT NOT NULL DEFAULT '1', MESSAGE TEXT NOT NULL, BANNED_OBJECTS TEXT NOT NULL, ALLOWED_PLAYERS TEXT NOT NULL, P1X DOUBLE NOT NULL, P1Y DOUBLE NOT NULL, P1Z DOUBLE NOT NUL
- L, P2X DOUBLE NOT NULL, P2Y DOUBLE NOT NULL, P2Z DOUBLE NOT NULL)]
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: BLOB/TEXT column 'USE_ECONOMY_STOCK' can't have a default value
- at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
- at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
- at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
- at java.lang.reflect.Constructor.newInstance(Constructor.java:408)
- at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
- at com.mysql.jdbc.Util.getInstance(Util.java:382)
- at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
- at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
- at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
- at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
- at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
- at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
- at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
- at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2407)
- at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2325)
- at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2310)
- at regalowl.hyperconomy.databukkit.sql.DatabaseConnection.write(DatabaseConnection.java:43)
- at regalowl.hyperconomy.databukkit.sql.SyncSQLWrite.writeQueue(SyncSQLWrite.java:30)
- at regalowl.hyperconomy.util.DatabaseUpdater.updateTables(DatabaseUpdater.java:387)
- at regalowl.hyperconomy.DataManager$1.run(DataManager.java:90)
- at org.bukkit.craftbukkit.v1_7_R4.scheduler.CraftTask.run(CraftTask.java:71)
- at org.bukkit.craftbukkit.v1_7_R4.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
- at java.lang.Thread.run(Thread.java:745)
- HyperConomy[0.974.56], CraftBukkit[git-Spigot-1604 (MC: 1.7.10)], [2014-08-21 10:49:31.436]
- SQL write failed 1 time(s). The failing SQL statement is in the following brackets:
- [INSERT INTO hyperconomy_shops_temp (NAME, TYPE, ECONOMY, OWNER, WORLD, MESSAGE, BANNED_OBJECTS, ALLOWED_PLAYERS, P1X, P1Y, P1Z, P2X, P2Y, P2Z) SELECT NAME, TYPE, ECONOMY, OWNER, WORLD, MESSAGE, BANNED
- _OBJECTS, ALLOWED_PLAYERS, P1X, P1Y, P1Z, P2X, P2Y, P2Z FROM hyperconomy_shops]
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'hyperconomy.hyperconomy_shops_temp' doesn't exist
- at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
- at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
- at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
- at java.lang.reflect.Constructor.newInstance(Constructor.java:408)
- at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
- at com.mysql.jdbc.Util.getInstance(Util.java:382)
- at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
- at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
- at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
- at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
- at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
- at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
- at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
- at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2407)
- at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2325)
- at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2310)
- at regalowl.hyperconomy.databukkit.sql.DatabaseConnection.write(DatabaseConnection.java:43)
- at regalowl.hyperconomy.databukkit.sql.SyncSQLWrite.writeQueue(SyncSQLWrite.java:30)
- at regalowl.hyperconomy.util.DatabaseUpdater.updateTables(DatabaseUpdater.java:391)
- at regalowl.hyperconomy.DataManager$1.run(DataManager.java:90)
- at org.bukkit.craftbukkit.v1_7_R4.scheduler.CraftTask.run(CraftTask.java:71)
- at org.bukkit.craftbukkit.v1_7_R4.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
- at java.lang.Thread.run(Thread.java:745)
- HyperConomy[0.974.56], CraftBukkit[git-Spigot-1604 (MC: 1.7.10)], [2014-08-21 10:49:31.437]
- SQL write failed 1 time(s). The failing SQL statement is in the following brackets:
- [INSERT INTO hyperconomy_shops (NAME, TYPE, ECONOMY, OWNER, WORLD, MESSAGE, BANNED_OBJECTS, ALLOWED_PLAYERS, P1X, P1Y, P1Z, P2X, P2Y, P2Z) SELECT NAME, TYPE, ECONOMY, OWNER, WORLD, MESSAGE, BANNED_OBJE
- CTS, ALLOWED_PLAYERS, P1X, P1Y, P1Z, P2X, P2Y, P2Z FROM hyperconomy_shops_temp]
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'hyperconomy.hyperconomy_shops_temp' doesn't exist
- at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
- at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
- at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
- at java.lang.reflect.Constructor.newInstance(Constructor.java:408)
- at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
- at com.mysql.jdbc.Util.getInstance(Util.java:382)
- at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
- at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
- at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
- at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
- at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
- at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
- at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
- at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2407)
- at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2325)
- at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2310)
- at regalowl.hyperconomy.databukkit.sql.DatabaseConnection.write(DatabaseConnection.java:43)
- at regalowl.hyperconomy.databukkit.sql.SyncSQLWrite.writeQueue(SyncSQLWrite.java:30)
- at regalowl.hyperconomy.util.DatabaseUpdater.updateTables(DatabaseUpdater.java:400)
- at regalowl.hyperconomy.DataManager$1.run(DataManager.java:90)
- at org.bukkit.craftbukkit.v1_7_R4.scheduler.CraftTask.run(CraftTask.java:71)
- at org.bukkit.craftbukkit.v1_7_R4.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
- at java.lang.Thread.run(Thread.java:745)
- HyperConomy[0.974.56], CraftBukkit[git-Spigot-1604 (MC: 1.7.10)], [2014-08-21 10:49:33.105]
- java.lang.NullPointerException
- at regalowl.hyperconomy.HyperShopManager.loadData(HyperShopManager.java:52)
- at regalowl.hyperconomy.DataManager$1.run(DataManager.java:102)
- at org.bukkit.craftbukkit.v1_7_R4.scheduler.CraftTask.run(CraftTask.java:71)
- at org.bukkit.craftbukkit.v1_7_R4.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
- at java.lang.Thread.run(Thread.java:745)
- [jcastro@chunk HyperConomy]$
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement