Item Mall Edit and Sh Studio

Hello! I used ShStudio to edit my item mall.I tought was the faster way, but,after i did everything,and i got my Sql Query,i go to open it in DB and what happen is that i get a huge amout of errors.

Quote:

Message 213,Level 16,State 1, Line1. Input Error.The Column name or number of supplied values does not match table definition.

So..I got My Item mall products deleted by this query and my edited item mall not working.

What's the prob with the quiry?

Quote:

TRUNCATE TABLE [PS_GameDefs].[dbo].[ProductList]; GO INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('30 Day Pack','PK_primm0001',0,100165,1,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Potion Pack','PK_shaiy0001',0,100001,255,25021,255,25024, 255,25027,255,25234,255,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Movement Pack','B2_Mvbg0010',0,100054,255,100045,255,100046 ,255,100065,255,100131,255,100132,255,100133,255,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Skill / Stat reset','PK_remed0002',0,100047,10,100048,10,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Beauty Package','B1_etain0001',0,100070,1,100071,1,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Health Remedy','B1_Rehel0001',198,100002,3,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Stamina Remedy','B1_Restm0001',198,100003,3,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Mana Remedy','B1_Reman0001',198,100004,3,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Clean Hit Nostrum','B1_Nosct0001',149,100005,1,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Defense Nostrum','B1_Nosdf0001',149,100006,1,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Wizardship Nostrum','B1_Noswz0001',149,100007,1,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Spirit Nostrum','B1_Nossp0001',98,100008,1,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Weapon Mastery Nostrum','B1_Noswm0001',98,100009,1,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Knockout Nostrum','B1_Nosko0001',249,100010,1,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Sharp Shooter Nostrum ','B1_Nosss0001',198,100011,1,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Black Art Nostrum ','B1_Nosba0001',198,100012,1,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Concentration Nostrum ','B1_Nosco0001',198,100013,1,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Strength RemedyLv1 ','B1_Restr0001',149,100023,1,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Reaction RemedyLv1','B1_Rerec0001',149,100026,1,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Dexterity RemedyLv1 ','B1_Redex0001',149,100029,1,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Lucky RemedyLv1','B1_Reluc0001',149,100032,1,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Intelligence Remedy Lv1','B1_Reint0001',149,100035,1,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Wisdom RemedyLv1 ','B1_Rewis0001',149,100038,1,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Clean Hit Nostrum Lv1','B1_Nchit1008',98,100101,1,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Defense Nostrum Lv1','B1_Ndefc1008',98,100104,1,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Huckleberry''s Power Lv1','B1_PowRT0020',49,100118,1,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Eihcim''s Competence Lv1','B1_PowHR0020',49,100121,1,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Ventsol''s AbilityLv1','B1_PowAP0020',49,100124,1,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Blue Dragon Charm','B1_BdChrm0001',800,100072,1,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('White Tiger Charm','B1_WtChrm0001',1800,100073,1,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Red Phoenix Charm','B1_RpChrm0001',2800,100074,1,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Teleportation Stone','B1_Telpstn1005',200,100065,5,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Lucky Charm','B1_Sftscrl0001',1499,100139,1,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Uber Mystery Box','B1_UbBox0001',299,44186,1,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Small Increase EXP','B1_exper0007',498,100042,1,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Resurrection Rune','B1_regem0001',249,100044,1,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Party Member Summon Rune','B1_Bcall0005',98,100045,5,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Movement Rune','B1_Sroul0005',98,100046,5,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Linking Hammer','B1_inche0005',298,100049,1,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Small Eternal Endurance','B1_SIndu0007',98,100050,1,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Prevent of Item Drop','B1_Mdrop0001',98,100112,1,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Small Prevent of Item Drop...','B1_Sdrop0007',198,100052,1,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Warehouse Call Rune','B1_bcall0001',198,100054,1,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Prevent of EXP Drop','B1_Expno0001',98,100110,1,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Small Prevent of EXP Drop','B1_Expno0002',598,100057,1,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Repair Hammer','B1_Repai0001',98,100066,1,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Double Warehouse','B1_Bactw0030',398,100075,1,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Small Increase Drop Gold','B1_Sgold0001',298,100083,1,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Mini Sun EXP Stone','B1_Misun0001',49,100108,1,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Small Sun EXP Stone','B1_Sasun0001',198,100109,1,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Mysterious Charm','B1_Mycha0001',598,100113,1,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Continuous Resurrection Ru...','B1_tiregem0003',349,100129,1,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Capital Movement Stone','B2_Mvcp0010',249,100131,10,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Bootleggery Movement Stone...','B2_Mvbm0010',398,100132,10,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Arena Movement Stone','B2_Mvbg0019',298,100133,10,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Small Extraction Hammer','B1_Exthmr1000',349,100140,1,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Large Extraction Hammer','B1_Exthmr2000',499,100141,1,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Lucky Charm','B1_Safesc0001',1499,100139,1,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Mysterious Lapis Pocket','B1_Robag0001',298,100068,1,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Big Firecracker','B1_Firec0001',25,100115,3,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Love Firecracker','B1_Firec0002',49,100116,3,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Jumbo Firecracker','B1_Firec0003',49,100117,3,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('SK Butterfly Firecracker','B1_Firec0004',49,100128,3,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Termit long mantle','B2_HwgLM4801',2999,39073,1,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Skay Long mantle','B2_HwgLM5401',2999,39074,1,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Zubelyou Long Cape','B2_HhaLM4801',2999,39157,1,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Bestong Long Cape','B2_HhaLM5401',2999,39158,1,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Phukey Long Cape','B2_HpoLM4801',2999,39243,1,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Hermit Long Cape','B2_HpoLM5401',2999,39244,1,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Cape of the Revenge','B2_HfdLM4801',2999,24073,1,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Cape of the Vengeance','B2_HfdLM5401',2999,24074,1,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Cape of the Feral','B2_HraLM4801',2999,24157,1,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Cape of the Savage','B2_HraLM5401',2999,24158,1,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Cape of the Virtue','B2_HmfLM4801',2999,24243,1,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Cape of the Sancitude','B2_HmfLM5401',2999,24244,1,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Normal Item Pocket','B1_SpBox0001',249,100078,1,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Hard Item Pocket','B1_SpBox0002',299,100079,1,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Ultimate Item Pocket','B1_SpBox0003',399,100080,1,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Skill Initialization Stone...','B1_setsk0001',998,100047,1,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Stats Initializing Stone','B1_setst0001',998,100048,1,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Appearance Change Scroll','B1_Cface0001',398,100070,1,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Sex Change Scroll','B1_Cshap0001',698,100071,1,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Name Change Stone','B1_Charname0001',1998,100136,1,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('49 AP Mystery Box','B1_Mystery0001',49,100142,1,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0) INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('249 AP Mystery Box','B1_Mystery0002',249,100143,1,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0) GO

After i got IM all deleted because of Shstudio query, i tried to edit item mall alone in the DB.
I did it,but only the 1st package worked..2nd and 3rd and 4th didn't.
:(

Just check on the allowed values for each column, if you notice, the error is coming from even the first INSERT query, which is letting you know that you are entering an invalid value to a certain column, for example, entering a STRING into a INT column.

Yeah but looks like every colums is bugged.
So ok if i did some mistake with the item i added but only the first 5-6 items are mine..the other was on the original file.So, SHstudio should have some kind of problem doing sql scripts... isn't it?

LoL i'm so Nub >.<

Easy fix bud! Check this out:

Old / Wrong:

Quote:

INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('30 Day Pack','PK_primm0001',0,100165,1,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0)

Right way to put it:

Quote:

INSERT INTO [PS_GameDefs].[dbo].[ProductList] values (1,'30 Day Pack','PK_primm0001',0,100165,1,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0)

All you gotta do to fix it, is to manually just put the numbers in the correct sequence, and it is all fixed!

Good luck bud!

It's easier to make it an auto-increment so that it will be added automatically