Es_extended error! HELP!

I added all the necessary esx resources to my server using a tutorial video, I also setup the mysql with HeidiSQL. Although when I enter a command like /dv or /giveitem a error pops up.

I have es_extended v.1.10.0 . Also on my SQL panel no users show up like in some of the videos I’ve watched.

server.cfg ?

1 Like

Its trying to get data from a database named fivem not essentialmode

how do i fix that?

change your connection string database name from fivem to essentialmode

1 Like

set mysql_connection string "server=127.0.0.1;database=essentialmode;userid=root;password="
it is isn’t it?

yes it is

that’s what i had from the beginning

image
Well here it sounds like its trying to get a database called “fivem”

thats an error from mysql-async. is there like a config for that alone?

not sure i dont use mysql-async

# This is NOT supposed to be enough for a fully running server.
# Please read the fivem documentation:
#   https://docs.fivem.net/docs/server-manual/server-commands/
#   https://docs.fivem.net/docs/server-manual/setting-up-a-server/

## You CAN edit the following:
endpoint_add_tcp "0.0.0.0:30120"
endpoint_add_udp "0.0.0.0:30120"
sv_maxclients 48
set steam_webApiKey "435C52BA44297C755F8518EDC3955BCF"
sets tags "default, deployer"

#ESX
ensure essentialmode
ensure mysql_async
ensure esplugin_mysql
ensure es_extended
ensure async
ensure fxmigrant
ensure rc_mine
ensure rc_minerJob
ensure rc_notify
ensure trew_hud_ui

#DATABASE
set mysql_connection string "server=127.0.0.1;database=essentialmode;userid=root;password="
set es_enableCustomData 1

## You MAY edit the following:
sv_licenseKey "spyqrrsmbtr48tmnhzpai5ahuis90qqs"
sv_hostname "Chimes built with CFX Default by Tabarra!"
sets sv_projectName "[CFX Default] Chimes"
sets sv_projectDesc "Recipe for the base resources required to run a minimal FiveM server."
sets locale "root-AQ" 



## These resources will start by default.
ensure cars
ensure esx_lscustom-master
ensure mapmanager
ensure chat
ensure chat-theme-gtao
ensure spawnmanager
ensure sessionmanager
ensure basic-gamemode
ensure hardcap
ensure CarCommand
ensure FCV
ensure Loading
ensure LegacyFuel-master
ensure fivem-map-hipster
ensure xnOnlineGarage-1.0.4
ensure lscustoms

#ESX
ensure essentialmode
ensure mysql_async
ensure esplugin_mysql
ensure es_extended
ensure async
ensure fxmigrant
ensure rc_mine
ensure rc_minerJob
ensure rc_notify
ensure trew_hud_ui

## 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.fivem:2105283 group.admin #InCrafter

ensure EasyAdmin

setr ea_LanguageName "en"                # set our language to english
set ea_moderationNotification "false"

