I tried to import the police job sql into my databse but i met this problem and i dont know what to do.
also there is another problem:
is it the most recent esx_policejob?
can you send the sql you are trying to import?
pretty sure theres a typo somewhere unless there is literally a table called ‘es_extended.addon_account’
yes its the most recent esx_policejob, and yeah sure, should i send the file or what?
USE `es_extended`;
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', 'LSPD')
;
INSERT INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
('police',0,'recruit','Recrue',20,'{}','{}'),
('police',1,'officer','Officier',40,'{}','{}'),
('police',2,'sergeant','Sergent',60,'{}','{}'),
('police',3,'lieutenant','Lieutenant',85,'{}','{}'),
('police',4,'boss','Commandant',100,'{}','{}')
;
CREATE TABLE `fine_types` (
`id` int NOT NULL AUTO_INCREMENT,
`label` varchar(255) DEFAULT NULL,
`amount` int DEFAULT NULL,
`category` int DEFAULT NULL,
PRIMARY KEY (`id`)
);
INSERT INTO `fine_types` (label, amount, category) VALUES
('Usage abusif du klaxon',30,0),
('Franchir une ligne continue',40,0),
('Circulation Ă contresens',250,0),
('Demi-tour non autorisé',250,0),
('Circulation hors-route',170,0),
('Non-respect des distances de sécurité',30,0),
('ArrĂŞt dangereux / interdit',150,0),
('Stationnement gĂŞnant / interdit',70,0),
('Non respect de la priorité à droite',70,0),
('Non-respect à un véhicule prioritaire',90,0),
('Non-respect d\'un stop',105,0),
('Non-respect d\'un feu rouge',130,0),
('DĂ©passement dangereux',100,0),
('VĂ©hicule non en Ă©tat',100,0),
('Conduite sans permis',1500,0),
('DĂ©lit de fuite',800,0),
('Excès de vitesse < 5 kmh',90,0),
('Excès de vitesse 5-15 kmh',120,0),
('Excès de vitesse 15-30 kmh',180,0),
('Excès de vitesse > 30 kmh',300,0),
('Entrave de la circulation',110,1),
('DĂ©gradation de la voie publique',90,1),
('Trouble Ă l\'ordre publique',90,1),
('Entrave opération de police',130,1),
('Insulte envers / entre civils',75,1),
('Outrage Ă agent de police',110,1),
('Menace verbale ou intimidation envers civil',90,1),
('Menace verbale ou intimidation envers policier',150,1),
('Manifestation illégale',250,1),
('Tentative de corruption',1500,1),
('Arme blanche sortie en ville',120,2),
('Arme léthale sortie en ville',300,2),
('Port d\'arme non autorisé (défaut de license)',600,2),
('Port d\'arme illégal',700,2),
('Pris en flag lockpick',300,2),
('Vol de voiture',1800,2),
('Vente de drogue',1500,2),
('Fabriquation de drogue',1500,2),
('Possession de drogue',650,2),
('Prise d\'Ă´tage civil',1500,2),
('Prise d\'Ă´tage agent de l\'Ă©tat',2000,2),
('Braquage particulier',650,2),
('Braquage magasin',650,2),
('Braquage de banque',1500,2),
('Tir sur civil',2000,3),
('Tir sur agent de l\'Ă©tat',2500,3),
('Tentative de meurtre sur civil',3000,3),
('Tentative de meurtre sur agent de l\'Ă©tat',5000,3),
('Meurtre sur civil',10000,3),
('Meurte sur agent de l\'Ă©tat',30000,3),
('Meurtre involontaire',1800,3),
('Escroquerie Ă l\'entreprise',2000,2)
;
you already have these tables created within your database?
tables? // i dont think so
for example, in your database there should be tables of which are called “addon_account” ect, without them, you wont be able to insert data into them
there should be a sql file thatll look something like this
CREATE TABLE addon_account (
name varchar(50) NOT NULL,
label varchar(50) DEFAULT NULL,
PRIMARY KEY (`name`)
);
1 Like
yesyes, the tables that are called “items, jobs” ect, there should be one there called addon_account or something, which is why your getting the error, its trying to put data into a table which isnt there.
so i should just add it to my database?// im sorry but im really new into that
yes, i posted a link above that should have a sql that you can import
when it gives you an error, go to google or which ever search engine you use and type the last part, for example in this case type ‘addon_inventory fivem’ it should take you to a script where an sql is, download the sql and import.
unfortunately, im on a new account and it will not allow me to type anymore as i have reached my maximum messages! if you follow above you should be fine but if you havent managed to fix it in a couple hours, i should be able to help you, assuming i can reply then.
i will just add the esx_addoninventory
I love how many errors i get 
haha 
oh okay 
sad
Still didnt fix the problem
Hello, are you still here? Need help with police job
How did you manage to setup all this virtualisation with Wine on Linux (why even, there’s a command line or just some Linux desktop environment) but don’t understand the error?
It’s simple, it says that a certain table doesn’t exist. So for whatever you’re trying to use, it probably comes with an sql file that you can sue to import and create the table(s) necessary
Duplicate key entry means that the table column is supposed to be unique but you’re trying to add new data to it with the same value, and that’s not allowed. So I guess don’t? Or use a replace insert instead.
I dont know, i used many, many tutorials
And im not really sure what to do… its my very first time doing this stuff