MarioG1

Logblock Lb SUM 2

Mar 18th, 2015
732
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.58 KB | None | 0 0
  1. 2015-03-17 19:28:43 [INFO] MarioG1 issued server command: /lb sum plocks player MarioG1 area 30 since 30d
  2. 2015-03-17 19:28:51 [ERROR] [Lookup] SELECT playername, SUM(created) AS created, SUM(destroyed) AS destroyed FROM ((SELECT playerid, count(*) AS created, 0 AS destroyed FROM `lb-Builder` WHERE type != 0 AND type != replaced AND x >= -1111 AND x <= -1053 AND y >= 55 AND y <= 113 AND z >= -7746 AND z <= -7688 AND date > date_sub(now(), INTERVAL 43200 MINUTE) GROUP BY playerid) UNION (SELECT playerid, 0 AS created, count(*) AS destroyed FROM `lb-Builder` WHERE replaced != 0 AND type != replaced AND x >= -1111 AND x <= -1053 AND y >= 55 AND y <= 113 AND z >= -7746 AND z <= -7688 AND date > date_sub(now(), INTERVAL 43200 MINUTE) GROUP BY playerid)) AS t INNER JOIN `lb-players` USING (playerid) GROUP BY playerid ORDER BY SUM(created) + SUM(destroyed) DESC :
  3. java.sql.SQLException: Column 'UUID' not found.
  4. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) ~[spigot.jar:git-Spigot-8c3dd1f-ee6d0fa]
  5. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987) ~[spigot.jar:git-Spigot-8c3dd1f-ee6d0fa]
  6. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982) ~[spigot.jar:git-Spigot-8c3dd1f-ee6d0fa]
  7. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927) ~[spigot.jar:git-Spigot-8c3dd1f-ee6d0fa]
  8. at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1144) ~[spigot.jar:git-Spigot-8c3dd1f-ee6d0fa]
  9. at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5616) ~[spigot.jar:git-Spigot-8c3dd1f-ee6d0fa]
  10. at de.diddiz.LogBlock.Actor.<init>(Actor.java:49) ~[logblock-dev.jar:?]
  11. at de.diddiz.LogBlock.SummedBlockChanges.<init>(SummedBlockChanges.java:19) ~[logblock-dev.jar:?]
  12. at de.diddiz.LogBlock.LookupCacheElementFactory.getLookupCacheElement(LookupCacheElementFactory.java:28) ~[logblock-dev.jar:?]
  13. at de.diddiz.LogBlock.CommandsHandler$CommandLookup.run(CommandsHandler.java:425) [logblock-dev.jar:?]
  14. at org.bukkit.craftbukkit.v1_8_R1.scheduler.CraftTask.run(CraftTask.java:71) [spigot.jar:git-Spigot-8c3dd1f-ee6d0fa]
  15. at org.bukkit.craftbukkit.v1_8_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53) [spigot.jar:git-Spigot-8c3dd1f-ee6d0fa]
  16. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_40]
  17. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_40]
  18. at java.lang.Thread.run(Thread.java:745) [?:1.8.0_40]
  19.  
  20. 2015-03-17 19:09:09 [INFO] Bish_O issued server command: /lb sum players area 15 since 12:00:00
  21. 2015-03-17 19:09:10 [ERROR] [Lookup] SELECT playername, SUM(created) AS created, SUM(destroyed) AS destroyed FROM ((SELECT playerid, count(*) AS created, 0 AS destroyed FROM `lb-Builder` WHERE type != 0 AND type != replaced AND x in (-12640,-12639,-12638,-12637,-12636,-12635,-12634,-12633,-12632,-12631,-12630,-12629,-12628,-12627,-12626,-12625,-12624,-12623,-12622,-12621,-12620,-12619,-12618,-12617,-12616,-12615,-12614,-12613,-12612) AND y in (56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84) AND z in (6292,6293,6294,6295,6296,6297,6298,6299,6300,6301,6302,6303,6304,6305,6306,6307,6308,6309,6310,6311,6312,6313,6314,6315,6316,6317,6318,6319,6320) AND date > date_sub(now(), INTERVAL 429 MINUTE) GROUP BY playerid) UNION (SELECT playerid, 0 AS created, count(*) AS destroyed FROM `lb-Builder` WHERE replaced != 0 AND type != replaced AND x in (-12640,-12639,-12638,-12637,-12636,-12635,-12634,-12633,-12632,-12631,-12630,-12629,-12628,-12627,-12626,-12625,-12624,-12623,-12622,-12621,-12620,-12619,-12618,-12617,-12616,-12615,-12614,-12613,-12612) AND y in (56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84) AND z in (6292,6293,6294,6295,6296,6297,6298,6299,6300,6301,6302,6303,6304,6305,6306,6307,6308,6309,6310,6311,6312,6313,6314,6315,6316,6317,6318,6319,6320) AND date > date_sub(now(), INTERVAL 429 MINUTE) GROUP BY playerid)) AS t INNER JOIN `lb-players` USING (playerid) GROUP BY playerid ORDER BY SUM(created) + SUM(destroyed) DESC :
  22. java.sql.SQLException: Column 'UUID' not found.
  23. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) ~[spigot.jar:git-Spigot-8c3dd1f-ee6d0fa]
  24. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987) ~[spigot.jar:git-Spigot-8c3dd1f-ee6d0fa]
  25. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982) ~[spigot.jar:git-Spigot-8c3dd1f-ee6d0fa]
  26. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927) ~[spigot.jar:git-Spigot-8c3dd1f-ee6d0fa]
  27. at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1144) ~[spigot.jar:git-Spigot-8c3dd1f-ee6d0fa]
  28. at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5616) ~[spigot.jar:git-Spigot-8c3dd1f-ee6d0fa]
  29. at de.diddiz.LogBlock.Actor.<init>(Actor.java:49) ~[logblock-dev.jar:?]
  30. at de.diddiz.LogBlock.SummedBlockChanges.<init>(SummedBlockChanges.java:19) ~[logblock-dev.jar:?]
  31. at de.diddiz.LogBlock.LookupCacheElementFactory.getLookupCacheElement(LookupCacheElementFactory.java:28) ~[logblock-dev.jar:?]
  32. at de.diddiz.LogBlock.CommandsHandler$CommandLookup.run(CommandsHandler.java:425) [logblock-dev.jar:?]
  33. at org.bukkit.craftbukkit.v1_8_R1.scheduler.CraftTask.run(CraftTask.java:71) [spigot.jar:git-Spigot-8c3dd1f-ee6d0fa]
  34. at org.bukkit.craftbukkit.v1_8_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53) [spigot.jar:git-Spigot-8c3dd1f-ee6d0fa]
  35. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_40]
  36. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_40]
  37. at java.lang.Thread.run(Thread.java:745) [?:1.8.0_40]
Advertisement
Add Comment
Please, Sign In to add comment