API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Aug 21st, 2014
23
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.65 KB | None | 0 0
raw download clone embed print report
  1. [jcastro@chunk HyperConomy]$ more errors.log
  2.  
  3.  
  4. HyperConomy[0.974.56], CraftBukkit[git-Spigot-1604 (MC: 1.7.10)], [2014-08-21 10:49:31.41]
  5. SQL write failed 1 time(s). The failing SQL statement is in the following brackets:
  6. [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]
  7. java.sql.SQLException: Field 'ID' doesn't have a default value
  8. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
  9. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
  10. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
  11. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
  12. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
  13. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
  14. at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
  15. at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2407)
  16. at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2325)
  17. at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2310)
  18. at regalowl.hyperconomy.databukkit.sql.DatabaseConnection.write(DatabaseConnection.java:43)
  19. at regalowl.hyperconomy.databukkit.sql.SyncSQLWrite.writeQueue(SyncSQLWrite.java:30)
  20. at regalowl.hyperconomy.util.DatabaseUpdater.updateTables(DatabaseUpdater.java:378)
  21. at regalowl.hyperconomy.DataManager$1.run(DataManager.java:90)
  22. at org.bukkit.craftbukkit.v1_7_R4.scheduler.CraftTask.run(CraftTask.java:71)
  23. at org.bukkit.craftbukkit.v1_7_R4.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53)
  24. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  25. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  26. at java.lang.Thread.run(Thread.java:745)
  27.  
  28.  
  29.  
  30.  
  31. HyperConomy[0.974.56], CraftBukkit[git-Spigot-1604 (MC: 1.7.10)], [2014-08-21 10:49:31.435]
  32. SQL write failed 1 time(s). The failing SQL statement is in the following brackets:
  33. [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
  34. 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
  35. L, P2X DOUBLE NOT NULL, P2Y DOUBLE NOT NULL, P2Z DOUBLE NOT NULL)]
  36. com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: BLOB/TEXT column 'USE_ECONOMY_STOCK' can't have a default value
  37. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  38. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  39. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  40. at java.lang.reflect.Constructor.newInstance(Constructor.java:408)
  41. at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
  42. at com.mysql.jdbc.Util.getInstance(Util.java:382)
  43. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
  44. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
  45. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
  46. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
  47. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
  48. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
  49. at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
  50. at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2407)
  51. at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2325)
  52. at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2310)
  53. at regalowl.hyperconomy.databukkit.sql.DatabaseConnection.write(DatabaseConnection.java:43)
  54. at regalowl.hyperconomy.databukkit.sql.SyncSQLWrite.writeQueue(SyncSQLWrite.java:30)
  55. at regalowl.hyperconomy.util.DatabaseUpdater.updateTables(DatabaseUpdater.java:387)
  56. at regalowl.hyperconomy.DataManager$1.run(DataManager.java:90)
  57. at org.bukkit.craftbukkit.v1_7_R4.scheduler.CraftTask.run(CraftTask.java:71)
  58. at org.bukkit.craftbukkit.v1_7_R4.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53)
  59. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  60. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  61. at java.lang.Thread.run(Thread.java:745)
  62.  
  63.  
  64.  
  65.  
  66. HyperConomy[0.974.56], CraftBukkit[git-Spigot-1604 (MC: 1.7.10)], [2014-08-21 10:49:31.436]
  67. SQL write failed 1 time(s). The failing SQL statement is in the following brackets:
  68. [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
  69. _OBJECTS, ALLOWED_PLAYERS, P1X, P1Y, P1Z, P2X, P2Y, P2Z FROM hyperconomy_shops]
  70. com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'hyperconomy.hyperconomy_shops_temp' doesn't exist
  71. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  72. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  73. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  74. at java.lang.reflect.Constructor.newInstance(Constructor.java:408)
  75. at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
  76. at com.mysql.jdbc.Util.getInstance(Util.java:382)
  77. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
  78. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
  79. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
  80. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
  81. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
  82. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
  83. at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
  84. at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2407)
  85. at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2325)
  86. at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2310)
  87. at regalowl.hyperconomy.databukkit.sql.DatabaseConnection.write(DatabaseConnection.java:43)
  88. at regalowl.hyperconomy.databukkit.sql.SyncSQLWrite.writeQueue(SyncSQLWrite.java:30)
  89. at regalowl.hyperconomy.util.DatabaseUpdater.updateTables(DatabaseUpdater.java:391)
  90. at regalowl.hyperconomy.DataManager$1.run(DataManager.java:90)
  91. at org.bukkit.craftbukkit.v1_7_R4.scheduler.CraftTask.run(CraftTask.java:71)
  92. at org.bukkit.craftbukkit.v1_7_R4.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53)
  93. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  94. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  95. at java.lang.Thread.run(Thread.java:745)
  96.  
  97.  
  98.  
  99.  
  100. HyperConomy[0.974.56], CraftBukkit[git-Spigot-1604 (MC: 1.7.10)], [2014-08-21 10:49:31.437]
  101. SQL write failed 1 time(s). The failing SQL statement is in the following brackets:
  102. [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
  103. CTS, ALLOWED_PLAYERS, P1X, P1Y, P1Z, P2X, P2Y, P2Z FROM hyperconomy_shops_temp]
  104. com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'hyperconomy.hyperconomy_shops_temp' doesn't exist
  105. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  106. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  107. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  108. at java.lang.reflect.Constructor.newInstance(Constructor.java:408)
  109. at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
  110. at com.mysql.jdbc.Util.getInstance(Util.java:382)
  111. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
  112. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
  113. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
  114. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
  115. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
  116. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
  117. at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
  118. at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2407)
  119. at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2325)
  120. at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2310)
  121. at regalowl.hyperconomy.databukkit.sql.DatabaseConnection.write(DatabaseConnection.java:43)
  122. at regalowl.hyperconomy.databukkit.sql.SyncSQLWrite.writeQueue(SyncSQLWrite.java:30)
  123. at regalowl.hyperconomy.util.DatabaseUpdater.updateTables(DatabaseUpdater.java:400)
  124. at regalowl.hyperconomy.DataManager$1.run(DataManager.java:90)
  125. at org.bukkit.craftbukkit.v1_7_R4.scheduler.CraftTask.run(CraftTask.java:71)
  126. at org.bukkit.craftbukkit.v1_7_R4.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53)
  127. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  128. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  129. at java.lang.Thread.run(Thread.java:745)
  130.  
  131.  
  132.  
  133.  
  134. HyperConomy[0.974.56], CraftBukkit[git-Spigot-1604 (MC: 1.7.10)], [2014-08-21 10:49:33.105]
  135. java.lang.NullPointerException
  136. at regalowl.hyperconomy.HyperShopManager.loadData(HyperShopManager.java:52)
  137. at regalowl.hyperconomy.DataManager$1.run(DataManager.java:102)
  138. at org.bukkit.craftbukkit.v1_7_R4.scheduler.CraftTask.run(CraftTask.java:71)
  139. at org.bukkit.craftbukkit.v1_7_R4.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53)
  140. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  141. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  142. at java.lang.Thread.run(Thread.java:745)
  143.  
  144.  
  145. [jcastro@chunk HyperConomy]$
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!