[Release][ESX] [Jobs]


#191

Hi, how “freezePlayer” character when player working can walking go out of marker and back. How fix this ?


#192

Hi. I have problem with esx_jobs. When i want to change my clothes it don’t work. If i cant change my clothes, i can’t work so all jobs are not working. Someone can help?


#193

Can i use hedi sql???


#194

Did you ever figure / get help for this ?


#195

i have

start es_extended
start esx_menu_default
start esx_menu_list
start esx_menu_dialog
start esx_jobs

did i miss somthing? in game when i press E nothing happen the console talk about whitelist…
do i need whitelist? or tell me if i miss something else for it to work…


#196

Your script start list should look like this:

start mysql-async
start essentialmode
start esplugin_mysql
start es_admin2

start es_extended

start esx_menu_default
start esx_menu_list
start esx_menu_dialog

start esx_addonaccount
start esx_jobs
start esx_skin
start skinchanger

And the links to all of the ones your missing are:

https://github.com/ESX-Org/esx_skin
https://github.com/ESX-Org/skinchanger
https://github.com/ESX-Org/esx_addonaccount
https://github.com/ESX-Org/async/tree/1.0.1
https://github.com/brouznouf/fivem-mysql-async/tree/v2.1.1

#197

thanks but i got them all already… the error is in the console it talks about whitelisted

the error is:
[MySQL] An error happens on MySQL for query “SELECT * FROM whitelist {=}”: Table ‘essentialmode.whitelist’ doesn’t exist.

but in the job table i created a colum called whitelisted


#198

It seems as if its a error from a different esx script, and also it says “Table ‘essentialmode.whitelist’” so making a colum in jobs will not help.
I might have found a script that might help, here’s the link


#199

sorry about that i deactivated the whitelist mod…
for now the error code when i try to get a job is:

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

but i used the command
ALTER TABLE jobs add whitelisted BOOLEAN NOT NULL DEFAULT FALSE;
and it created the colum called whitelisted
then i clicked on the thunder_icon and its working…
but that message still here… help me plz
why it doesnt work?


#200

I cant find any solution on the forums, I would try to ask in the ESX Discord, sorry that I was not of help


#201

well can you show me by picture how to correctly add the colum naed whitelisted… then ill see if i made a mistake :slight_smile:


#202

I might have found a solution.
Can you send me a picture of what your jobs Table looks like?


#203

This post might help you, Whitelist ESX jobs


#204

cant import the .SQL . my only option is to import CSV file


#205

i dont importe a file… i run it…
go to your database then file/ run sql script … it will be imported in the database :slight_smile:


#206

thanks man it really helped me :slight_smile:


#207

Hello, Where can i find all jobs…what i have in job center… i need whitelist some jobs


#208

Hi, i just install esx_jobs and i cant see the blip and marker. i cant really see any problems in console so i have no idea how i can fix it


#209

Same problem here :confused:


#210

Stasiek i found solution install esx_joblisting it worked for me :stuck_out_tongue: