Bukkit

What steps will reproduce the problem?
1. set logTypes to mysql
2. fill mysql section in config
3. run server

What is the expected output? What do you see instead?
16:16:08 [WARNING] [LogOres]  Could not load build number from JAR
16:16:08 [INFO] [LogOres] using WEPIF permissions
16:16:08 [INFO] [LogOres] MySQL-Connection established
16:16:08 [SEVERE] [LogOres] 'CREATE TABLE `logores_log`' failed
16:16:08 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`z` MEDIUMINT unsigned NOT ,`light` TINYINT NOT NULL,`world` varchar(50) NOT NUL' at line 1
16:16:08 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
16:16:08 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
16:16:08 [SEVERE]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
16:16:08 [SEVERE]     at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
16:16:08 [SEVERE]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
16:16:08 [SEVERE]     at com.mysql.jdbc.Util.getInstance(Util.java:382)
16:16:08 [SEVERE]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
16:16:08 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
16:16:08 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
16:16:08 [SEVERE]     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
16:16:08 [SEVERE]     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
16:16:08 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
16:16:08 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
16:16:08 [SEVERE]     at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:779)
16:16:08 [SEVERE]     at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:622)
16:16:08 [SEVERE]     at org.morganm.logores.Logger.DatabaseLogger.init(DatabaseLogger.java:50)
16:16:08 [SEVERE]     at org.morganm.logores.LogEventProcessor.reloadConfig(LogEventProcessor.java:121)
16:16:08 [SEVERE]     at org.morganm.logores.LogOresPlugin.onEnable(LogOresPlugin.java:134)
16:16:08 [SEVERE]     at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:188)
16:16:08 [SEVERE]     at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:968)
16:16:08 [SEVERE]     at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:280)
16:16:08 [SEVERE]     at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:186)
16:16:08 [SEVERE]     at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:169)
16:16:08 [SEVERE]     at net.minecraft.server.MinecraftServer.t(MinecraftServer.java:348)
16:16:08 [SEVERE]     at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:335)
16:16:08 [SEVERE]     at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:165)
16:16:08 [SEVERE]     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:399)
16:16:08 [SEVERE]     at net.minecraft.server.ThreadServerApplication.run(SourceFile:457)
16:16:08 [INFO] [LogOres]version 0.9, build -1 is enabled

What version of the product are you using?
0.9

Do you have an error log of what happened?

Please provide any additional information below.

The table creation code is wrong. Use this here instead:

CREATE TABLE IF NOT EXISTS `logores_log` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `date` datetime NOT NULL,
  `username` varchar(50) NOT NULL,
  `ore` varchar(50) NOT NULL,
  `x` mediumint(8) unsigned NOT NULL,
  `y` mediumint(8) unsigned NOT NULL,
  `z` mediumint(8) unsigned NOT NULL,
  `light` tinyint(4) NOT NULL,
  `world` varchar(50) NOT NULL,
  `t` mediumint(9) NOT NULL,
  `d` mediumint(8) unsigned NOT NULL,
  `b` mediumint(8) unsigned NOT NULL,
  `ratio` smallint(6) NOT NULL,
  `flagged` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

@uncovery: Go

I ran that but I still get the same error. Hrm...

I still get this. Will it ever be removed?