add_ace group.admin easyadmin allow```

Ah nevermind i googled someone elses config.cfg and now it works

#DATABASE
set mysql_connection string “server=127.0.0.1;database=fivem;userid=root;password=”
set es_enableCustomData 1

Solution

# This is NOT supposed to be enough for a fully running server.
# Please read the fivem documentation:
#   https://docs.fivem.net/docs/server-manual/server-commands/
#   https://docs.fivem.net/docs/server-manual/setting-up-a-server/

## You CAN edit the following:
endpoint_add_tcp "0.0.0.0:30120"
endpoint_add_udp "0.0.0.0:30120"
sv_maxclients 48
set steam_webApiKey "435C52BA44297C755F8518EDC3955BCF"
sets tags "default, deployer"

add_ace resource.essentialmode command.sets allow
add_ace resource.essentialmode command.add_principal allow
add_ace resource.essentialmode command.add_ace allow


#ESX
ensure essentialmode
ensure mysql_async
ensure esplugin_mysql
ensure es_extended
ensure async
ensure fxmigrant
ensure rc_mine
ensure rc_minerJob
ensure rc_notify
ensure trew_hud_ui

#DATABASE
set mysql_connection_string "server=localhost;database=essentialmode;userid=root;"
set es_enableCustomData 1

## You MAY edit the following:
sv_licenseKey "spyqrrsmbtr48tmnhzpai5ahuis90qqs"
sv_hostname "Chimes built with CFX Default by Tabarra!"
sets sv_projectName "[CFX Default] Chimes"
sets sv_projectDesc "Recipe for the base resources required to run a minimal FiveM server."
sets locale "root-AQ" 



## These resources will start by default.
ensure cars
ensure esx_lscustom-master
ensure mapmanager
ensure chat
ensure chat-theme-gtao
ensure spawnmanager
ensure sessionmanager
ensure basic-gamemode
ensure hardcap
ensure CarCommand
ensure FCV
ensure Loading
ensure LegacyFuel-master
ensure fivem-map-hipster
ensure xnOnlineGarage-1.0.4
ensure lscustoms

#ESX
ensure essentialmode
ensure mysql_async
ensure esplugin_mysql
ensure es_extended
ensure async
ensure fxmigrant
ensure rc_mine
ensure rc_minerJob
ensure rc_notify
ensure trew_hud_ui

## 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.fivem:2105283 group.admin #InCrafter

ensure EasyAdmin

setr ea_LanguageName "en"                # set our language to english
set ea_moderationNotification "false"

add_ace group.admin easyadmin allow
1 Like

server=127.0.0.1

THAT WAS SO HELPFUL!!! THANK YOU![quote=“InCrafter, post:15, topic:2837076, full:true”]

Solution

# This is NOT supposed to be enough for a fully running server.
# Please read the fivem documentation:
#   https://docs.fivem.net/docs/server-manual/server-commands/
#   https://docs.fivem.net/docs/server-manual/setting-up-a-server/

## You CAN edit the following:
endpoint_add_tcp "0.0.0.0:30120"
endpoint_add_udp "0.0.0.0:30120"
sv_maxclients 48
set steam_webApiKey "435C52BA44297C755F8518EDC3955BCF"
sets tags "default, deployer"

add_ace resource.essentialmode command.sets allow
add_ace resource.essentialmode command.add_principal allow
add_ace resource.essentialmode command.add_ace allow


#ESX
ensure essentialmode
ensure mysql_async
ensure esplugin_mysql
ensure es_extended
ensure async
ensure fxmigrant
ensure rc_mine
ensure rc_minerJob
ensure rc_notify
ensure trew_hud_ui

#DATABASE
set mysql_connection_string "server=localhost;database=essentialmode;userid=root;"
set es_enableCustomData 1

## You MAY edit the following:
sv_licenseKey "spyqrrsmbtr48tmnhzpai5ahuis90qqs"
sv_hostname "Chimes built with CFX Default by Tabarra!"
sets sv_projectName "[CFX Default] Chimes"
sets sv_projectDesc "Recipe for the base resources required to run a minimal FiveM server."
sets locale "root-AQ" 



## These resources will start by default.
ensure cars
ensure esx_lscustom-master
ensure mapmanager
ensure chat
ensure chat-theme-gtao
ensure spawnmanager
ensure sessionmanager
ensure basic-gamemode
ensure hardcap
ensure CarCommand
ensure FCV
ensure Loading
ensure LegacyFuel-master
ensure fivem-map-hipster
ensure xnOnlineGarage-1.0.4
ensure lscustoms

#ESX
ensure essentialmode
ensure mysql_async
ensure esplugin_mysql
ensure es_extended
ensure async
ensure fxmigrant
ensure rc_mine
ensure rc_minerJob
ensure rc_notify
ensure trew_hud_ui

## 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.fivem:2105283 group.admin #InCrafter

ensure EasyAdmin

setr ea_LanguageName "en"                # set our language to english
set ea_moderationNotification "false"

add_ace group.admin easyadmin allow
[/quote]

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.