addc123
在BC中使用XConomy,一直在报错,断连数据库,连接数据库[09:58:27 INFO]: [XConomy] 无法连接到数据库-----
[09:58:27 WARN]: [TAB Processing Thread] INFO me.yic.libs.zaxxer.hikari.HikariDataSource - XConomy - Shutdown initiated...
[09:58:27 WARN]: [TAB Processing Thread] INFO me.yic.libs.zaxxer.hikari.HikariDataSource - XConomy - Shutdown completed.
[09:58:27 WARN]: java.sql.SQLTransientConnectionException: XConomy - Connection is not available, request timed out after 30001ms.
[09:58:27 WARN]:        at me.yic.libs.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:695)
[09:58:27 WARN]:        at me.yic.libs.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197)
[09:58:27 WARN]:        at me.yic.libs.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162)
[09:58:27 WARN]:        at me.yic.libs.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
[09:58:27 WARN]:        at me.yic.xconomy.utils.DatabaseConnection.getConnection(DatabaseConnection.java:158)
[09:58:27 WARN]:        at me.yic.xconomy.utils.DatabaseConnection.getConnectionAndCheck(DatabaseConnection.java:140)
[09:58:27 WARN]:        at me.yic.xconomy.data.sql.SQL.select(SQL.java:258)
[09:58:27 WARN]:        at me.yic.xconomy.data.DataCon.getBal(DataCon.java:83)
[09:58:27 WARN]:        at me.yic.xconomy.data.caches.Cache.getBalanceFromCacheOrDB(Cache.java:80)
[09:58:27 WARN]:        at me.yic.xconomy.depend.economy.Vault.getBalance(Vault.java:145)
[09:58:27 WARN]:        at net.milkbowl.vault.economy.AbstractEconomy.getBalance(AbstractEconomy.java:22)
[09:58:27 WARN]:        at com.extendedclip.papi.expansion.vault.VaultEcoHook.getBalance(VaultEcoHook.java:223)
[09:58:27 WARN]:        at com.extendedclip.papi.expansion.vault.VaultEcoHook.onPlaceholderRequest(VaultEcoHook.java:175)
[09:58:27 WARN]:        at com.extendedclip.papi.expansion.vault.VaultExpansion.onRequest(VaultExpansion.java:108)
[09:58:27 WARN]:        at me.clip.placeholderapi.replacer.CharsReplacer.apply(CharsReplacer.java:161)
[09:58:27 WARN]:        at me.clip.placeholderapi.PlaceholderAPI.setPlaceholders(PlaceholderAPI.java:70)
[09:58:27 WARN]:        at me.clip.placeholderapi.PlaceholderAPI.setPlaceholders(PlaceholderAPI.java:98)
[09:58:27 WARN]:        at me.neznamy.tab.platforms.bukkit.BukkitPlatform.lambda$registerUnknownPlaceholder$2(BukkitPlatform.java:187)
[09:58:27 WARN]:        at me.neznamy.tab.shared.placeholders.PlayerPlaceholderImpl.request(PlayerPlaceholderImpl.java:114)
[09:58:27 WARN]:        at me.neznamy.tab.shared.placeholders.PlayerPlaceholderImpl.update(PlayerPlaceholderImpl.java:52)
[09:58:27 WARN]:        at me.neznamy.tab.shared.features.PlaceholderManagerImpl.updatePlayerPlaceholder(PlaceholderManagerImpl.java:121)
[09:58:27 WARN]:        at me.neznamy.tab.shared.features.PlaceholderManagerImpl.refresh(PlaceholderManagerImpl.java:67)
[09:58:27 WARN]:        at me.neznamy.tab.shared.CpuManager.lambda$runMeasuredTask$8(CpuManager.java:353)
[09:58:27 WARN]:        at me.neznamy.tab.shared.CpuManager.lambda$submit$1(CpuManager.java:115)
[09:58:27 WARN]:        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
[09:58:27 WARN]:        at java.util.concurrent.FutureTask.run(Unknown Source)
[09:58:27 WARN]:        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
[09:58:27 WARN]:        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
[09:58:27 WARN]:        at java.lang.Thread.run(Unknown Source)
[09:58:27 WARN]: [TAB Processing Thread] INFO me.yic.libs.zaxxer.hikari.HikariDataSource - XConomy - Starting...
[09:58:27 WARN]: [TAB Processing Thread] INFO me.yic.libs.zaxxer.hikari.HikariDataSource - XConomy - Start completed.

