FakaHeda.eu Fórum

Technická podpora game hostingu FakaHeda.eu
https://forum.fakaheda.eu/

PermissionsEx - Mysql

https://forum.fakaheda.eu/viewtopic.php?f=67&t=32392

Stránka 1 z 1

PermissionsEx - Mysql

Napsal: 12 bře 2017, 12:38
od Crusby
Server 82.208.17.31:27046

Tenhle Error se mi ukazuje vždy jen u startu serveru a díky tomuhle se i spouštění serveru protahuje ...

Spoiler: zobrazit

Kód: Vybrat vše

[11:36:01] [pool-23-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(NativeConstructorAccessorImpl.java:62)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
   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:321)
   at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:340)
   at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405)
   at org.bukkit.craftbukkit.v1_8_R3.CraftServer.loadPlugin(CraftServer.java:357)
   at org.bukkit.craftbukkit.v1_8_R3.CraftServer.enablePlugins(CraftServer.java:317)
   at net.minecraft.server.v1_8_R3.MinecraftServer.s(MinecraftServer.java:414)
   at net.minecraft.server.v1_8_R3.MinecraftServer.k(MinecraftServer.java:378)
   at net.minecraft.server.v1_8_R3.MinecraftServer.a(MinecraftServer.java:333)
   at net.minecraft.server.v1_8_R3.DedicatedServer.init(DedicatedServer.java:263)
   at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:525)
   at java.lang.Thread.run(Thread.java:745)
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(NativeConstructorAccessorImpl.java:62)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
   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.executeQuery(PreparedStatement.java:2273)
   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)
   ... 24 more

Re: PermissionsEx - Mysql

Napsal: 12 bře 2017, 12:41
od vojtamaniak
Identifikuj server dle pravidel.

Re: PermissionsEx - Mysql

Napsal: 12 bře 2017, 12:48
od Dawe5
Mám něco podobného..

Spoiler: zobrazit

Kód: Vybrat vše

[11:44:57 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(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
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.dynmap.bukkit.permissions.PEXPermissions.create(PEXPermissions.java:24)
at org.dynmap.bukkit.DynmapPlugin.onEnable(DynmapPlugin.java:794)
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:376)
at org.bukkit.craftbukkit.v1_11_R1.CraftServer.enablePlugins(CraftServer.java:326)
at net.minecraft.server.v1_11_R1.MinecraftServer.t(MinecraftServer.java:421)
at net.minecraft.server.v1_11_R1.MinecraftServer.l(MinecraftServer.java:382)
at net.minecraft.server.v1_11_R1.MinecraftServer.a(MinecraftServer.java:337)
at net.minecraft.server.v1_11_R1.DedicatedServer.init(DedicatedServer.java:272)
at net.minecraft.server.v1_11_R1.MinecraftServer.run(MinecraftServer.java:544)
at java.lang.Thread.run(Thread.java:745)
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(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677)
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
 
[11:44:57 INFO]: WEPIF: PermissionsEx detected! Using PermissionsEx for permissions.

Re: PermissionsEx - Mysql

Napsal: 12 bře 2017, 13:13
od Crusby
Identifikováno.

Re: PermissionsEx - Mysql

Napsal: 12 bře 2017, 13:23
od Hanakocz
Tak sem do CODE přidej config PEX (alespoň část PEX), nezapomeň zamazat heslo k mysql. Pokud ale tam nenajdeme chybu, tak je fakt nejjednodušší napsat autorovi pluginu, jak ti ta chyba diktuje a dává adresu k tomu určenou.

Re: PermissionsEx - Mysql

Napsal: 12 bře 2017, 13:28
od Crusby
Spoiler: zobrazit

Kód: Vybrat vše

multiserver:
  use-netevents: true
permissions:
  debug: false
  allowOps: false
  user-add-groups-last: false
  log-players: false
  createUserRecords: false
  informplayers:
    changes: false
  basedir: plugins/PermissionsEx
  backend: sql
  backends:
    sql:
      uri: mysql://casa21.fakaheda.eu/227537_mysql_db
      user: 227537_mysql_db
      password: xxx
      type: sql
updater: true
alwaysUpdate: false
Všechny časy jsou v UTC+02:00
Stránka 1 z 1
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/