[FIXED] Error with esx_jobslisting

Hello, I have made my server new because of the updates, and since then I can no longer open the menu at the Job Center. the error code:

[ERROR] [MySQL] An error happens on MySQL for query “SELECT * FROM jobs WHERE whitelisted = false {=}”: Unknown column ‘whitelisted’ in ‘where clause’

FIX: just add to SQL:

ALTER TABLE jobs add whitelisted BOOLEAN NOT NULL DEFAULT FALSE;

Ask in the original topic.

wich is it? i cant find it

You tell me. I didn’t download your resources for you.

I’m having the same issue. Where in the SQL do I add this exactly?

ALTER TABLE jobs add whitelisted BOOLEAN NOT NULL DEFAULT FALSE;

1 Like

That’s a SQL command. Just execute it in the database. If you need assistance, ask in the ESX Discord.

i had this error

[ERROR] [MySQL] [esx_joblisting] An error happens on MySQL for query “SELECT * FROM jobs WHERE whitelisted = false”: ER_BAD_FIELD_ERROR: Unknown column ‘whitelisted’ in ‘where clause’
SCRIPT ERROR: @esx_joblisting/server/main.lua:10: attempt to get length of a nil value (local ‘result’)

ref (@esx_joblisting/server/main.lua:10)
(@mysql-async/mysql-async.js:15897)
when standing at ifomation and pressing e


put this in my sql queries using xampp-control
ALTER TABLE jobs add whitelisted BOOLEAN NOT NULL DEFAULT FALSE;

and it fixed it

[my data base was under fivem not essentialmode]