+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Off-Topic (The Outer World) (https://lckb.dev/forum/forumdisplay.php?fid=198)
+---- Forum: General Discussion (https://lckb.dev/forum/forumdisplay.php?fid=147)
+---- Thread: DatabaseUpdater (/showthread.php?tid=170)
- Bradox - 09-13-2011
Hey i want update my Database with DatabaseUpdater but i cant update my Datebase with the export file.
I want execute Sql file in NavicatLite but i become a Error
[Err] 1062 - Duplicate entry 2 for key 1
[Err] INSERT INTO t_item ( a_index, a_type_idx, a_subtype_idx, a_enable, a_name, a_descr, a_job_flag, a_flag, a_wearing, a_num_0, a_num_1, a_num_2, a_num_3, a_level, a_weight, a_price, a_max_use, a_need_item0, a_need_item1, a_need_item2, a_need_item3, a_need_item4, a_need_item5, a_need_item6, a_need_item7, a_need_item8, a_need_item9, a_need_item_count0, a_need_item_count1, a_need_item_count2, a_need_item_count3, a_need_item_count4, a_need_item_count5, a_need_item_count6, a_need_item_count7, a_need_item_count8, a_need_item_count9, a_need_sskill, a_need_sskill_level, a_need_sskill2, a_need_sskill_level2, a_set_0, a_set_1, a_set_2, a_set_3, a_set_4, a_set, a_grade ) VALUES
(2,1,1,1,"Leather Armor","Titan Armor",1,134217790,1,15,0,0,0,1,150,0,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,0,0,0,0,0,-1,0),
(3,1,2,1,"Leather Pants","Titan Armor",1,134217790,3,12,0,0,0,1,100,0,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,0,0,0,0,0,-1,0),
(4,1,3,1,"Leather Gloves","Titan Armor",1,134217790,5,8,0,0,0,1,30,0,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,0,0,0,0,0,-1,0),
(5,1,1,1,"Mercenary Chain Mail","Titan Armor",1,134217790,1,35,0,0,0,11,210,1467,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,0,0,0,0,0,-1,0),
(6,1,2,1,"Hunter Knee Guards","Titan Armor",1,134217790,3,22,0,0,0,6,130,727,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,0,0,0,0,0,-1,0),
(7,1,3,1,"Hunter Gauntlets","Titan Armor",1,134217790,5,16,0,0,0,5,34,400,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,0,0,0,0,0,-1,0),
(8,1,4,1,"Leather Boots","Titan Armor",1,134217790,6,10,0,0,0,1,30,0,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,0,0,0,0,0,-1,0),
(9,1,4,1,"Hunter Boots","Titan Armor",1,134217790,6,22,0,0,0,7,36,653,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,0,0,0,0,0,-1,0),
(12,0,3,1,"Machete","Titan Weapon",1,134217790,2,20,0,14,0,1,180,0,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,0,0,0,0,0,-1,0),
(18,1,2,1,"Silk Skirt","Mage Armor",8,134217790,3,12,0,0,0,1,30,0,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,0,0,0,0,0,-1,0),
(19,4,5,1,"Gold","",127,11,-1,0,0,0,0,0,0,1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,0,0,0,0,0,-1,0),
(20,1,4,1,"Silk Boots","Mage Armor",8,134217790,6,10,0,0,0,1,15,0,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,0,0,0,0,0,-1,0),
(21,1,4,1,"Apprentice Long Shoes","Mage Armor",8,134217790,6,16,0,0,0,7,18,653,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,0,0,0,0,0,-1,0),
(22,1,3,1,"Silk Bracelet","Mage Armor",8,134217790,5,10,0,0,0,1,25,0,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,0,0,0,0,0,-1,0),
(23,1,3,1,"Apprentice Gloves","Mage Armor",8,134217790,5,14,0,0,0,5,27,400,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,0,0,0,0,0,-1,0),
(24,1,0,1,"Silk Circlet","Mage Armor",8,134217790,0,10,0,0,0,1,15,0,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,0,0,0,0,0,-1,0),
(25,1,0,1,"Apprentice Tiara","Mage Armor",8,134217790,0,16,0,0,0,7,18,747,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,0,0,0,0,0,-1,0),
(26,1,1,1,"Cotton Shirt","Healer Armor",4,134217790,1,12,0,0,0,1,50,0,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,0,0,0,0,0,-1,0),
(27,1,1,1,"Elven Shirt","Healer Armor",4,134217790,1,22,0,0,0,11,80,1467,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,0,0,0,0,0,-1,0),
(28,1,2,1,"Cotton Skirt","Healer Armor",4,134217790,3,12,0,0,0,1,45,0,-1,-1,-1,-1,-1,-1
[Msg] Finished - Unsuccessfully
- Wizatek - 09-13-2011
[Err] 1062 - Duplicate entry 2 for key 1
Baiscly this means that the record already exists.
Its best to empty the t_item database before u insert the new data
- Bradox - 09-16-2011
[Err] 1062 - Duplicate entry 2 for key 1
Baiscly this means that the record already exists.
Its best to empty the t_item database before u insert the new data
ty
