When i insert a furniture sql i get this error: #1062 - Duplicate entry '4731' for key 'PRIMARY'
Help please!
Printable View
When i insert a furniture sql i get this error: #1062 - Duplicate entry '4731' for key 'PRIMARY'
Help please!
duplicate means that this id is duplicate so it already exists. Try another id :)
Uhm, in this line, which id should i change?
INSERT INTO `furniture` (`id`, `public_name`, `item_name`, `type`, `width`, `length`, `stack_height`, `can_stack`, `can_sit`, `is_walkable`, `sprite_id`, `allow_recycle`, `allow_trade`, `allow_marketplace_sell`, `allow_gift`, `allow_inventory_stack`, `interaction_type`, `interaction_modes_count`, `vending_ids`, `is_arrow`) VALUES ('4751', 'CF_240_sapphire', 'CF_240_sapphire', 's', '1', '1', '1', '0', '0', '0','4751', '1', '1', '0', '1', '1', 'default', 1, '0', '0');
The first one >.< as it is primary and needs to be unique.
It worked, thanks tdid :)