Es_extended error and citizen

Culc07 · June 1, 2019, 8:20am

Hello, I not can resolve this problem, I’ve been here for a week, “using google traductor”

Sending heartbeat to live-internal.fivem.net:30110
server thread hitch warning: timer interval of 391 milliseconds
Error running call reference function for resource es_extended: citizen:/scripting/lua/scheduler.lua:405: @es_extended/server/main.lua:133: attempt to index a nil value (field '?')
stack traceback:
        @es_extended/server/main.lua:133: in upvalue 'ref'
        citizen:/scripting/lua/scheduler.lua:391: in function <citizen:/scripting/lua/scheduler.lua:390>
        [C]: in function 'xpcall'
        citizen:/scripting/lua/scheduler.lua:390: in function <citizen:/scripting/lua/scheduler.lua:389>
stack traceback:
        [C]: in function 'error'
        citizen:/scripting/lua/scheduler.lua:405: in function <citizen:/scripting/lua/scheduler.lua:374>
Error: Unhandled error in timer: Error: BUFFER_SHORTAGE
Error: BUFFER_SHORTAGE
    at n.e [as reserve] (citizen:/scripting/v8/msgpack.js:29:12766)
    at h (citizen:/scripting/v8/msgpack.js:29:15761)
    at n.r [as decode] (citizen:/scripting/v8/msgpack.js:29:13908)
    at n.fetch (citizen:/scripting/v8/msgpack.js:29:6972)
    at n.u [as read] (citizen:/scripting/v8/msgpack.js:29:12076)
    at Object.n [as decode] (citizen:/scripting/v8/msgpack.js:29:7097)
    at unpack (citizen:/scripting/v8/main.js:20:33)
    at citizen:/scripting/v8/main.js:51:20
    at setImmediate (mysql-async.js:14898:7)
    at Object.callback (citizen:/scripting/v8/timer.js:96:21)

Calipo · June 1, 2019, 8:23am

Send your server.cfg Please

Culc07 · June 1, 2019, 8:45am


# 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 sessionmanager
start fivem
start hardcap
start ■■■■■■■
start scoreboard
start playernames
start vk_loadingscreen
start es_admin2
start essentialmode
start esx_addonaccount


start mysql-async
start essentialmode
start esplugin_mysql

start es_extended

start esx_menu_default
start esx_menu_list
start esx_menu_dialog

sv_scriptHookAllowed 0

# change this
rcon_password changeme

sv_hostname "RICOS RP"

# nested configs!
#exec server_internal.cfg

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

# convars for use from script
set temp_convar "hey world!"

# 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

set es_enableCustomData 1
set mysql_connection_string “server = 127.0.0.1; database = essentialmode; userid = root”
add_ace resource.essentialmode command.sets allow
add_ace resource.essentialmode command.add_principal allow
add_ace resource.essentialmode command.add_ace allow

# add system admins
add_ace group.admin command allow # allow all commands
add_ace group.admin command.quit deny # but don't allow quit
add_principal identifier.steam:110000112345678 group.admin # add the admin to the group

# remove the # to hide player endpoints in external log output
#sv_endpointprivacy true

# server slots limit (must be between 1 and 31)
sv_maxclients 32

Calipo · June 1, 2019, 8:53am

I see that you need async in your list of resources also add these two lines above all of your server.cfg, clean the cache and tell me if your problem was solved

set es_enableCustomData 1

set mysql_connection_string “server=localhost;database=essentialmode;userid=root”

Culc07 · June 1, 2019, 9:12am

Started map fivem-map-skater
Started resource fivem-map-skater
Error: (node:14140) UnhandledPromiseRejectionWarning: Error: No valid connection string found
    at parseConnectingString (mysql-async.js:14881:16)
    at global.on (mysql-async.js:5146:16)
    at citizen:/scripting/v8/main.js:204:28
Error: (node:14140) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (rejection id: 1)
Error: (node:14140) [DEP0018] DeprecationWarning: Unhandled promise rejections are deprecated. In the future, promise rejections that are not handled will terminate the Node.js process with a non-zero exit code.

Calipo · June 1, 2019, 9:21am

it seems that your server can not connect to your database verify that the credentials in

set mysql_connection_string

are equal to those of your database and that it does not contain spaces and upload it to line 1 of your server.cfg

Like this:

Very Important

set es_enableCustomData 1

set mysql_connection_string “server=localhost;database=essentialmode;userid=root”

For More Interfaces

endpoint_add_tcp “0.0.0.0:30120”
endpoint_add_udp “0.0.0.0:30120”
sv_maxclients 32

Culc07 · June 1, 2019, 9:27am

Started map fivem-map-skater
Started resource fivem-map-skater
Error: (node:12064) UnhandledPromiseRejectionWarning: Error: No valid connection string found
    at parseConnectingString (mysql-async.js:14881:16)
    at global.on (mysql-async.js:5146:16)
    at citizen:/scripting/v8/main.js:204:28
Error: (node:12064) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (rejection id: 1)
Error: (node:12064) [DEP0018] DeprecationWarning: Unhandled promise rejections are deprecated. In the future, promise rejections that are not handled will terminate the Node.js process with a non-zero exit code.

# 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 sessionmanager
start fivem
start hardcap
start ■■■■■■■
start scoreboard
start playernames
start vk_loadingscreen
start es_admin2
start essentialmode
start esx_addonaccount
start async

start mysql-async
start essentialmode
start esplugin_mysql

start es_extended

start esx_menu_default
start esx_menu_list
start esx_menu_dialog

