Pex Error with MySql

Discussion in 'Bukkit Discussion' started by Mudkiper202, Feb 4, 2017.

Thread Status:
Not open for further replies.
  1. Offline

    Mudkiper202

    So whenever i start or reload my server it all goes good my pex connects with mysql but at the end it comes up with an error

    Also im having a problem where i am having it negate a node "-worldedit.navigation" and then i am giving all nodes with "*" but it doesnt work but i get all nodes, i didnt have the sql problem earlier and i tried redoing the sql but it still pops up

    Log (open)

    Code:
    [18:55:15] [Server thread/INFO]: [PermissionsEx] Loading PermissionsEx v1.23.4
[18:55:15] [Server thread/WARN]: [PermissionsEx] This server is in offline mode. Unless this server is configured to integrate with a supported proxy (see http://dft.ba/-8ous), UUIDs *may not be stable*!
[18:55:15] [Server thread/INFO]: [Hub] Loading Hub v1.0
[18:55:15] [Server thread/INFO]: [WorldEdit] Loading WorldEdit v6.1.5;4651611
[18:55:15] [Server thread/INFO]: [Votifier] Loading Votifier v2.3.3
[18:55:15] [Server thread/INFO]: [VoxelSniper] Loading VoxelSniper v5.171.0-SNAPSHOT
[18:55:15] [Server thread/INFO]: [PermissionsEx] Enabling PermissionsEx v1.23.4
[18:55:15] [Server thread/INFO]: [PermissionsEx] Initializing sql backend
[18:55:15] [Server thread/INFO]: [PermissionsEx] Successfully connected to SQL database
[18:55:16] [Server thread/INFO]: [Hub] Enabling Hub v1.0
[18:55:16] [Server thread/INFO]: [WorldEdit] Enabling WorldEdit v6.1.5;4651611
[18:55:17] [Server thread/INFO]: WEPIF: PermissionsEx detected! Using PermissionsEx for permissions.
[18:55:17] [Server thread/INFO]: [WorldEdit] Using com.sk89q.worldedit.bukkit.adapter.impl.Spigot_v1_11_R1 as the Bukkit adapter
[18:55:17] [Server thread/INFO]: [Votifier] Enabling Votifier v2.3.3
[18:55:17] [Server thread/INFO]: [Votifier] Loaded token for website: default
[18:55:17] [pool-33-thread-1/ERROR]: [PermissionsEx] Error occurred with PermissionsEx! Please post it to http://git.io/<html><body>You are being <a href="https://git.io/create">redirected</a>.</body></html>. Full error:
ru.tehkode.permissions.exceptions.PermissionBackendException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'prefix' in 'field list'
    at ru.tehkode.permissions.backends.sql.SQLBackend$3.performUpdate(SQLBackend.java:186)
    at ru.tehkode.permissions.backends.PermissionBackend.performSchemaUpdate(PermissionBackend.java:90)
    at ru.tehkode.permissions.backends.sql.SQLBackend.<init>(SQLBackend.java:192)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    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:624)
    at ru.tehkode.permissions.PermissionManager.setBackend(PermissionManager.java:606)
    at ru.tehkode.permissions.PermissionManager.initBackend(PermissionManager.java:693)
    at ru.tehkode.permissions.PermissionManager.<init>(PermissionManager.java:67)
    at ru.tehkode.permissions.bukkit.PermissionsEx.onEnable(PermissionsEx.java:175)
    at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:271)
    at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:337)
    at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405)
    at org.bukkit.craftbukkit.v1_11_R1.CraftServer.enablePlugin(CraftServer.java:375)
    at org.bukkit.craftbukkit.v1_11_R1.CraftServer.enablePlugins(CraftServer.java:325)
    at org.bukkit.craftbukkit.v1_11_R1.CraftServer.reload(CraftServer.java:749)
    at org.bukkit.Bukkit.reload(Bukkit.java:540)
    at org.bukkit.command.defaults.ReloadCommand.execute(ReloadCommand.java:25)
    at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:141)
    at org.bukkit.craftbukkit.v1_11_R1.CraftServer.dispatchCommand(CraftServer.java:649)
    at org.bukkit.craftbukkit.v1_11_R1.CraftServer.dispatchServerCommand(CraftServer.java:635)
    at net.minecraft.server.v1_11_R1.DedicatedServer.aM(DedicatedServer.java:437)
    at net.minecraft.server.v1_11_R1.DedicatedServer.D(DedicatedServer.java:400)
    at net.minecraft.server.v1_11_R1.MinecraftServer.C(MinecraftServer.java:675)
    at net.minecraft.server.v1_11_R1.MinecraftServer.run(MinecraftServer.java:574)
    at java.lang.Thread.run(Unknown Source)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'prefix' in 'field list'
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
    at com.mysql.jdbc.Util.getInstance(Util.java:387)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:942)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3966)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3902)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2526)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2673)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2549)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
    at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1962)
    at ru.tehkode.libs.org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    at ru.tehkode.libs.org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    at ru.tehkode.permissions.backends.sql.SQLBackend$3.performUpdate(SQLBackend.java:161)
    ... 29 more

[18:55:17] [Server thread/INFO]: [Votifier] Method none selected for vote forwarding: Votes will not be received from a forwarder.
[18:55:17] [nioEventLoopGroup-2-1/INFO]: [Votifier] Votifier enabled on socket /127.0.0.1:8192.
[18:55:17] [Server thread/INFO]: [VoxelSniper] Enabling VoxelSniper v5.171.0-SNAPSHOT
[18:55:17] [Server thread/INFO]: [VoxelSniper] Registered 75 Sniper Brushes with 149 handles.
[18:55:17] [Server thread/INFO]: [VoxelSniper] Registered Sniper Listener.
[18:55:17] [Server thread/INFO]: Server permissions file permissions.yml is empty, ignoring it
     
    Mudkiper202, Feb 4, 2017
    #1
  2. Offline

    timtower Administrator Administrator Moderator

    timtower, Feb 4, 2017
    #2
  3. Offline

    Mudkiper202

    Here it is
     

    Attached Files:

    Mudkiper202, Feb 5, 2017
    #3
  4. Offline

    timtower Administrator Administrator Moderator

    @Mudkiper202 Did you make that table yourself? If so: remove the table and let the plugin create one.
     
    timtower, Feb 5, 2017
    #4
  5. Offline

    Mudkiper202

    I had the file(permissions.yml) and then i made it the sql backend then i did /pex import file and it says it dumped it
     
    Mudkiper202, Feb 5, 2017
    #5
Thread Status:
Not open for further replies.

Share This Page