java.io.IOException: Bad packet id 71
Kaos1337 opened this issue ยท 7 comments
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
Added a SQL query dump on 7.2 to visualize the error next time, let me know if it happens again
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
Here you can see all worlds that I have: http://mine.mc-evolution.it:8123/
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.