PreciousStones

PreciousStones

269k Downloads

java.io.IOException: Bad packet id 71

Kaos1337 opened this issue ยท 7 comments

commented

Hi,
I would report 2 errors:
1- java.io.IOException: Bad packet id 71
2- Error at SQL DELETE Query
Regards.

2011-12-13 14:36:22 [INFO] [PreciousStones] Version 7.0.6 loaded
2011-12-13 14:36:22 [INFO] [PreciousStones] MySQL Connection successful
2011-12-13 14:36:24 [INFO] PreciousStones fields purged: 2
2011-12-13 14:36:25 [INFO] PreciousStones fields: 28,589
2011-12-13 14:36:25 [INFO] PreciousStones fields: 1
2011-12-13 14:36:26 [INFO] Connection reset
2011-12-13 14:36:34 [SEVERE] java.io.IOException: Bad packet id 71
2011-12-13 14:36:34 [SEVERE] at net.minecraft.server.Packet.a(Packet.java:71)
2011-12-13 14:36:34 [SEVERE] at net.minecraft.server.NetworkManager.h(NetworkManager.java:149)
2011-12-13 14:36:34 [SEVERE] at net.minecraft.server.NetworkManager.c(NetworkManager.java:263)
2011-12-13 14:36:34 [SEVERE] at net.minecraft.server.NetworkReaderThread.run(SourceFile:77)
2011-12-13 14:36:35 [INFO] PreciousStones fields: 23,619
2011-12-13 14:36:35 [INFO] PreciousStones fields: 2,994
2011-12-13 14:36:35 [INFO] PreciousStones fields purged: 1
2011-12-13 14:36:35 [INFO] PreciousStones fields: 2,897
2011-12-13 14:36:35 [INFO] PreciousStones fields: 2,305
2011-12-13 14:36:35 [INFO] PreciousStones fields: 12
2011-12-13 14:36:35 [INFO] PreciousStones fields: 1
2011-12-13 14:36:35 [SEVERE] Error at SQL DELETE Query: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 's'' at line 1
2011-12-13 14:36:36 [INFO] [PreciousStones] players purged: 2
2011-12-13 14:36:36 [INFO] [PreciousStones] Payment method: iConomy v6
2011-12-13 14:36:36 [SEVERE] Error at SQL DELETE Query: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 's'' at line 1

commented

Added a SQL query dump on 7.2 to visualize the error next time, let me know if it happens again

commented

Hi,
what can I do to fix it? and what about the first error?
Regards.

commented

Do any of your world names have 's by any chance?

commented

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 's'' at line

Looks like the apostrophe in the 's is messing it up. Most likely not escaping the quotes for some variable (Helper.escapeQuotes()) in one of the delete functions in the StorageManager

commented

Here you can see all worlds that I have: http://mine.mc-evolution.it:8123/

commented

I could not locate the issue in a code review, but I did clean up the code in question, after which I went through and named fields with 's allowed players with 's and I can't reproduce this issue. Will release soon.

commented

In which version will be fixed that?
Regards.