PermissionsEx mySQL error

Discussion in 'Bukkit Help' started by xXMaTTHDXx, Jul 14, 2014.

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

    xXMaTTHDXx

    Code:
    [01:38:30] [Server thread/INFO]: [PermissionsEx] Enabling PermissionsEx v2.0-SNAPSHOT
    [01:38:30] [Server thread/INFO]: [PermissionsEx] Initializing sql backend
    [01:38:30] [Server thread/INFO]: [PermissionsEx] Successfully connected to SQL database
    [01:38:30] [Server thread/INFO]: [PermissionsEx] Deploying default database scheme
    [01:38:31] [Server thread/ERROR]: [PermissionsEx]
    ========== UNABLE TO LOAD PERMISSIONS BACKEND =========
    Your configuration must be fixed before PEX will enable
    Details: Deploying of default data failed. Please initialize database manually using mysql.sql
    =======================================================
    ru.tehkode.permissions.exceptions.PermissionBackendException: Deploying of default data failed. Please initialize database manually using mysql.sql
        at ru.tehkode.permissions.backends.sql.SQLBackend.deployTables(SQLBackend.java:342) ~[PermissionsEx.jar:?]
        at ru.tehkode.permissions.backends.sql.SQLBackend.<init>(SQLBackend.java:172) ~[PermissionsEx.jar:?]
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.7.0_51]
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) ~[?:1.7.0_51]
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.7.0_51]
        at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[?:1.7.0_51]
        at ru.tehkode.permissions.backends.PermissionBackend.getBackend(PermissionBackend.java:372) ~[PermissionsEx.jar:?]
        at ru.tehkode.permissions.backends.PermissionBackend.getBackend(PermissionBackend.java:347) ~[PermissionsEx.jar:?]
        at ru.tehkode.permissions.PermissionManager.createBackend(PermissionManager.java:604) ~[PermissionsEx.jar:?]
        at ru.tehkode.permissions.PermissionManager.setBackend(PermissionManager.java:586) ~[PermissionsEx.jar:?]
        at ru.tehkode.permissions.PermissionManager.initBackend(PermissionManager.java:663) ~[PermissionsEx.jar:?]
        at ru.tehkode.permissions.PermissionManager.<init>(PermissionManager.java:62) ~[PermissionsEx.jar:?]
        at ru.tehkode.permissions.bukkit.PermissionsEx.onEnable(PermissionsEx.java:164) [PermissionsEx.jar:?]
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:316) [Spigot:git-Spigot-1543]
        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:329) [Spigot:git-Spigot-1543]
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405) [Spigot:git-Spigot-1543]
        at org.bukkit.craftbukkit.v1_7_R3.CraftServer.loadPlugin(CraftServer.java:476) [Spigot:git-Spigot-1543]
        at org.bukkit.craftbukkit.v1_7_R3.CraftServer.enablePlugins(CraftServer.java:394) [Spigot:git-Spigot-1543]
        at net.minecraft.server.v1_7_R3.MinecraftServer.n(MinecraftServer.java:360) [Spigot:git-Spigot-1543]
        at net.minecraft.server.v1_7_R3.MinecraftServer.g(MinecraftServer.java:334) [Spigot:git-Spigot-1543]
        at net.minecraft.server.v1_7_R3.MinecraftServer.a(MinecraftServer.java:290) [Spigot:git-Spigot-1543]
        at net.minecraft.server.v1_7_R3.DedicatedServer.init(DedicatedServer.java:194) [Spigot:git-Spigot-1543]
        at net.minecraft.server.v1_7_R3.MinecraftServer.run(MinecraftServer.java:458) [Spigot:git-Spigot-1543]
        at net.minecraft.server.v1_7_R3.ThreadServerApplication.run(SourceFile:628) [Spigot:git-Spigot-1543]
    Caused by: java.sql.BatchUpdateException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*/
     
    CREATE TABLE IF NOT EXISTS `server_permissions` (
      `id` int(11) NOT NULL AU' at line 1
        at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:1065) ~[Spigot:git-Spigot-1543]
        at ru.tehkode.libs.org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) ~[PermissionsEx.jar:?]
        at ru.tehkode.libs.org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) ~[PermissionsEx.jar:?]
        at ru.tehkode.permissions.backends.sql.SQLBackend.executeStream(SQLBackend.java:321) ~[PermissionsEx.jar:?]
        at ru.tehkode.permissions.backends.sql.SQLBackend.deployTables(SQLBackend.java:336) ~[PermissionsEx.jar:?]
        ... 23 more
    [01:38:31] [Server thread/INFO]: [PermissionsEx] Disabling PermissionsEx v2.0-SNAPSHOT
    [01:38:31] [Server thread/INFO]: WEPIF: Using the Bukkit Permissions API.
    [01:38:31] [Server thread/INFO]: WEPIF: Using the Bukkit Permissions API.
    I hooked pex up to sql but when I restart the server, I run into this, anyone got a idea?
     
  2. Offline

    jkjames6

    Could you post your PEX config please :)
     
  3. Offline

    xXMaTTHDXx

    Code:
    multiserver:
      use-netevents: true
    permissions:
      debug: false
      allowOps: true
      user-add-groups-last: false
      log-players: false
      createUserRecords: false
      backend: sql
      informplayers:
        changes: false
      backends:
        sql:
          uri: mysql://localhost/pex
          user: root
          password: **********
          deploy: permissions.sql
          aliases:
            permissions: server_permissions
            permissions_inheritance: server_inheritance
            permissions_entity: server_entity
      basedir: plugins/PermissionsEx
    updater: true
    alwaysUpdate: false
    
    Here you go jkjames6
     
  4. Offline

    jkjames6

  5. Offline

    xXMaTTHDXx

    Code:
    [PermissionsEx] Initializing sql backend
    [15:08:21] [Server thread/INFO]: [PermissionsEx] Successfully connected to SQL database
    [15:08:21] [Server thread/INFO]: [PermissionsEx] Deploying default database scheme
    [15:08:21] [Server thread/ERROR]: [PermissionsEx]
    ========== UNABLE TO LOAD PERMISSIONS BACKEND =========
    Your configuration must be fixed before PEX will enable
    Details: Deploying of default data failed. Please initialize database manually using mysql.sql
    =======================================================
    ru.tehkode.permissions.exceptions.PermissionBackendException: Deploying of default data failed. Please initialize database manually using mysql.sql
        at ru.tehkode.permissions.backends.sql.SQLBackend.deployTables(SQLBackend.java:342) ~[PermissionsEx.jar:?]
        at ru.tehkode.permissions.backends.sql.SQLBackend.<init>(SQLBackend.java:172) ~[PermissionsEx.jar:?]
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.7.0_51]
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) ~[?:1.7.0_51]
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.7.0_51]
        at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[?:1.7.0_51]
        at ru.tehkode.permissions.backends.PermissionBackend.getBackend(PermissionBackend.java:372) ~[PermissionsEx.jar:?]
        at ru.tehkode.permissions.backends.PermissionBackend.getBackend(PermissionBackend.java:347) ~[PermissionsEx.jar:?]
        at ru.tehkode.permissions.PermissionManager.createBackend(PermissionManager.java:604) ~[PermissionsEx.jar:?]
        at ru.tehkode.permissions.PermissionManager.setBackend(PermissionManager.java:586) ~[PermissionsEx.jar:?]
        at ru.tehkode.permissions.PermissionManager.initBackend(PermissionManager.java:663) ~[PermissionsEx.jar:?]
        at ru.tehkode.permissions.PermissionManager.<init>(PermissionManager.java:62) ~[PermissionsEx.jar:?]
        at ru.tehkode.permissions.bukkit.PermissionsEx.onEnable(PermissionsEx.java:164) [PermissionsEx.jar:?]
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:316) [Spigot:git-Spigot-1543]
        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:329) [Spigot:git-Spigot-1543]
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405) [Spigot:git-Spigot-1543]
        at org.bukkit.craftbukkit.v1_7_R3.CraftServer.loadPlugin(CraftServer.java:476) [Spigot:git-Spigot-1543]
        at org.bukkit.craftbukkit.v1_7_R3.CraftServer.enablePlugins(CraftServer.java:394) [Spigot:git-Spigot-1543]
        at net.minecraft.server.v1_7_R3.MinecraftServer.n(MinecraftServer.java:360) [Spigot:git-Spigot-1543]
        at net.minecraft.server.v1_7_R3.MinecraftServer.g(MinecraftServer.java:334) [Spigot:git-Spigot-1543]
        at net.minecraft.server.v1_7_R3.MinecraftServer.a(MinecraftServer.java:290) [Spigot:git-Spigot-1543]
        at net.minecraft.server.v1_7_R3.DedicatedServer.init(DedicatedServer.java:194) [Spigot:git-Spigot-1543]
        at net.minecraft.server.v1_7_R3.MinecraftServer.run(MinecraftServer.java:458) [Spigot:git-Spigot-1543]
        at net.minecraft.server.v1_7_R3.ThreadServerApplication.run(SourceFile:628) [Spigot:git-Spigot-1543]
    Caused by: java.sql.BatchUpdateException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*/
     
    CREATE TABLE IF NOT EXISTS `permissions` (
      `id` int(11) NOT NULL AUTO_INCR' at line 1
        at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:1065) ~[Spigot:git-Spigot-1543]
        at ru.tehkode.libs.org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) ~[PermissionsEx.jar:?]
        at ru.tehkode.libs.org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) ~[PermissionsEx.jar:?]
        at ru.tehkode.permissions.backends.sql.SQLBackend.executeStream(SQLBackend.java:321) ~[PermissionsEx.jar:?]
        at ru.tehkode.permissions.backends.sql.SQLBackend.deployTables(SQLBackend.java:336) ~[PermissionsEx.jar:?]
        ... 23 more
    Still getting the error. jkjames6
     
  6. Offline

    Jade Retired Staff

    Locked. We do not support unofficial builds.
     
Thread Status:
Not open for further replies.

Share This Page