MuCore WebShop

[trhero]

INSERT INTO MUCore_Shop_Items(name,i_type,i_id,credits,serial,i_luck_option,i_skill_option,size_x,size_y,i_default_durability,i_maximum_durability,category,i_max_excelent_option,i_max_option,i_max_level,i_refined_option,i_harmony_option,i_socket_option,i_option,i_exc_option,class_requirement,ancient_id,i_stock,i_image,i_sell,i_stick_level,exc_anc)VALUES('Scroll of Ligthing Storm','15','29','100','1','0','0','1','2','255','0','15','0','0','-1','0','0','0','0','0','999','0',' ',' ','1','0','')


i add this buti get


Server: Msg 515, Level 16, State 2, Line 1
Cannot insert the value NULL into column 'id', table 'MuOnline.dbo.MUCore_Shop_Items'; column does not allow nulls. INSERT fails.
The statement has been terminated.

this error if i make NOT NULL to NULL i can add items but id doesnt work please help

[MentaL]

[Cryingsoul]

Well thats very easy to fix lol, go to Enterprise Manger > Databases > MuOnline > Tables > right click MUCore_Shop_Items and click design table. Then you might see in the first line "id", "Allow Null", click under it and it should be thicked. Now try to put the code in Query Analyzer and try again ^^

[trhero]

bro if i check later its turn to NULL but webshop doesnt work :S

[Cryingsoul]

Well just do it for temporary, do the following action that I posted earlier and then change it back to normal.

Allow null -> Run your script in query analyzer -> Dont allow null