Hello, I’ve got an issue on my server where when I join it doesn’t load my custom char created from esx it just loads into the default skater ped. Anyone got an idea why this might be happening?
If any other info is required let me know I’ll try to provide that info
Your issue may not be highlighted in red. Can you post server terminal output from server start to player join? Also, any errors in Citizen logs on the client side?
Capturing server terminal output would depend on what operating system you’re using to run the server.
You can find your client log files(the computer running the game and trying to connect) in C:\Users<youruser>\AppData\Local\FiveM\FiveM.app\logs and are date stamped. To make it easy, you can clear that directory with the game off, start FiveM and try to connect to that server. Once the issue occurs and after you’re fully logged in, look in that directory again and you should see the log file you need. Make a copy of that file before doing anything else so you don’t add a ton of irrelevant data to it. That copied file is what you want to look at for clientside errors.
The first thing I see is that you’re running both mysql-async and oxmysql. Remove mysql-async from your server startup as latest legacy is designed for ox:
Second, oxmysql is not connecting, it’s timing out:
[ script:mysql-async] e[0m[mysql-async] [ERROR] connect ETIMEDOUT
[ script:oxmysql] Error: Unable to establish a connection to the database! [ETIMEDOUT]
[ script:oxmysql] connect ETIMEDOUT
[script:TunningSystem] TunningSystem: AUTHENTICATED
[ script:oxmysql] e[0mSCRIPT ERROR in promise (unhandled): Error: esx_datastore was unable to execute a query!
You’re not loading characters because your server is unable to talk to your database. Fix your db issue and your game server will likely start working as intended again.
So i’ve never used oxmysql and both of them where installed when using the recipe. I’ve removed mysql from server.cfg but what else do I need to do with oxmysql?
If that was the way it was installed, it was not a good recipe that you used to build the server.
As for what else you need to do, you need to find out what’s wrong with your MySQL server. It’s refusing connection so it’s either not running or refusing connection from your game server(bad connection info, remote connect blocked, etc.)
I think i understand what you’re saying in the two posts but it’s something you can’t argue that your problem server is unable to connect to your mysql server. It’s not a fivem or esx issue, it’s a mysql connection issue. Double check your connecting info in your server.cfg and if you can’t connect with the proper connection credentials, contact your host to find out why.
But I mean it’s so weird because it worked after I created the server than suddely it didn’t. I thought it was because I added some maps but I removed those it was still happening. I also tried to remove the custom clothes I just added and it didn’t do much either