• Chào bạn, hãy đăng ký hoặc đăng nhập để tham gia cùng bọn mình và sử dụng được đầy đủ chức năng của diễn đàn :).
TUANHP0

Wordpress Authme + wordpress

TUANHP0

THÀNH VIÊN
Tham gia
12/07/2017
Bài viết
523
mk có tạo database là home nhưng khi tạo tài khoản trên wordpress thì nó sẽ có user là 'wp_user'
còn authme sẽ tạo ra là authme (nếu mySQLTablename: 'authme')
Thì mk muốn cho cái authme và wp_user là 1 thì làm ntn ạ
mySQLTablename: 'wp_users' thì authme sẽ báo lỗi

---------------------------------------------------------

[10-03 23:27:42]: [INFO] Connection arguments loaded, Hikari ConnectionPool ready!
[10-03 23:27:44]: [WARN] Can't initialize the MySQL database: [MySQLSyntaxErrorException]: Specified key was too long; max key length is 767 bytes
[10-03 23:27:44]: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes
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: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:2620)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1662)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1581)
at fr.xephi.authme.libs.zaxxer.hikari.pool.ProxyStatement.executeUpdate(ProxyStatement.java:120)
at fr.xephi.authme.libs.zaxxer.hikari.pool.HikariProxyStatement.executeUpdate(HikariProxyStatement.java)
at fr.xephi.authme.datasource.MySQL.checkTablesAndColumns(MySQL.java:174)
at fr.xephi.authme.datasource.MySQL.<init>(MySQL.java:69)
at fr.xephi.authme.initialization.DataSourceProvider.createDataSource(DataSourceProvider.java:72)
at fr.xephi.authme.initialization.DataSourceProvider.get(DataSourceProvider.java:49)
at fr.xephi.authme.initialization.DataSourceProvider.get(DataSourceProvider.java:26)
at fr.xephi.authme.libs.jalu.injector.handlers.provider.ProviderHandlerImpl$UninitializedProviderInstantiation.instantiateWith(ProviderHandlerImpl.java:141)
at fr.xephi.authme.libs.jalu.injector.InjectorImpl.instantiate(InjectorImpl.java:181)
at fr.xephi.authme.libs.jalu.injector.InjectorImpl.get(InjectorImpl.java:155)
at fr.xephi.authme.libs.jalu.injector.InjectorImpl.getSingleton(InjectorImpl.java:56)
at fr.xephi.authme.AuthMe.instantiateServices(AuthMe.java:246)
at fr.xephi.authme.AuthMe.initialize(AuthMe.java:221)
at fr.xephi.authme.AuthMe.onEnable(AuthMe.java:136)
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:321)
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:335)
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405)
at org.bukkit.craftbukkit.v1_8_R1.CraftServer.loadPlugin(CraftServer.java:356)
at org.bukkit.craftbukkit.v1_8_R1.CraftServer.enablePlugins(CraftServer.java:316)
at net.minecraft.server.v1_8_R1.MinecraftServer.q(MinecraftServer.java:402)
at net.minecraft.server.v1_8_R1.MinecraftServer.k(MinecraftServer.java:370)
at net.minecraft.server.v1_8_R1.MinecraftServer.a(MinecraftServer.java:325)
at net.minecraft.server.v1_8_R1.DedicatedServer.init(DedicatedServer.java:211)
at net.minecraft.server.v1_8_R1.MinecraftServer.run(MinecraftServer.java:505)
at java.lang.Thread.run(Unknown Source)

