Post by EDGECOM on Sept 26, 2018 22:09:36 GMT
I have found a bug that happens when a player clicks on the Join Game or tries to spawn on a map it will crash the server its random it will do it on one or the other.
The Problem is corrupted player id this happens when the server hits end round and is updating the stats and the players client crashes at the same time causing the server to corrupt the player data
so every time the player tried to join or spawn it would crash the server because it could not find a matching player it or it was pulling data form another ID.
FIX:
delete the game spy and stats data for the account that is crashing the server
1. login to the MySQL server with phpmyadmin or your favorite MySQL server manager if you are using xammp open the xammp control panel click admin button next to MySQL.
2. click bf2142 database or what ever you changed the named to.
3. click account get the profile id of the account
4. click awards delete the records that match the id from the previous step
5. click gamespy_player delete the pid record/s with the id
6. click playerprogress delete the pid record/s with the id
7. click stats_a delete the pid record/s with the id
8. click stats_e delete the pid record/s with the id
9. click stats_m delete the pid record/s with the id
10. click stats_w delete the pid record/s with the id
11. Have the player try to login and see if that fixes the issue
If that does not work have the player make a new account
The Problem is corrupted player id this happens when the server hits end round and is updating the stats and the players client crashes at the same time causing the server to corrupt the player data
so every time the player tried to join or spawn it would crash the server because it could not find a matching player it or it was pulling data form another ID.
FIX:
delete the game spy and stats data for the account that is crashing the server
1. login to the MySQL server with phpmyadmin or your favorite MySQL server manager if you are using xammp open the xammp control panel click admin button next to MySQL.
2. click bf2142 database or what ever you changed the named to.
3. click account get the profile id of the account
4. click awards delete the records that match the id from the previous step
5. click gamespy_player delete the pid record/s with the id
6. click playerprogress delete the pid record/s with the id
7. click stats_a delete the pid record/s with the id
8. click stats_e delete the pid record/s with the id
9. click stats_m delete the pid record/s with the id
10. click stats_w delete the pid record/s with the id
11. Have the player try to login and see if that fixes the issue
If that does not work have the player make a new account