SQL Error (1062): Duplicate entry 'weapon' for key 'PRIMARY'

[Lundka]

What am I doing wrong??? It’s not only error with weapons but some other .sql files also

[Calipo]

In truth this can make you bitter but it is very simple. tells you that this weapon is already in the database if you are injecting an sql script and it does not let you move the fastest way is to look for where that entry is and delete it. Re-inject and enjoy

[Lundka]

New error

[Calipo]

Have you tried deleting the weapon in the SQL script?
What resource is it?
IF we are talking about it
If you want to pass me is SQL script I can try to see what is wrong

[Lundka]

I deleted all that it told me I already had. It’s moddified esx_weaponshop + clips

USE essentialmode;

CREATE TABLE weashops (

id int(11) NOT NULL AUTO_INCREMENT,
name varchar(255) NOT NULL,
item varchar(255) NOT NULL,
price int(11) NOT NULL,

PRIMARY KEY (id)
);

INSERT INTO licenses (type, label) VALUES
(‘weapon’, “License to carry a weapon”)
;

INSERT INTO items (name, label) VALUES
(‘clip’, ‘Clip’)
;

INSERT INTO weashops (name, item, price) VALUES
(‘GunShop’, ‘WEAPON_KNUCKLE’, 150),
(‘GunShop’, ‘WEAPON_KNIFE’, 500),
(‘GunShop’, ‘WEAPON_FLASHLIGHT’, 500),
(‘GunShop’, ‘WEAPON_SWITCHBLADE’, 750),
(‘GunShop’, ‘WEAPON_GOLFCLUB’, 800),
(‘GunShop’, ‘WEAPON_BAT’, 1000),
(‘GunShop’, ‘WEAPON_MACHETE’, 1000),
(‘GunShop’, ‘WEAPON_SNSPISTOL’, 15000),
(‘GunShop’, ‘WEAPON_PISTOL’, 20000),
(‘GunShop’, ‘WEAPON_HEAVYPISTOL’, 40000),
(‘GunShop’, ‘WEAPON_PISTOL50’, 55000),
(‘GunShop’, ‘WEAPON_PUMPSHOTGUN’, 70000),
(‘GunShop’, ‘WEAPON_REVOLVER’, 100000),
(‘GunShop’, ‘WEAPON_DOUBLEACTION’, 1000000),
(‘BlackWeashop’, ‘WEAPON_PISTOL’, 22000),
(‘BlackWeashop’, ‘WEAPON_HEAVYPISTOL’, 44000),
(‘BlackWeashop’, ‘WEAPON_PISTOL50’, 60000),
(‘BlackWeashop’, ‘WEAPON_PUMPSHOTGUN’, 77000),
(‘BlackWeashop’, ‘WEAPON_COMBATPDW’, 100000),
(‘BlackWeashop’, ‘WEAPON_ASSAULTRIFLE’, 260000),
(‘BlackWeashop’, ‘WEAPON_CARBINERIFLE’, 305000),
(‘BlackWeashop’, ‘WEAPON_SPECIALCARBINE’, 450000),

;

Here you go

[Calipo]

Okay. when he does not understand very well sql. You avoid problems if you delete the table in which you try to insert content. How do you do this?
Go to your database:
1.Clik right in weashops
2.Clik on delete or drop
3. Return Execute your SQL script, this time without modifying it as the file comes.

[Lundka]

okay but where do I modify my sh*t then?

[Calipo]

What want modify?
hat weapons will the weapons stores have?

[Lundka]

Okay got it thanks for your help man!