Duplicate column name 'priority'
ShezzUr opened this issue ยท 0 comments
What version/build of NametagEdit are you using? Type /ver NametagEdit
4.1.4
What version of Bukkit/Spigot/PaperSpigot are you using? Type /ver
1.12 R01
Please explain your issue?
[05:25:36 WARN]: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'priority'
[05:25:36 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[05:25:36 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[05:25:36 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[05:25:36 WARN]: at java.lang.reflect.Constructor.newInstance(Unknown Source)
[05:25:36 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[05:25:36 WARN]: at com.mysql.jdbc.Util.getInstance(Util.java:408)
[05:25:36 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
[05:25:36 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
[05:25:36 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
[05:25:36 WARN]: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
[05:25:36 WARN]: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
[05:25:36 WARN]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2490)
[05:25:36 WARN]: at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
[05:25:36 WARN]: at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1197)
[05:25:36 WARN]: at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
[05:25:36 WARN]: at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
[05:25:36 WARN]: at com.nametagedit.plugin.storage.database.tasks.DatabaseUpdater.execute(DatabaseUpdater.java:70)
[05:25:36 WARN]: at com.nametagedit.plugin.storage.database.tasks.DatabaseUpdater.handleUpdate1(DatabaseUpdater.java:50)
[05:25:36 WARN]: at com.nametagedit.plugin.storage.database.tasks.DatabaseUpdater.run(DatabaseUpdater.java:29)
[05:25:36 WARN]: at org.bukkit.craftbukkit.v1_12_R1.scheduler.CraftTask.run(CraftTask.java:71)
[05:25:36 WARN]: at org.bukkit.craftbukkit.v1_12_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:52)
[05:25:36 WARN]: at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
[05:25:36 WARN]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
[05:25:36 WARN]: at java.lang.Thread.run(Unknown Source)
[05:25:36 WARN]: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'priority'
[05:25:36 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[05:25:36 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[05:25:36 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[05:25:36 WARN]: at java.lang.reflect.Constructor.newInstance(Unknown Source)
[05:25:36 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[05:25:36 WARN]: at com.mysql.jdbc.Util.getInstance(Util.java:408)
[05:25:36 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
[05:25:36 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
[05:25:36 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
[05:25:36 WARN]: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
[05:25:36 WARN]: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
[05:25:36 WARN]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2490)
[05:25:36 WARN]: at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
[05:25:36 WARN]: at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1197)
[05:25:36 WARN]: at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
[05:25:36 WARN]: at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
[05:25:36 WARN]: at com.nametagedit.plugin.storage.database.tasks.DatabaseUpdater.execute(DatabaseUpdater.java:70)
[05:25:36 WARN]: at com.nametagedit.plugin.storage.database.tasks.DatabaseUpdater.handleUpdate1(DatabaseUpdater.java:51)
[05:25:36 WARN]: at com.nametagedit.plugin.storage.database.tasks.DatabaseUpdater.run(DatabaseUpdater.java:29)
[05:25:36 WARN]: at org.bukkit.craftbukkit.v1_12_R1.scheduler.CraftTask.run(CraftTask.java:71)
[05:25:36 WARN]: at org.bukkit.craftbukkit.v1_12_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:52)
[05:25:36 WARN]: at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
[05:25:36 WARN]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
[05:25:36 WARN]: at java.lang.Thread.run(Unknown Source)
How do you reproduce the issue?
Setup MySql connection, This is a clean connection to MySql and I changed a prefix to 'Hello' and I checked my server and it threw this error, I beleive it's a duplicate column name as stated in the error