[09:57:57 WARN]: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'UID' in 'where clause'
[09:57:57 WARN]:        at sun.reflect.GeneratedConstructorAccessor177.newInstance(Unknown Source)
[09:57:57 WARN]:        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[09:57:57 WARN]:        at java.lang.reflect.Constructor.newInstance(Unknown Source)
[09:57:57 WARN]:        at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[09:57:57 WARN]:        at com.mysql.jdbc.Util.getInstance(Util.java:408)
[09:57:57 WARN]:        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
[09:57:57 WARN]:        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976)
[09:57:57 WARN]:        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3912)
[09:57:57 WARN]:        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
[09:57:57 WARN]:        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
[09:57:57 WARN]:        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486)
[09:57:57 WARN]:        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
[09:57:57 WARN]:        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966)
[09:57:57 WARN]:        at me.yic.libs.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
[09:57:57 WARN]:        at me.yic.libs.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
[09:57:57 WARN]:        at me.yic.xconomy.data.sql.SQL.select(SQL.java:262)
[09:57:57 WARN]:        at me.yic.xconomy.data.DataCon.getBal(DataCon.java:83)
[09:57:57 WARN]:        at me.yic.xconomy.data.caches.Cache.getBalanceFromCacheOrDB(Cache.java:80)
[09:57:57 WARN]:        at me.yic.xconomy.depend.economy.Vault.getBalance(Vault.java:146)
[09:57:57 WARN]:        at net.milkbowl.vault.economy.AbstractEconomy.getBalance(AbstractEconomy.java:22)
[09:57:57 WARN]:        at com.extendedclip.papi.expansion.vault.VaultEcoHook.getBalance(VaultEcoHook.java:223)
[09:57:57 WARN]:        at com.extendedclip.papi.expansion.vault.VaultEcoHook.onPlaceholderRequest(VaultEcoHook.java:175)
[09:57:57 WARN]:        at com.extendedclip.papi.expansion.vault.VaultExpansion.onRequest(VaultExpansion.java:108)
[09:57:57 WARN]:        at me.clip.placeholderapi.replacer.CharsReplacer.apply(CharsReplacer.java:161)
[09:57:57 WARN]:        at me.clip.placeholderapi.PlaceholderAPI.setPlaceholders(PlaceholderAPI.java:70)
[09:57:57 WARN]:        at me.clip.placeholderapi.PlaceholderAPI.setPlaceholders(PlaceholderAPI.java:98)
[09:57:57 WARN]:        at me.neznamy.tab.platforms.bukkit.BukkitPlatform.lambda$registerUnknownPlaceholder$2(BukkitPlatform.java:187)
[09:57:57 WARN]:        at me.neznamy.tab.shared.placeholders.PlayerPlaceholderImpl.request(PlayerPlaceholderImpl.java:114)
[09:57:57 WARN]:        at me.neznamy.tab.shared.placeholders.PlayerPlaceholderImpl.update(PlayerPlaceholderImpl.java:52)
[09:57:57 WARN]:        at me.neznamy.tab.shared.features.PlaceholderManagerImpl.updatePlayerPlaceholder(PlaceholderManagerImpl.java:121)
[09:57:57 WARN]:        at me.neznamy.tab.shared.features.PlaceholderManagerImpl.refresh(PlaceholderManagerImpl.java:67)
[09:57:57 WARN]:        at me.neznamy.tab.shared.CpuManager.lambda$runMeasuredTask$8(CpuManager.java:353)
[09:57:57 WARN]:        at me.neznamy.tab.shared.CpuManager.lambda$submit$1(CpuManager.java:115)
[09:57:57 WARN]:        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
[09:57:57 WARN]:        at java.util.concurrent.FutureTask.run(Unknown Source)
[09:57:57 WARN]:        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
[09:57:57 WARN]:        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
[09:57:57 WARN]:        at java.lang.Thread.run(Unknown Source)



