Help with Error - Please Help -

[Hajee]

Trying to do simple mod;

I get error;
[191052.511] [Gameplay] ERROR: UNIQUE constraint failed: Resource_YieldChanges.ResourceType, Resource_YieldChanges.YieldType
[191052.511] [Gameplay] ERROR: UNIQUE constraint failed: Resource_YieldChanges.ResourceType, Resource_YieldChanges.YieldType

Code

DELETE FROM Resource_YieldChanges;
INSERT INTO Resource_YieldChanges (ResourceType, YieldType, YieldChange) VALUES
('RESOURCE_DIAMONDS','YIELD_PRODUCTION','4'),
('RESOURCE_COPPER','YIELD_PRODUCTION','4'),
('RESOURCE_GYPSUM','YIELD_PRODUCTION','4'),
('RESOURCE_MERCURY','YIELD_PRODUCTION','4'),
('RESOURCE_SILVER','YIELD_PRODUCTION','4'),
('RESOURCE_SALT','YIELD_PRODUCTION','4'),
('RESOURCE_JADE','YIELD_PRODUCTION','4'),
('RESOURCE_AMBER','YIELD_PRODUCTION','4'),
('RESOURCE_IRON','YIELD_PRODUCTION','4'),
('RESOURCE_NITER','YIELD_PRODUCTION','4'),
('RESOURCE_URANIUM','YIELD_PRODUCTION','4'),
('RESOURCE_ALUMINUM','YIELD_PRODUCTION','4'),
('RESOURCE_COAL','YIELD_PRODUCTION','4'),
('RESOURCE_STONE','YIELD_PRODUCTION','4'),
('RESOURCE_MARBLE','YIELD_PRODUCTION','4'),
('RESOURCE_SHEEP','YIELD_FOOD','2'),
('RESOURCE_SHEEP','YIELD_PRODUCTION','2'),
('RESOURCE_CATTLE','YIELD_FOOD','2'),
('RESOURCE_CATTLE','YIELD_PRODUCTION','2'),
('RESOURCE_HORSES','YIELD_PRODUCTION','4'),
('RESOURCE_DEER','YIELD_FOOD','2'),
('RESOURCE_DEER','YIELD_PRODUCTION','2'),
('RESOURCE_FURS','YIELD_GOLD','2'),
('RESOURCE_DEER','YIELD_PRODUCTION','2'),
('RESOURCE_IVORY','YIELD_GOLD','2'),
('RESOURCE_DEER','YIELD_PRODUCTION','2'),
('RESOURCE_RICE','YIELD_FOOD','4'),
('RESOURCE_WHEAT','YIELD_FOOD','4'),
('RESOURCE_CITRUS','YIELD_GOLD','4'),
('RESOURCE_COFFEE','YIELD_GOLD','4'),
('RESOURCE_COTTON','YIELD_GOLD','4'),
('RESOURCE_INCENSE','YIELD_GOLD','4'),
('RESOURCE_WINE','YIELD_GOLD','4'),
('RESOURCE_TEA','YIELD_GOLD','4'),
('RESOURCE_TOBACCO','YIELD_GOLD','4'),
('RESOURCE_SILK','YIELD_GOLD','4'),
('RESOURCE_OLIVES','YIELD_GOLD','4'),
('RESOURCE_BANANAS','YIELD_FOOD','4'),
('RESOURCE_OIL','YIELD_GOLD','2'),
('RESOURCE_OIL','YIELD_PRODUCTION','2'),
('RESOURCE_FISH','YIELD_FOOD','4'),
('RESOURCE_CRABS','YIELD_FOOD','2'),
('RESOURCE_CRABS','YIELD_GOLD','2'),
('RESOURCE_WHALES','YIELD_FOOD','2'),
('RESOURCE_WHALES','YIELD_GOLD','2'),
('RESOURCE_PEARLS','YIELD_FOOD','2'),
('RESOURCE_PEARLS','YIELD_GOLD','2'),
('RESOURCE_TURTLES','YIELD_FOOD','2'),
('RESOURCE_TURTLES','YIELD_GOLD','2');

 

[Gedemon]

Make sure you've only one ResoureType/YieldType pair of each in your list.

For example you have multiple lines with

('RESOURCE_DEER','YIELD_PRODUCTION','2'),

keep only one and check for others if the error persists

 

[Hajee]

Wow, gogo Duplicates.

cant believe I spent 4 hours trying to find a (error) fix, and it took u 5 mins

wp mate, thank You