Skip to content
This repository has been archived by the owner on Feb 3, 2024. It is now read-only.

Version v1.22.3 SQL error #1610

Closed
uncovery opened this issue Aug 13, 2014 · 2 comments
Closed

Version v1.22.3 SQL error #1610

uncovery opened this issue Aug 13, 2014 · 2 comments

Comments

@uncovery
Copy link

During startup, PEX throws this error:

[11:28:21] [pool-9-thread-1/ERROR]: [PermissionsEx] Error occurred with PermissionsEx! Please post it to http://git.io/X4EeRQ. Full error:
ru.tehkode.permissions.exceptions.PermissionBackendException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Can't DROP 'unique'; check that column/key exists
at ru.tehkode.permissions.backends.sql.SQLBackend$1.performUpdate(SQLBackend.java:129)
at ru.tehkode.permissions.backends.PermissionBackend.performSchemaUpdate(PermissionBackend.java:90)
at ru.tehkode.permissions.backends.sql.SQLBackend.(SQLBackend.java:190)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at ru.tehkode.permissions.backends.PermissionBackend.getBackend(PermissionBackend.java:392)
at ru.tehkode.permissions.backends.PermissionBackend.getBackend(PermissionBackend.java:367)
at ru.tehkode.permissions.PermissionManager.createBackend(PermissionManager.java:713)
at ru.tehkode.permissions.PermissionManager.setBackend(PermissionManager.java:695)
at ru.tehkode.permissions.PermissionManager.initBackend(PermissionManager.java:772)
at ru.tehkode.permissions.PermissionManager.(PermissionManager.java:74)
at ru.tehkode.permissions.bukkit.PermissionsEx.onEnable(PermissionsEx.java:158)
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:316)
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:329)
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405)
at org.bukkit.craftbukkit.v1_7_R4.CraftServer.loadPlugin(CraftServer.java:476)
at org.bukkit.craftbukkit.v1_7_R4.CraftServer.enablePlugins(CraftServer.java:394)
at net.minecraft.server.v1_7_R4.MinecraftServer.n(MinecraftServer.java:360)
at net.minecraft.server.v1_7_R4.MinecraftServer.g(MinecraftServer.java:334)
at net.minecraft.server.v1_7_R4.MinecraftServer.a(MinecraftServer.java:290)
at net.minecraft.server.v1_7_R4.DedicatedServer.init(DedicatedServer.java:210)
at net.minecraft.server.v1_7_R4.MinecraftServer.run(MinecraftServer.java:458)
at net.minecraft.server.v1_7_R4.ThreadServerApplication.run(SourceFile:628)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Can't DROP 'unique'; check that column/key exists
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
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.execute(PreparedStatement.java:1362)
at ru.tehkode.libs.org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at ru.tehkode.libs.org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at ru.tehkode.permissions.backends.sql.SQLBackend$1.performUpdate(SQLBackend.java:124)
... 24 more

@uncovery uncovery changed the title Version 1.22.1 SQL error Version 1.22.2 SQL error Aug 13, 2014
@uncovery uncovery changed the title Version 1.22.2 SQL error Version v1.22.3 SQL error Aug 13, 2014
@zml2008
Copy link
Member

zml2008 commented Aug 22, 2014

You're going to have to delete the duplicate schema-version row (with the lowest version) from the permissions table. This was a bug from pex 1.22.2.

@uncovery
Copy link
Author

thanks, that fixed it.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants