es_extended: TriggerServerCallback => [esx_service:isInService] does not exist
After update this happend
with the cfg posted here but copy paste it will not work it indents it wrong
In the database
Why I always need to restart esx_policejob when my server restart ?
Start esx_policejob
1 Like
i installed esx_policejob as an default but taking gun does not work for me… i updated esx_extended and after that it didnt work no more 
this is annoying me now it was working fine intill I updated esx extended now when use police job it wont let me enter service in locker room I can see the option when I go in the circle to change outfit ect but they don’t load when I press enter then when I try to open the police job menu it says in bottom left corner you have not entered service you need to get change but its not loading when i click enter on the outfit to enter service in the police locker Please some one help I have had no sleep for days I think its a minor problem due to it work a few days ago
1 Like
I still got the problem that i can see the circles i can take vehicles but when a officer leaves and rejoins the server he can’t see policejob circles anymore. Only when i give the policejob again that officer can see it.
Anyone knows a fix?
How to add custom police outfits?
You need to stream them. Do you want it as a custom ped or EUP?
Like i mean rn its 
But i want like custom i know how add cars but i dont know how add custom outfits
can u help me then?
you need element club (15 $/month patreon) on your server to stream police clothes
It would be nice if someone could help me. Since some days I have been starting up my FiveM Server running ESX, and everything works fine.
Now recently I have replaced all law enforcement vehicles, but when I try to spawn them in the Police Garage they are still the Default GTA V vehicles. However when I spawn them using a Trainer it works just fine (using the same car, eg. “police2”).
Also whenever someone tries to buy something in the Garage and goes one Slot down in the menu it starts bugging.
I have definetly streamed the car replacements to my Server correctly.
It would be nice if someone could help me.
pm sent
Also current situation when getting a car from the garage after purchase
[ERROR] [MySQL] [esx_policejob] An error happens on MySQL for query "[object Obj
ect]": ER_BAD_FIELD_ERROR: Unknown column 'type' in 'field list'
Error: (node:6772) UnhandledPromiseRejectionWarning: AssertionError [ERR_ASSERTI
ON]: unexpected PromiseRejectEvent
at process.<anonymous> (internal/process/promises.js:27:25)
at <anonymous>
at Query.db.query [as _callback] (mysql-async.js:4973:13)
at Query.Sequence.end (mysql-async.js:280:24)
at Query.ErrorPacket (mysql-async.js:2122:8)
at Protocol._parsePacket (mysql-async.js:5941:23)
at Parser.write (mysql-async.js:6198:12)
at Protocol.write (mysql-async.js:5701:16)
at Socket.<anonymous> (mysql-async.js:693:28)
at emitOne (events.js:116:13)
Error: (node:6772) UnhandledPromiseRejectionWarning: Unhandled promise rejection
. This error originated either by throwing inside of an async function without a
catch block, or by rejecting a promise which was not handled with .catch(). (re
jection id: 1)
Error: (node:6772) [DEP0018] DeprecationWarning: Unhandled promise rejections ar
e deprecated. In the future, promise rejections that are not handled will termin
ate the Node.js process with a non-zero exit code.
Error: (node:6772) UnhandledPromiseRejectionWarning: Error: ER_BAD_FIELD_ERROR:
Unknown column 'type' in 'field list'
at Query.Sequence._packetToError (mysql-async.js:244:14)
at Query.ErrorPacket (mysql-async.js:2109:18)
at Protocol._parsePacket (mysql-async.js:5941:23)
at Parser.write (mysql-async.js:6198:12)
at Protocol.write (mysql-async.js:5701:16)
at Socket.<anonymous> (mysql-async.js:693:28)
at emitOne (events.js:116:13)
at Socket.emit (events.js:211:7)
at addChunk (_stream_readable.js:263:12)
at readableAddChunk (_stream_readable.js:250:11)
--------------------
at Pool.query (mysql-async.js:4728:23)
at Promise (mysql-async.js:4970:12)
at new Promise (<anonymous>)
at execute (mysql-async.js:4967:26)
at Object.global.exports [as callback] (mysql-async.js:4985:5)
at citizen:/scripting/v8/main.js:87:41
Error: (node:6772) UnhandledPromiseRejectionWarning: Unhandled promise rejection
. This error originated either by throwing inside of an async function without a
catch block, or by rejecting a promise which was not handled with .catch(). (re
jection id: 2)
You need to add the new sql file for the script
1 Like
Did that then went back and looked at the sql files and there is no difference between the two they are exactly the same.
https://github.com/ESX-Org/esx_policejob/blob/master/localization/en_esx_policejob.sql
USE `essentialmode`;
INSERT INTO `addon_account` (name, label, shared) VALUES
('society_police', 'Police', 1)
;
INSERT INTO `datastore` (name, label, shared) VALUES
('society_police', 'Police', 1)
;
INSERT INTO `addon_inventory` (name, label, shared) VALUES
('society_police', 'Police', 1)
;
INSERT INTO `jobs` (name, label) VALUES
('police', 'Police')
;
INSERT INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
('police',0,'recruit','Recruit',20,'{}','{}'),
('police',1,'officer','Officer',40,'{}','{}'),
('police',2,'sergeant','Sergeant',60,'{}','{}'),
('police',3,'lieutenant','Lieutenant',85,'{}','{}'),
('police',4,'boss','Chief',100,'{}','{}')
;
CREATE TABLE `fine_types` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`label` varchar(255) DEFAULT NULL,
`amount` int(11) DEFAULT NULL,
`category` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
);
INSERT INTO `fine_types` (label, amount, category) VALUES
('Misuse of a horn', 30, 0),
('Illegally Crossing a continuous Line', 40, 0),
('Driving on the wrong side of the road', 250, 0),
('Illegal U-Turn', 250, 0),
('Illegally Driving Off-road', 170, 0),
('Refusing a Lawful Command', 30, 0),
('Illegally Stopping a Vehicle', 150, 0),
('Illegal Parking', 70, 0),
('Failing to Yield to the right', 70, 0),
('Failure to comply with Vehicle Information', 90, 0),
('Failing to stop at a Stop Sign ', 105, 0),
('Failing to stop at a Red Light', 130, 0),
('Illegal Passing', 100, 0),
('Driving an illegal Vehicle', 100, 0),
('Driving without a License', 1500, 0),
('Hit and Run', 800, 0),
('Exceeding Speeds Over < 5 mph', 90, 0),
('Exceeding Speeds Over 5-15 mph', 120, 0),
('Exceeding Speeds Over 15-30 mph', 180, 0),
('Exceeding Speeds Over > 30 mph', 300, 0),
('Impeding traffic flow', 110, 1),
('Public Intoxication', 90, 1),
('Disorderly conduct', 90, 1),
('Obstruction of Justice', 130, 1),
('Insults towards Civilans', 75, 1),
('Disrespecting of an LEO', 110, 1),
('Verbal Threat towards a Civilan', 90, 1),
('Verbal Threat towards an LEO', 150, 1),
('Providing False Information', 250, 1),
('Attempt of Corruption', 1500, 1),
('Brandishing a weapon in city Limits', 120, 2),
('Brandishing a Lethal Weapon in city Limits', 300, 2),
('No Firearms License', 600, 2),
('Possession of an Illegal Weapon', 700, 2),
('Possession of Burglary Tools', 300, 2),
('Grand Theft Auto', 1800, 2),
('Intent to Sell/Distrube of an illegal Substance', 1500, 2),
('Frabrication of an Illegal Substance', 1500, 2),
('Possession of an Illegal Substance ', 650, 2),
('Kidnapping of a Civilan', 1500, 2),
('Kidnapping of an LEO', 2000, 2),
('Robbery', 650, 2),
('Armed Robbery of a Store', 650, 2),
('Armed Robbery of a Bank', 1500, 2),
('Assault on a Civilian', 2000, 3),
('Assault of an LEO', 2500, 3),
('Attempt of Murder of a Civilian', 3000, 3),
('Attempt of Murder of an LEO', 5000, 3),
('Murder of a Civilian', 10000, 3),
('Murder of an LEO', 30000, 3),
('Involuntary manslaughter', 1800, 3),
('Fraud', 2000, 2);
Sorry wasnt clear enough. I Think you need too update and add the new sql file of esx vehicleshop
When you buy a police cruiser and its in your police garage you cant pull it out anyone else have that issue.