Error when I log into my server

FiveM Server Development ES/ESX
1

This error appears when I log into my server:

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

start mysql-async
set mysql_connection_string "server=127.0.0.1;uid=Andrade;password=(hidden);database=essentialmode"
set es_enableCustomData 1

# These resources will start by default.
start mapmanager
start chat
start spawnmanager
start sessionmanager
start fivem
start hardcap
start ■■■■■■■
start scoreboard
start playernames

#ESSENCIAL
start essentialmode
start esplugin_mysql
start async

#START ES

start es_extended
start es_admin

#START ESX

start esx_menu_default
start esx_menu_list
start esx_menu_dialog
start esx_borrmaskin
start esx_robatm
start esx_drugs
start t0sic_inventoryui
start pNotify
start skinchanger
start esx_skin
start esx_addonaccount
start esx_jobs
start esx_datastore
start esx_property
start instance
start cron
start esx_addoninventory

And that’s line 155

151- table.insert(tasks2, function(cb2)
152-			MySQL.Async.fetchAll('SELECT * FROM `jobs` WHERE `name` = @name', {
153-				['@name'] = userData.job.name
154-			}, function(result)
155-				userData.job['label'] = result[1].label
156-				cb2()
157-			end)
158-		end)
2

Did you import all of the SQL files necessary to your database?

Also, make sure your start up order for the essential resources is like the following:

start mysql-async

start essentialmode

start esplugin_mysql

start async

start es_admin2

start es_extended

Also also, I think you just broke something involving the jobs, did you change anything related to jobs in your files, or rename a job, etc.? because your error indicates that the resource was trying to fetch a nil value, meaning a value which didn’t exist?

Good luck!

3

I solved it, tks.