OOTW_Z
如果想要同步数据,不需要使用mysql,只需要在database.yml修改为例如
其中一个服务器是
SQLite:
  #Address is the folder path
  path: Default
这个服务器地址在'D:\mineserverall\Survival01\
那么另一个要同步是服务器就改为
SQLite:
  #Address is the folder path
  path: 'D:\mineserverall\Survival01\plugins\XConomy\playerdata\'
就可以实现同步数据

addc123
OOTW_Z 发表于 2022-6-28 10:08
如果想要同步数据,不需要使用mysql,只需要在database.yml修改为例如
其中一个服务器是
SQLite:

我不是一台机子开的bc,我是几台机子一起开的,没办法用本地同步

OOTW_Z
在保证Xconomy是最新版的情况下,排除数据库类写错,有如下可能:
首先你要保证数据库端口是开放的,默认3306,因为报错有链接超时java.sql.SQLTransientConnectionException: XConomy - Connection is not available, request timed out after 30001ms.
其次检查数据库、表是否是Xconomy创建的,否则表项不匹配,会引起 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'UID' in 'where clause'
最后错误相关方法名内含有papi,在上述两个确保正确后,可以删掉/更新papi来进行最后检查
其中蹦极需要改的配置有:
database.yml
Settings:
  #SQLite MySQL
  storage-type: SQLite


#MySQL settings
MySQL:
  host: localhost
  port: 3306
  user: root
  pass: root
  database: data

config.yml
BungeeCord:
  #Whether to enable BungeeCord synchronization
  #After BungeeCord sync is turned on, the console and other plugins will not be able to modify the balance in the server without player
  #Please Set bungeecord to true in the spigot.yml
  enable: false
  #Server ID, keep the ID and the MySQL settings is the same between the servers requiring synchronization
  sign: aa

addc123
OOTW_Z 发表于 2022-6-28 10:21
在保证Xconomy是最新版的情况下,排除数据库类写错,有如下可能:
首先你要保证数据库端口是开放的,默认33 ...

表是自动创建的,这个也都改了,这个插件放到bc里了,但是bc不加载他的配置文件

Lidocaine
addc123 发表于 2022-7-1 08:27
表是自动创建的,这个也都改了,这个插件放到bc里了,但是bc不加载他的配置文件 ...

BC端没有配置文件,插件启用BC即可
表名找不到字段首选考虑数据表的表名写没写对
如果你使用的是 MySQL 8 ,并且无法正常连接到数据库,请下载 DatabaseDrivers (1.17.X以上版本服务器不需要)



OOTW_Z
addc123 发表于 2022-7-1 08:27
表是自动创建的,这个也都改了,这个插件放到bc里了,但是bc不加载他的配置文件 ...

我现在总感觉你没有安装MySQL而且也没配置

addc123
OOTW_Z 发表于 2022-7-1 09:53
我现在总感觉你没有安装MySQL而且也没配置

我的playerdatasql points  BungeeSuite运行都正常的

addc123
本帖最后由 addc123 于 2022-7-1 11:24 编辑
上杉夏相 发表于 2022-7-1 09:41
BC端没有配置文件,插件启用BC即可
表名找不到字段首选考虑数据表的表名写没写对

我确实没有配置文件,是插件版本的问题么但是我看介绍里面说bc端没有配置文件https://www.mcbbs.net/forum.php?mod=viewthread&tid=962904

第一页 上一页 下一页 最后一页