[Release][ESX] [Jobs]

FiveM Resource Development & Modding Releases
129

may sound like a really dumb question but do you need [Release] MySQL Async Library - 3.3.0 For this to work?

130

Yes. You need essentialmode, Esplugin_mysql, and that and a few other things.

131

I have all the ones that are listed in the requirements but it wasn’t part of that so I wasn’t 100% sure so thank you

132

I also was reading through and made sure to get the joblistings one as well

133

I also read something about a load order?

134

What do you mean load order. Yes you need job listings, you also need esx_menu____
I dont know all the menu things but for sure there are 3 of them.

135

I dont remember where I saw it. and alright ill look into it

136

Same… I need help with it. I have the same Error Message…

137

[ERROR] [MySQL] An error happens on MySQL for query “SELECT * FROM jobs {=}”: Unable to connect to any of the specified MySQL hosts.
Error running system event handling function for resource esx_society-master: citizen:/scripting/lua/scheduler.lua:41: Failed to execute thread: server/main.lua:31: attempt to get length of a nil value (local ‘result’)
stack traceback:
server/main.lua:31: in upvalue 'handler’
citizen:/scripting/lua/scheduler.lua:174: in function citizen:/scripting/lua/scheduler.lua:173
stack traceback:
[C]: in function 'error’
citizen:/scripting/lua/scheduler.lua:41: in field 'CreateThreadNow’
citizen:/scripting/lua/scheduler.lua:173: in function citizen:/scripting/lua/scheduler.lua:138
[ERROR] [MySQL] An error happens on MySQL for query “SELECT * FROM addon_account {=}”: Unable to connect to any of the specified MySQL hosts.
[ERROR] [MySQL] An error happens on MySQL for query “SELECT * FROM items {=}”: Unable to connect to any of the specified MySQL hosts.
Error running system event handling function for resource esx_addonaccount-master: citizen:/scripting/lua/scheduler.lua:41: Failed to execute thread: server/main.lua:12: attempt to get length of a nil value (local ‘result’)
stack traceback:
server/main.lua:12: in upvalue 'handler’
citizen:/scripting/lua/scheduler.lua:174: in function citizen:/scripting/lua/scheduler.lua:173
stack traceback:
[C]: in function 'error’
citizen:/scripting/lua/scheduler.lua:41: in field 'CreateThreadNow’
citizen:/scripting/lua/scheduler.lua:173: in function citizen:/scripting/lua/scheduler.lua:138
[ERROR] [MySQL] An error happens on MySQL for query “SELECT * FROM items {=}”: Unable to connect to any of the specified MySQL hosts.
Error running system event handling function for resource esx_addoninventory-master: citizen:/scripting/lua/scheduler.lua:41: Failed to execute thread: server/main.lua:14: attempt to get length of a nil value (local ‘items’)
stack traceback:
server/main.lua:14: in upvalue 'handler’
citizen:/scripting/lua/scheduler.lua:174: in function citizen:/scripting/lua/scheduler.lua:173
stack traceback:
[C]: in function 'error’
citizen:/scripting/lua/scheduler.lua:41: in field 'CreateThreadNow’
citizen:/scripting/lua/scheduler.lua:173: in function citizen:/scripting/lua/scheduler.lua:138
[ERROR] [MySQL] An error happens on MySQL for query “SELECT * FROM datastore {=}”: Unable to connect to any of the specified MySQL hosts.
Error running system event handling function for resource esx_datastore-master: citizen:/scripting/lua/scheduler.lua:41: Failed to execute thread: server/main.lua:14: attempt to get length of a nil value (local ‘result’)
stack traceback:
server/main.lua:14: in upvalue 'handler’
citizen:/scripting/lua/scheduler.lua:174: in function citizen:/scripting/lua/scheduler.lua:173
stack traceback:
[C]: in function 'error’
citizen:/scripting/lua/scheduler.lua:41: in field 'CreateThreadNow’
citizen:/scripting/lua/scheduler.lua:173: in function citizen:/scripting/lua/scheduler.lua:138
hitch warning: frame time of 591 milliseconds

I have problem too…

what is this?: [ERROR] [MySQL] An error happens on MySQL for query “SELECT * FROM datastore {=}”: Unable to connect to any of the specified MySQL hosts.

138

Hello,

I have this kind of problem that my FIB job is in jobcentre do anyone know’s how can i remove it?

139

Hello, sorry my bad english!

i installed EssentialMode5 mod, then latest es_extended mode.
Ofcourse i have installed joblisting, addonaccount etc…
And ofcourse i have mysql database.
proof:

database
database725×237 22.6 KB

folder
config
config706×446 8.9 KB

but problem is that game map dont show any of these jobs icons - i think its “Blip”:)?
And yes, i watched conf files, all of them are true.
and there is gamemap:

game
game762×649 219 KB

Can someone explain what im doing wrong ?

THANKS!

140

They only show if you take the job… Try it next time.

141

Change the whitelist value in the db to 1

142

I keep getting the following error when imputing the jobs when I have all required scripts.
My MySQL Database Error Code (1146) “essentialmode.jobs” doesn’t exist

143

how i can create a job?

144

How do you fix that?

145

nope, if u installed this script and using “wrong” database (i wanted it do be english and i used: “\localization\en_esx_jobs.sql” - and there is:
INSERT INTO jobs (name, label) VALUES
(‘slaughterer’, ‘Butcher’),
(‘fisherman’, ‘Fisherman’),
(‘miner’, ‘Miner’),
(‘lumberjack’, ‘Lumberjack’),
(‘fueler’, ‘Fueler’), - damn how wrong is this :smiley:
(‘reporter’, ‘Reporter’),
(‘tailor’, ‘Tailor’)
;

u just need to change this “fueler” to fuel - and THEN its working!
i dont understand why this mod dev sharing this. its so hard to fix and explain whats wrong :smiley:D

147

where do i change the salary for unemployed ?

148

You can change solitarys on database if you use phpadmin or navicat you can go your server then you go job_garde and there you can edit everything

149

Can anybody think of a way to force the Benson in the Butchering job to be a Cluckin’ Bell Benson, such as this one in the GTA Wiki?