[FIXED] Error with esx_jobslisting

help

#1

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;


#2

Ask in the original topic.


#3

wich is it? i cant find it


#4

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


#5

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;


#6

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