Lost Furni SQL

Sarah

Member
Jan 14, 2011
40
0
Im having a problem inserting something to MySQL can anyone help fix this error:

Code:
INSERT INTO `catalogue_items` (`tid`, `catalogue_name`, `catalogue_description`, `catalogue_cost`, `typeid`, `length`, `width`, `top`, `name_cct`, `colour`, `catalogue_id_page`, `door`, `tradeable`, `recycleable`, `catalogue_id_index`) VALUES
(13583, 'NAME', 'DESC', 5, 1, 2, 1, 1.00, 'lc_coral_divider_hi', '0,0,0', 85, 0, 1, 2, 13583),
(13584, 'NAME', 'DESC', 5, 1, 2, 1, 1.00, 'lc_coral_divider_low', '0,0,0', 85, 0, 1, 2, 13584),
(13585, 'NAME', 'DESC', 5, 0, 1, 1, 1.00, 'lc_wall1', '0,0,0', 85, 0, 1, 2, 13585),
(13586, 'NAME', 'DESC', 5, 0, 1, 1, 1.00, 'lc_wall2', '0,0,0', 85, 0, 1, 2, 13586),
(13587, 'NAME', 'DESC', 5, 0, 1, 1, 1.00, 'lc_window1', '0,0,0', 85, 0, 1, 2, 13587),
(13588, 'NAME', 'DESC', 5, 0, 1, 1, 1.00, 'lc_window2', '0,0,0', 85, 0, 1, 2, 13588),
(13589, 'NAME', 'DESC', 5, 1, 1, 1, 1.00, 'lc_anemone', '0,0,0', 85, 0, 1, 2, 13589),
(13590, 'NAME', 'DESC', 5, 2, 1, 1, 1.00, 'lc_chair', '0,0,0', 85, 0, 1, 2, 13590),
(13591, 'NAME', 'DESC', 5, 1, 1, 1, 1.00, 'lc_corner', '0,0,0', 85, 0, 1, 2, 13591),
(13592, 'NAME', 'DESC', 5, 1, 2, 1, 1.00, 'lc_desk', '0,0,0', 85, 0, 1, 2, 13592),
(13593, 'NAME', 'DESC', 5, 2, 1, 1, 1.00, 'lc_stool', '0,0,0', 85, 0, 1, 2, 13593),
(13594, 'NAME', 'DESC', 5, 1, 2, 2, 1.00, 'lc_table', '0,0,0', 85, 0, 1, 2, 13594),
(13595, 'NAME', 'DESC', 5, 1, 2, 2, 1.00, 'lc_tile1', '0,0,0', 85, 0, 1, 2, 13595),
(13596, 'NAME', 'DESC', 5, 1, 2, 2, 1.00, 'lc_tile2', '0,0,0', 85, 0, 1, 2, 13596),
(13597, 'NAME', 'DESC', 5, 1, 1, 1, 1.00, 'lc_tubes_corners', '0,0,0', 85, 0, 1, 2, 0),
(13598, 'NAME', 'DESC', 5, 1, 1, 1, 1.00, 'lc_tubes_straight', '0,0,0', 85, 0, 1, 2, 13598),
(13599, 'NAME', 'DESC', 5, 1, 1, 1, 1.00, 'lostc_teleport', '0,0,0', 85, 0, 1, 2, 13599),
(13600, 'NAME', 'DESC', 5, 1, 2, 2, 1.00, 'lc_crab1', '0,0,0', 85, 0, 1, 2, 13600),
(13601, 'NAME', 'DESC', 5, 1, 1, 1, 1.00, 'lc_crab2', '0,0,0', 85, 0, 1, 2, 13601),
(13602, 'NAME', 'DESC', 5, 4, 2, 3, 1.00, 'lc_glass_floor', '0,0,0', 85, 0, 1, 2, 13602),
(13603, 'NAME', 'DESC', 5, 1, 1, 1, 1.00, 'lc_medusa1', '0,0,0', 85, 0, 1, 2, 13603),
(13604, 'NAME', 'DESC', 5, 1, 1, 1, 1.00, 'lc_medusa2', '0,0,0', 85, 0, 1, 2, 13604),
(13605, 'NAME', 'DESC', 5, 1, 1, 2, 1.00, 'ads_711shelf', '0,0,0', 85, 0, 1, 2, 13605)

Problem:
Code:
#1062 - Duplicate entry '13584' for key 'PRIMARY'
 

Users who are viewing this thread

Top