Closed killbot24 closed 3 months ago
ok, just disable the chat sync.
Even with it off and set to sync just world https://spark.lucko.me/nEjafAb4oR Weirdly does still say chat sync
Even with it off and set to sync just world https://spark.lucko.me/nEjafAb4oR Weirdly does still say chat sync
Have you restarted the server?
Yes
Thanks for testing. No one met this problem before. Try the newest action https://github.com/mlus-asuka/PlayerSync/actions/runs/9418399285
Running 20 now, I will see how it does under load later
I refactored chat sync implementation, it use web socket instead of mysql now. if you are interested, you could try it by download the newest action. Thanks
Haven't got around to testing it yet, Server in development I did notice that it doesn't always load the player's data when they join a server
Tryed on the newer version I get [14:50:49] [Server thread/ERROR] [minecraft/MinecraftServer]: Uncaught exception in server thread java.sql.SQLSyntaxErrorException: 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 '-Sync' at line 1 & No suitable driver found for jdbc:mysql
Tryed on the newer version I get [14:50:49] [Server thread/ERROR] [minecraft/MinecraftServer]: Uncaught exception in server thread java.sql.SQLSyntaxErrorException: 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 '-Sync' at line 1 & No suitable driver found for jdbc:mysql
Use the all one. And I can't found any string with '-Sync' in my codes, see through your config
My database contains a -Sync in the db name
Likely the issue Cant change that
https://github.com/mlus-asuka/PlayerSync/actions/runs/10010511237 this one might fix the issue
Still a issue java.sql.SQLSyntaxErrorException: 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 ''s3899_Player-Sync'' at line 1
Nvm, that's a me issue....
Nope still have it java.sql.SQLSyntaxErrorException: 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 ' 's3899_player' ' at line 1
I see, so your database name is s3899_player. Just write your config like this db_name = "s3899_Player-Sync
"
have ` on both before and after
I did figure it out, keept giveing me errors on the -Sync so just put down playersync, Oddly also had errors on s3899_player
So new issue, At times on relog in after restart players wont have their stuff, no errors
So new issue, At times on relog in after restart players wont have their stuff, no errors
what's their inventory data in database look like? (when quit game and join game again)
I mean would their data in database be updated if they don't have their stuff? And server_info enable
would be true or false?
Same problem founded on my 1.20.1 server
Noticed that players can't send chat
they can get their inventory normally
disabled chat sync
[13:55:56] [ForkJoinPool.commonPool-worker-3/ERROR] [ne.mi.ev.EventBus/EVENTBUS]: Exception caught during firing event: No database selected
Index: 3
Listeners:
0: HIGH
1: ASM: class dev.architectury.event.forge.EventHandlerImplCommon event(Lnet/minecraftforge/event/ServerChatEvent;)V
2: NORMAL
3: ASM: class vip.fubuki.playersync.sync.ChatSync onPlayerChat(Lnet/minecraftforge/event/ServerChatEvent;)V
4: ASM: me.desht.pneumaticcraft.common.event.MiscEventHandler@1d8f08e0 quetziMoo(Lnet/minecraftforge/event/ServerChatEvent;)V
5: ASM: net.montoyo.wd.WebDisplays@6736aa5f onServerChat(Lnet/minecraftforge/event/ServerChatEvent;)V
6: ASM: class vip.fubuki.playersync.sync.VanillaSync onUpdate(Lnet/minecraftforge/eventbus/api/Event;)V
7: LOWEST
8: ASM: class dev.architectury.event.forge.EventHandlerImplCommon eventAfter(Lnet/minecraftforge/event/ServerChatEvent;)V
java.sql.SQLException: No database selected
at TRANSFORMER/mysql_jdbc@8.0.28+20220312/com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
at TRANSFORMER/mysql_jdbc@8.0.28+20220312/com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at TRANSFORMER/mysql_jdbc@8.0.28+20220312/com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
at TRANSFORMER/mysql_jdbc@8.0.28+20220312/com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1098)
at TRANSFORMER/mysql_jdbc@8.0.28+20220312/com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1046)
at TRANSFORMER/mysql_jdbc@8.0.28+20220312/com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1371)
at TRANSFORMER/mysql_jdbc@8.0.28+20220312/com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1031)
at TRANSFORMER/playersync@1.20.1-1.3.2/vip.fubuki.playersync.sync.ChatSync.onPlayerChat(ChatSync.java:29)
at TRANSFORMER/playersync@1.20.1-1.3.2/vip.fubuki.playersync.sync.__ChatSync_onPlayerChat_ServerChatEvent.invoke(.dynamic)
at MC-BOOTSTRAP/net.minecraftforge.eventbus/net.minecraftforge.eventbus.ASMEventHandler.invoke(ASMEventHandler.java:73)
at MC-BOOTSTRAP/net.minecraftforge.eventbus/net.minecraftforge.eventbus.EventBus.post(EventBus.java:315)
at MC-BOOTSTRAP/net.minecraftforge.eventbus/net.minecraftforge.eventbus.EventBus.post(EventBus.java:296)
at TRANSFORMER/forge@47.2.0/net.minecraftforge.common.ForgeHooks.onServerChatSubmittedEvent(ForgeHooks.java:412)
at TRANSFORMER/forge@47.2.0/net.minecraftforge.common.ForgeHooks.lambda$getServerChatSubmittedDecorator$0(ForgeHooks.java:422)
at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1768)
at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.exec(CompletableFuture.java:1760)
at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:387)
at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1311)
at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1840)
at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1806)
at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:177)
[13:55:56] [ForkJoinPool.commonPool-worker-3/ERROR] [minecraft/FutureChain]: Chain link failed, continuing to next one
java.sql.SQLException: No database selected
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~[?:?] {re:classloading}
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[?:?] {re:classloading}
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) ~[?:?] {re:classloading}
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1098) ~[?:?] {re:classloading}
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1046) ~[?:?] {re:classloading}
at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1371) ~[?:?] {re:classloading}
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1031) ~[?:?] {re:classloading}
at vip.fubuki.playersync.sync.ChatSync.onPlayerChat(ChatSync.java:29) ~[?:?] {re:classloading}
at vip.fubuki.playersync.sync.__ChatSync_onPlayerChat_ServerChatEvent.invoke(.dynamic) ~[?:?] {re:classloading,pl:eventbus:B}
at net.minecraftforge.eventbus.ASMEventHandler.invoke(ASMEventHandler.java:73) ~[eventbus-6.0.5.jar%2352!/:?] {}
at net.minecraftforge.eventbus.EventBus.post(EventBus.java:315) ~[eventbus-6.0.5.jar%2352!/:?] {}
at net.minecraftforge.eventbus.EventBus.post(EventBus.java:296) ~[eventbus-6.0.5.jar%2352!/:?] {}
at net.minecraftforge.common.ForgeHooks.onServerChatSubmittedEvent(ForgeHooks.java:412) ~[?:?] {re:mixin,re:classloading,pl:mixin:APP:mixins.hammerlib.json:ForgeHooksMixin,pl:mixin:A}
at net.minecraftforge.common.ForgeHooks.lambda$getServerChatSubmittedDecorator$0(ForgeHooks.java:422) ~[?:?] {re:mixin,re:classloading,pl:mixin:APP:mixins.hammerlib.json:ForgeHooksMixin,pl:mixin:A}
at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1768) ~[?:?] {}
at java.util.concurrent.CompletableFuture$AsyncSupply.exec(CompletableFuture.java:1760) ~[?:?] {}
at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:387) ~[?:?] {}
at java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1311) ~[?:?] {}
at java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1840) ~[?:?] {re:mixin,re:computing_frames}
at java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1806) ~[?:?] {re:mixin,re:computing_frames}
at java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:177) ~[?:?] {re:mixin}
Noticed my server lagged a fair bit with the mod on https://spark.lucko.me/19QDWjqXae Anything can be done about that?