2012-08-01 12:23:07 [SEVERE] [xAuth] Failed to insert player data into database! java.sql.SQLException: Column count doesn't match value count at row 1 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 com.cypherx.xauth.PlayerDataHandler.storeData(PlayerDataHandler.java:94) at com.cypherx.xauth.PlayerManager.protect(PlayerManager.java:160) at com.cypherx.xauth.listeners.xAuthPlayerListener$1.run(xAuthPlayerListener.java:287) at org.bukkit.craftbukkit.scheduler.CraftScheduler.mainThreadHeartbeat(CraftScheduler.java:126) at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:533) at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:459) at net.minecraft.server.ThreadServerApplication.run(SourceFile:492)
According to the error, your MySQL server does not seem to be formatted correctly. Are you connecting to a remote database? Or are you using a .db file?
i using wampserver 2.2d mysql database SQL Buddy connected to MySQL 5.5.20 with the user root@localhost.