Help with mysql async

FiveM Resource Development Discussion
1

Hi,

I want to know how to connect mysql async.
This is on server.cfg ?

My server.cfg

# you probably don't want to change these!
# only change them if you're using a server with multiple network interfaces
endpoint_add_tcp "0.0.0.0:30120"
endpoint_add_udp "0.0.0.0:30120"

start mapmanager
start chat
start spawnmanager
start fivem
start ■■■■■■■
start mysql-async
start essentialmode
start esplugin_mysql
start es_admin
start foodhud

set es_enableCustomData 1
sv_scriptHookAllowed 1

set mysql_connection_string "server=127.0.0.1;database=essentialmode;userid=root;password=mypassword"

# change this
rcon_password mypassword

sv_hostname "SERVEUR EN DEV."

# nested configs!
#exec server_internal.cfg

# loading a server icon (96x96 PNG file)
#load_server_icon myLogo.png

# disable announcing? clear out the master by uncommenting this
#sv_master1 ""

# want to only allow players authenticated with a third-party provider like Steam?
#sv_authMaxVariance 1
#sv_authMinTrust 5

I try new plugin to have essentials with mysql (esplugin_mysql) but nothing happens, my player on CouchDB don’t export to mysql…
Thank you for your help

2

Put set es_enableCustomData 1 before start essentialmode

3

Thank you for your help but it still don’t work…

4

So it works but you can’t export your player, right ? If so you have to do it yourself there is no tool for that.

5

Its work now :joy:

Your solution good work :wink:

Now I have a other problem with banking… Its said I have 100$ on my DB but in game 0

    276047] Error running call reference function for resource banking: server.lua:24: attempt to index a nil value
[    276047] stack traceback:
[    276047] 	server.lua:24: in function 'bankBalance'
[    276047] 	server.lua:28: in function 'deposit'
[    276047] 	server.lua:81: in local 'ref'
[    276047] 	citizen:/scripting/lua/scheduler.lua:277: in function <citizen:/scripting/lua/scheduler.lua:268>
[    276047] 	[C]: in function 'coroutine.resume'
[    276047] 	citizen:/scripting/lua/scheduler.lua:33: in field 'CreateThreadNow'
[    276047] 	citizen:/scripting/lua/scheduler.lua:123: in function <citizen:/scripting/lua/scheduler.lua:92>
[    276125] Error running system event handling function for resource essentialmode: citizen:/scripting/lua/scheduler.lua:39: Failed to execute thread: citizen:/scripting/lua/MessagePack.lua:830: missing bytes
[    276125] stack traceback:
[    276125] 	[C]: in function 'error'
[    276125] 	citizen:/scripting/lua/MessagePack.lua:830: in method 'underflow'
[    276125] 	citizen:/scripting/lua/MessagePack.lua:465: in field 'any'
[    276125] 	citizen:/scripting/lua/MessagePack.lua:860: in field 'unpack'
[    276125] 	citizen:/scripting/lua/scheduler.lua:338: in local 'cb'
[    276125] 	server/player/login.lua:85: in upvalue 'handler'
[    276125] 	citizen:/scripting/lua/scheduler.lua:124: in function <citizen:/scripting/lua/scheduler.lua:123>
[    276125] stack traceback:
[    276125] 	[C]: in function 'error'
[    276125] 	citizen:/scripting/lua/scheduler.lua:39: in field 'CreateThreadNow'
[    276125] 	citizen:/scripting/lua/scheduler.lua:123: in function <citizen:/scripting/lua/scheduler.lua:92>