sv_scriptHookAllowed 0

# change this
rcon_password changeme

sv_hostname "RICOS RP"

# nested configs!
#exec server_internal.cfg

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

# convars for use from script
set temp_convar "hey world!"

# 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

set database_driver "mysql-async"
set es_enableCustomData 1
set mysql_connection_string “server=127.0.0.1;database=essentialmode;userid=root”

# add system admins
add_ace group.admin command allow # allow all commands
add_ace group.admin command.quit deny # but don't allow quit
add_principal identifier.steam:110000112345678 group.admin # add the admin to the group

# remove the # to hide player endpoints in external log output
#sv_endpointprivacy true

# server slots limit (must be between 1 and 31)
sv_maxclients 32

Calipo · June 1, 2019, 9:33am

I send you my Server.cfg
asegurese de que mi trozo sea como el suyo y que su sql tenga las credenciales de

set mysql_connection_string

Si no es asi, cambielas

on my .cfg :
Here you can see what order should bring the resources

ZerefGG · June 1, 2019, 9:35am

Why starting essentialmode 2 times? Remove the first one and put es_admin2 below the 2nd essentialmode

And put the connection string above everything

Calipo · June 1, 2019, 9:36am

Good note, friend, I had not noticed
Thank you for helping

Culc07 · June 1, 2019, 9:38am

Started map fivem-map-hipster
Started resource fivem-map-hipster
Error: (node:14676) UnhandledPromiseRejectionWarning: Error: No valid connection string found
    at parseConnectingString (mysql-async.js:14881:16)
    at global.on (mysql-async.js:5146:16)
    at citizen:/scripting/v8/main.js:204:28
Error: (node:14676) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (rejection id: 1)
Error: (node:14676) [DEP0018] DeprecationWarning: Unhandled promise rejections are deprecated. In the future, promise rejections that are not handled will terminate the Node.js process with a non-zero exit code.

[EssentialMode] Current version: 6.2.1
[EssentialMode] Updater version: 6.2.1

Access denied for command sets.
Access denied for command sets.
[EssentialMode] Everything is nice and updated!

# 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 sessionmanager
start fivem
start hardcap
start rconlog
start scoreboard
start playernames
start vk_loadingscreen
start esx_addonaccount
start async

start mysql-async
start essentialmode
start es_admin2
start esplugin_mysql

start es_extended

start esx_menu_default
start esx_menu_list
start esx_menu_dialog

sv_scriptHookAllowed 0

# change this
rcon_password changeme

sv_hostname "RICOS RP"

# nested configs!
#exec server_internal.cfg

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

# convars for use from script
set temp_convar "hey world!"

# 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

set database_driver "mysql-async"
set es_enableCustomData 1
set mysql_connection_string “server=127.0.0.1;database=essentialmode;userid=root”

# add system admins
add_ace group.admin command allow # allow all commands
add_ace group.admin command.quit deny # but don't allow quit
add_principal identifier.steam:110000112345678 group.admin # add the admin to the group

# remove the # to hide player endpoints in external log output
#sv_endpointprivacy true

# server slots limit (must be between 1 and 31)
sv_maxclients 32

Calipo · June 1, 2019, 9:41am

You must upload this line and put it first

Culc07 · June 1, 2019, 9:48am

¿?

set mysql_connection_string “server=127.0.0.1;database=essentialmode;userid=root”
set database_driver "mysql-async"
set es_enableCustomData 1

Calipo · June 1, 2019, 9:51am

Notice in what order the resources and the mysql_connection_string are placed in my server.cfg
and replicate it in your cfg

Culc07 · June 1, 2019, 9:53am

Can you send me the order? Esque I do not clarify
by the way, thank you very much for the help “using google translator”

Culc07 · June 1, 2019, 9:56am

that’s OK?

# you probably don't want to change these!
set es_enableCustomData 1
set mysql_connection_string "server=127.0.0.1;database=essentialmode;userid=root"

# 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 sessionmanager
start fivem
start hardcap
start ■■■■■■■
start scoreboard
start playernames
start vk_loadingscreen
start esx_addonaccount
start async

start mysql-async
start essentialmode
start es_admin2
start esplugin_mysql

start es_extended

start esx_menu_default
start esx_menu_list
start esx_menu_dialog

sv_scriptHookAllowed 0

# change this
rcon_password changeme

sv_hostname "RICOS RP"

# nested configs!
#exec server_internal.cfg

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

# convars for use from script
set temp_convar "hey world!"

# 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

set database_driver "mysql-async"

# add system admins
add_ace group.admin command allow # allow all commands
add_ace group.admin command.quit deny # but don't allow quit
add_principal identifier.steam:110000112345678 group.admin # add the admin to the group

# remove the # to hide player endpoints in external log output
#sv_endpointprivacy true

# server slots limit (must be between 1 and 31)
sv_maxclients 32

Calipo · June 1, 2019, 9:57am

Correct order

set es_enableCustomData 1
set mysql_connection_string “server=localhost;database=essentialmode;userid=root”

endpoint_add_tcp “0.0.0.0:30120”

endpoint_add_udp “0.0.0.0:30120”

sv_maxclients 32

start mapmanager

start chat

start spawnmanager

start sessionmanager

start fivem

start hardcap

start rconlog

start mysql-async

start essentialmode

start esplugin_mysql

start es_admin2

start async

Culc07 · June 1, 2019, 9:58am

Thanks!!!
I am very grateful

Calipo · June 1, 2019, 9:59am

I’m funny to see you help. Of course I use Google translator I am Spanish and my English is poor