I keep having issues setting up my server with essentialmode 5.0.2 and esmysql plugin. I’ve been banging my head against the wall for days with this trying mysql-async and esplugin_mysql, even trying the last essentialmode 4. I’ve cleared cache after each attempt. Any help would be grand.
Need help… I also tried replacing the mysql-async with this and it still did the same thing… not sure if this is the right place… having issues finding where to put this…??
GTA V version Is up to date
Up to date? Yes
Legit or Pirate copy? Legit
Steam/CD/Social Club?: Bought Through Steam
Windows version? Windows 10
Did you try to delete caches.xml and try again? Yes
Error screenshot (if any)https://cdn.discordapp.com/attachments/361144124318941206/443614463099404292/unknown.png 4
System specifications Base Alienwar Alpha with i7 and 12 Gb RAM
What did you do to get this issue?Tried to host the server, already spoke with the cops_fivem people and pointed me to you guys after about 2 hours of trying things
What server did you get this issue on? Trying to host my own
CitizenFX.log filehttps://www.pastefile.com/8v2xqd
.dmp files/report IDs None/IDK how to get them
If an issue with starting:
Also add what you already tried so far.
Already tried replacing mysql-async, re-writing my config.cfg, restarting from scratch twice
Wait I got it to work by replacing mysql-async… my issue is I have a pluggin that requires mysql-async… is it possible for my to simpyl change the name of this folder to mysql-async?
[ERROR] [MySQL] An error happens on MySQL for query “SELECT * FROM items {=}”: Unable to connect to any of the specified MySQL hosts.
[ERROR] [MySQL] An error happens on MySQL for query “SELECT * FROM items {=}”: Unable to connect to any of the specified MySQL hosts.
[ERROR] [MySQL] An error happens on MySQL for query “SELECT * FROM shops {=}”: Unable to connect to any of the specified MySQL hosts.
Error running system event handling function for resource esx_shop: citizen:/scripting/lua/scheduler.lua:41: Failed to execute thread: server/main.lua:28: attempt to get length of a nil value (local ‘itemResult’)
stack traceback:
server/main.lua:28: in function ‘LoadShop’
server/main.lua:10: in upvalue ‘handler’
citizen:/scripting/lua/scheduler.lua:219: in function citizen:/scripting/lua/scheduler.lua:218
stack traceback:
[C]: in function ‘error’
citizen:/scripting/lua/scheduler.lua:41: in field ‘CreateThreadNow’
citizen:/scripting/lua/scheduler.lua:218: in function citizen:/scripting/lua/scheduler.lua:182
[ERROR] [MySQL] An error happens on MySQL for query “SELECT * FROM items {=}”: Unable to connect to any of the specified MySQL hosts.
Error running system event handling function for resource esx_addoninventory: citizen:/scripting/lua/scheduler.lua:41: Failed to execute thread: server/main.lua:14: attempt to get length of a nil value (local ‘items’)
stack traceback:
server/main.lua:14: in upvalue ‘handler’
citizen:/scripting/lua/scheduler.lua:219: in function citizen:/scripting/lua/scheduler.lua:218
stack traceback:
[C]: in function ‘error’
citizen:/scripting/lua/scheduler.lua:41: in field ‘CreateThreadNow’
citizen:/scripting/lua/scheduler.lua:218: in function citizen:/scripting/lua/scheduler.lua:182
[ERROR] [MySQL] An error happens on MySQL for query “SELECT * FROM addon_account {=}”: Unable to connect to any of the specified MySQL hosts.
Error running system event handling function for resource esx_addonaccount: citizen:/scripting/lua/scheduler.lua:41: Failed to execute thread: server/main.lua:12: attempt to get length of a nil value (local ‘result’)
stack traceback:
server/main.lua:12: in upvalue ‘handler’
citizen:/scripting/lua/scheduler.lua:219: in function citizen:/scripting/lua/scheduler.lua:218
stack traceback:
[C]: in function ‘error’
citizen:/scripting/lua/scheduler.lua:41: in field ‘CreateThreadNow’
citizen:/scripting/lua/scheduler.lua:218: in function citizen:/scripting/lua/scheduler.lua:182
[ERROR] [MySQL] An error happens on MySQL for query “UPDATE owned_vehicles SET stored = true WHERE stored = @stored AND vehicleType = @vehicleType {@stored=False;@vehicleType=boat}”: Unable to connect to any of the specified MySQL hosts.
[ERROR] [MySQL] An error happens on MySQL for query “SELECT * FROM datastore {=}”: Unable to connect to any of the specified MySQL hosts.
Error running system event handling function for resource esx_datastore: citizen:/scripting/lua/scheduler.lua:41: Failed to execute thread: server/main.lua:14: attempt to get length of a nil value (local ‘result’)
stack traceback:
server/main.lua:14: in upvalue ‘handler’
citizen:/scripting/lua/scheduler.lua:219: in function citizen:/scripting/lua/scheduler.lua:218
stack traceback:
[C]: in function ‘error’
citizen:/scripting/lua/scheduler.lua:41: in field ‘CreateThreadNow’
citizen:/scripting/lua/scheduler.lua:218: in function citizen:/scripting/lua/scheduler.lua:182
[ERROR] [MySQL] An error happens on MySQL for query “UPDATE owned_vehicles SET state=true WHERE state=false {=}”: Unable to connect to any of the specified MySQL hosts.
[ERROR] [MySQL] An error happens on MySQL for query “SELECT * FROM properties {=}”: Unable to connect to any of the specified MySQL hosts.
[ERROR] [MySQL] An error happens on MySQL for query “SELECT * FROM jobs {=}”: Unable to connect to any of the specified MySQL hosts.
Error running system event handling function for resource esx_society: citizen:/scripting/lua/scheduler.lua:41: Failed to execute thread: server/main.lua:19: attempt to get length of a nil value (local ‘result’)
stack traceback:
server/main.lua:19: in upvalue ‘handler’
citizen:/scripting/lua/scheduler.lua:219: in function citizen:/scripting/lua/scheduler.lua:218
stack traceback:
[C]: in function ‘error’
citizen:/scripting/lua/scheduler.lua:41: in field ‘CreateThreadNow’
citizen:/scripting/lua/scheduler.lua:218: in function citizen:/scripting/lua/scheduler.lua:182
[ERROR] [MySQL] An error happens on MySQL for query “SELECT * FROM vehicle_categories {=}”: Unable to connect to any of the specified MySQL hosts.
[ERROR] [MySQL] An error happens on MySQL for query “SELECT * FROM vehicles {=}”: Unable to connect to any of the specified MySQL hosts.
Error running system event handling function for resource esx_vehicleshop: citizen:/scripting/lua/scheduler.lua:41: Failed to execute thread: server/main.lua:28: attempt to get length of a nil value (local ‘vehicles’)