[10-03 23:27:44]: [WARN] Please check your database settings in the config.yml file!
[10-03 23:27:44]: [WARN] Could not create data source: [MySQLSyntaxErrorException]: Specified key was too long; max key length is 767 bytes
[10-03 23:27:44]: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes
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: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:2620)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1662)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1581)
at fr.xephi.authme.libs.zaxxer.hikari.pool.ProxyStatement.executeUpdate(ProxyStatement.java:120)
at fr.xephi.authme.libs.zaxxer.hikari.pool.HikariProxyStatement.executeUpdate(HikariProxyStatement.java)
at fr.xephi.authme.datasource.MySQL.checkTablesAndColumns(MySQL.java:174)
at fr.xephi.authme.datasource.MySQL.<init>(MySQL.java:69)
at fr.xephi.authme.initialization.DataSourceProvider.createDataSource(DataSourceProvider.java:72)
at fr.xephi.authme.initialization.DataSourceProvider.get(DataSourceProvider.java:49)
at fr.xephi.authme.initialization.DataSourceProvider.get(DataSourceProvider.java:26)
at fr.xephi.authme.libs.jalu.injector.handlers.provider.ProviderHandlerImpl$UninitializedProviderInstantiation.instantiateWith(ProviderHandlerImpl.java:141)
at fr.xephi.authme.libs.jalu.injector.InjectorImpl.instantiate(InjectorImpl.java:181)
at fr.xephi.authme.libs.jalu.injector.InjectorImpl.get(InjectorImpl.java:155)
at fr.xephi.authme.libs.jalu.injector.InjectorImpl.getSingleton(InjectorImpl.java:56)
at fr.xephi.authme.AuthMe.instantiateServices(AuthMe.java:246)
at fr.xephi.authme.AuthMe.initialize(AuthMe.java:221)
at fr.xephi.authme.AuthMe.onEnable(AuthMe.java:136)
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:321)
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:335)
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405)
at org.bukkit.craftbukkit.v1_8_R1.CraftServer.loadPlugin(CraftServer.java:356)
at org.bukkit.craftbukkit.v1_8_R1.CraftServer.enablePlugins(CraftServer.java:316)
at net.minecraft.server.v1_8_R1.MinecraftServer.q(MinecraftServer.java:402)
at net.minecraft.server.v1_8_R1.MinecraftServer.k(MinecraftServer.java:370)
at net.minecraft.server.v1_8_R1.MinecraftServer.a(MinecraftServer.java:325)
at net.minecraft.server.v1_8_R1.DedicatedServer.init(DedicatedServer.java:211)
at net.minecraft.server.v1_8_R1.MinecraftServer.run(MinecraftServer.java:505)
at java.lang.Thread.run(Unknown Source)

[10-03 23:27:44]: [WARN] Aborting initialization of AuthMe: [IllegalStateException]: Error during initialization of data source
[10-03 23:27:44]: java.lang.IllegalStateException: Error during initialization of data source
at fr.xephi.authme.initialization.DataSourceProvider.get(DataSourceProvider.java:52)
at fr.xephi.authme.initialization.DataSourceProvider.get(DataSourceProvider.java:26)
at fr.xephi.authme.libs.jalu.injector.handlers.provider.ProviderHandlerImpl$UninitializedProviderInstantiation.instantiateWith(ProviderHandlerImpl.java:141)
at fr.xephi.authme.libs.jalu.injector.InjectorImpl.instantiate(InjectorImpl.java:181)
at fr.xephi.authme.libs.jalu.injector.InjectorImpl.get(InjectorImpl.java:155)
at fr.xephi.authme.libs.jalu.injector.InjectorImpl.getSingleton(InjectorImpl.java:56)
at fr.xephi.authme.AuthMe.instantiateServices(AuthMe.java:246)
at fr.xephi.authme.AuthMe.initialize(AuthMe.java:221)
at fr.xephi.authme.AuthMe.onEnable(AuthMe.java:136)
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:321)
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:335)
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405)
at org.bukkit.craftbukkit.v1_8_R1.CraftServer.loadPlugin(CraftServer.java:356)
at org.bukkit.craftbukkit.v1_8_R1.CraftServer.enablePlugins(CraftServer.java:316)
at net.minecraft.server.v1_8_R1.MinecraftServer.q(MinecraftServer.java:402)
at net.minecraft.server.v1_8_R1.MinecraftServer.k(MinecraftServer.java:370)
at net.minecraft.server.v1_8_R1.MinecraftServer.a(MinecraftServer.java:325)
at net.minecraft.server.v1_8_R1.DedicatedServer.init(DedicatedServer.java:211)
at net.minecraft.server.v1_8_R1.MinecraftServer.run(MinecraftServer.java:505)
at java.lang.Thread.run(Unknown Source)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes
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: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:2620)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1662)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1581)
at fr.xephi.authme.libs.zaxxer.hikari.pool.ProxyStatement.executeUpdate(ProxyStatement.java:120)
at fr.xephi.authme.libs.zaxxer.hikari.pool.HikariProxyStatement.executeUpdate(HikariProxyStatement.java)
at fr.xephi.authme.datasource.MySQL.checkTablesAndColumns(MySQL.java:174)
at fr.xephi.authme.datasource.MySQL.<init>(MySQL.java:69)
at fr.xephi.authme.initialization.DataSourceProvider.createDataSource(DataSourceProvider.java:72)
at fr.xephi.authme.initialization.DataSourceProvider.get(DataSourceProvider.java:49)
... 19 more

[10-03 23:27:44]: [WARN] THE SERVER IS GOING TO SHUT DOWN AS DEFINED IN THE CONFIGURATION!
[10-03 23:27:44]: [INFO] AuthMe 5.4.0-b1877 disabled!
 
10-03 23:27:44]: [WARN] Could not create data source: [MySQLSyntaxErrorException]: Specified key was too long; max key length is 767 bytes
[10-03 23:27:44]: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes
 
Cấu hình authme vào wp_users
nhớ chọn kiểu mã hóa password là wordpress
 
Similar content Most view Xem thêm
Back
Top Bottom