CypherX/xAuth — Issue #18: Server DB Update Fails. v1 -> v2 ? i've just reinstalled this version?
Author: mr-bo-jangles
Created: 2011-12-01 12:51:06+00:00
State: open

2011-12-01 13:46:35 [INFO] [xAuth] Connection to database established!
2011-12-01 13:46:35 [INFO] [xAuth] Updating database..
2011-12-01 13:46:35 [SEVERE] [xAuth] SQL query failure [write] (ALTER TABLE `tele_locations` ADD COLUMN `uid` VARCHAR(36) NOT NULL FIRST)
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'uid'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.Util.getInstance(Util.java:382)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
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.database.Database.queryWrite(Database.java:90)
at com.cypherx.xauth.database.DbUpdate.update(DbUpdate.java:61)
at com.cypherx.xauth.database.DbUpdate.update(DbUpdate.java:39)
at com.cypherx.xauth.xAuth.onEnable(xAuth.java:101)
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:174)
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:957)
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:280)
at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:171)
at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:154)
at org.bukkit.craftbukkit.CraftServer.reload(CraftServer.java:413)
at org.bukkit.Bukkit.reload(Bukkit.java:182)
at org.bukkit.command.defaults.ReloadCommand.execute(ReloadCommand.java:22)
at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:163)
at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:355)
at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:351)
at net.minecraft.server.MinecraftServer.b(MinecraftServer.java:506)
at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:485)
at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:374)
at net.minecraft.server.ThreadServerApplication.run(SourceFile:417)
2011-12-01 13:46:35 [SEVERE] [xAuth] Database update (1 -> 2) failed!
2011-12-01 13:46:35 [INFO] [xAuth] v2.0b4.3 Disabled!