SQL Exception :/

[TheCahyag]

Well I know this is probly the 10th time you have seen one of these errors and I don't mean to be a bother, but I need some help with logblocks. I've been getting two different errors from what I've been seeing. One is the "Queue overload" and one other is "SQL Exception" and like I said I'm pretty sure you've heard of these kind of things all the time, but I've looked at many different sources and nothing seams to work.

Two Errors messages -

2012-05-27 18:38:48 [SEVERE] [LogBlock Consumer] SQL exception on INSERT INTO lb-Spawn Design 2 (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1338158231), 838, 54, 54, 0, '300284', 71, '249169');:
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'x' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3591)
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:2620)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:779)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:622)
at de.diddiz.LogBlock.Consumer.run(Consumer.java:292)
at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)

at java.lang.Thread.run(Unknown Source)

2012-05-26 12:37:03 [INFO] [LogBlock Consumer] Queue overloaded. Size: 80125
2012-05-26 12:37:03 [SEVERE] [LogBlock Consumer] SQL exception on INSERT INTO lb-Spawn Design 2 (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1338003420), 21, 10, 49, 0, '5834799', 10, '4642869');:
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'x' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3591)
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:2620)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:779)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:622)
at de.diddiz.LogBlock.Consumer.run(Consumer.java:292)
at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)

at java.lang.Thread.run(Unknown Source)

(and yes that is quite an excessive queue)

I'm positive that im connect to the Mysql on my Wampserver.

Common info -
Basic Computer Specs
-AMD Phenom II X4 Processor 3.60 Ghz
-16 gb DDR3 running at 1600Mhz
-64 bit os
-Inter-graded ATI Radeon HD 4250
Im running the Wampserver and the Minecraft server on the same computer.
Running Two Displays (21" (1440x900) + 18" (1080x720))

*Computer Runs Fine Just the writing speed with the Mysql that needs some help :/.

Any Help would be most appreciable!

[TheCahyag]

Oh yes and here is my edited Config-

tools:
tool:
defaultEnabled: true
mode: LOOKUP
aliases:
- t
params: area 0 all sum none limit 15 desc silent
leftClickBehavior: NONE
item: 270
rightClickBehavior: TOOL
permissionDefault: 'TRUE'
canDrop: true
toolblock:
params: area 0 all sum none limit 15 desc silent
permissionDefault: 'TRUE'
rightClickBehavior: BLOCK
item: 7
mode: LOOKUP
defaultEnabled: true
aliases:
- tb
leftClickBehavior: TOOL
canDrop: false
mysql:
user: root
port: ****
host: localhost
database: logblock
password: ****
logging:
hiddenBlocks:

• 0
  logCreeperExplosionsAsPlayerWhoTriggeredThese: false
  logPlayerInfo: true
  hiddenPlayers: []
  logKillsLevel: PLAYERS
  consumer:
  timePerRun: 1000
  useBukkitScheduler: true
  forceToProcessAtLeast: 100
  delayBetweenRuns: 6
  lookup:
  linesLimit: 1500
  defaultTime: 1 day
  defaultDist: 20
  linesPerPage: 15
  questioner:
  askClearLogs: true
  banPermission: mcbans.ban.local
  askRollbacks: true
  askRedos: true
  askClearLogAfterRollback: false
  askRollbackAfterBan: false
  updater:
  checkVersion: true
  installSpout: true
  loggedWorlds:
  • Spawn Design 2
    clearlog:
    enableAutoClearLog: false
    auto:
• world "world" before 365 days all
• world "world" player lavaflow waterflow leavesdecay before 7 days all
• world world_nether before 365 days all
• world world_nether player lavaflow before 7 days all
  dumpDeletedLog: false
  autoClearLogDelay: 6h
  rollback:
  replaceAnyway:
• 8
• 9
• 10
• 11
• 51
  maxArea: 50
  dontRollback:
• 46
• 51
  maxTime: 15 days
  version: '1.52'

[md-5]

https://github.com/DiddiZ/LogBlock/wiki/FAQ
Read that page.