Possible SQL/lua issue blocking functionality on my server

FiveM Server Development Server Discussion
,
1

I’m getting the following error on my server and it seems to be blocking the following…

  • Making myself an admin
  • Opening menus like vMenu and jobs menu
  • Most ESX functionality

callback (@mysql-async/mysql-async.js:5112)
fetchAll (@mysql-async/lib/MySQL.lua:147)
task (@es_extended/server/main.lua:131)
processQueue (@async/async.lua:67)
parallelLimit (@async/async.lua:86)
series (@async/async.lua:91)
? (@es_extended/server/main.lua:201)
fn (@async/async.lua:21)

server thread hitch warning: timer interval of 719 milliseconds
SCRIPT ERROR: @esx_deliveries/server/main.lua:81: attempt to index a nil value (local ‘xPlayer’)
SCRIPT ERROR in call ref: TypeError: Cannot read property ‘execute’ of null

callback (@mysql-async/mysql-async.js:5112)
fetchAll (@mysql-async/lib/MySQL.lua:147)
handler (@esx_communityservice/server/main.lua:150)

SCRIPT ERROR in call ref: TypeError: Cannot read property ‘execute’ of null

callback (@mysql-async/mysql-async.js:5121)
fetchScalar (@mysql-async/lib/MySQL.lua:161)
ref (@esx_ambulancejob/server/main.lua:277)
TriggerServerCallback (@es_extended/server/functions.lua:33)
handler (@es_extended/server/common.lua:88)

SCRIPT ERROR: @esx_wanted/server/main.lua:169: attempt to index a nil value (local ‘xPlayer’)
TriggerServerCallback (@es_extended/server/functions.lua:33)
handler (@es_extended/server/common.lua:88)

When I set up my server, I began by injecting this SQL file. Would someone mind taking a look at this? I’m wondering if it’s an SQL issue or a problem with the luas.

newsqlversion2.sql (218.5 KB)