[Problem] Zapytania do navicat

[RaymanGT]

Witam, nie mogę dodawać niektórych zapytań do Navicat, przykładowo tych:

INSERT INTO `item_proto` (`vnum`,`name`,`local_name`,`type`,`subtype`,`weight`,`size`,`antiflag`,`flag`,`wearflag`,`immuneflag`,`gold`,`shop_buy_price`,`limittype0`,`limitvalue0`,`limittype1`,`limitvalue1`,`applytype0`,`applyvalue0`,`applytype1`,`applyvalue1`,`applytype2`,`applyvalue2`,`value0`,`value1`,`value2`,`value3`,`value4`,`value5`,`socket0`,`socket1`,`socket2`,`socket3`,`socket4`,`socket5`,`refined_vnum`,`refine_set`,`magic_pct`,`specular`,`socket_pct`) VALUES ('119220','??????','Wodny Kryształ','14','3','0','1','0','0','0','0','24000','24000','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','64928','127','65008','21631','4855','0','0','0','0','0');
INSERT INTO `item_proto` (`vnum`,`name`,`local_name`,`type`,`subtype`,`weight`,`size`,`antiflag`,`flag`,`wearflag`,`immuneflag`,`gold`,`shop_buy_price`,`limittype0`,`limitvalue0`,`limittype1`,`limitvalue1`,`applytype0`,`applyvalue0`,`applytype1`,`applyvalue1`,`applytype2`,`applyvalue2`,`value0`,`value1`,`value2`,`value3`,`value4`,`value5`,`socket0`,`socket1`,`socket2`,`socket3`,`socket4`,`socket5`,`refined_vnum`,`refine_set`,`magic_pct`,`specular`,`socket_pct`) VALUES ('119221','??????','Szpon Smoka','14','3','0','1','0','0','0','0','24000','24000','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','64928','127','65008','21631','4855','0','0','0','0','0');
INSERT INTO `item_proto` (`vnum`,`name`,`local_name`,`type`,`subtype`,`weight`,`size`,`antiflag`,`flag`,`wearflag`,`immuneflag`,`gold`,`shop_buy_price`,`limittype0`,`limitvalue0`,`limittype1`,`limitvalue1`,`applytype0`,`applyvalue0`,`applytype1`,`applyvalue1`,`applytype2`,`applyvalue2`,`value0`,`value1`,`value2`,`value3`,`value4`,`value5`,`socket0`,`socket1`,`socket2`,`socket3`,`socket4`,`socket5`,`refined_vnum`,`refine_set`,`magic_pct`,`specular`,`socket_pct`) VALUES ('119222','??????','Mleczny Sok','14','3','0','1','0','0','0','0','24000','24000','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','64928','127','65008','21631','4855','0','0','0','0','0');
INSERT INTO `item_proto` (`vnum`,`name`,`local_name`,`type`,`subtype`,`weight`,`size`,`antiflag`,`flag`,`wearflag`,`immuneflag`,`gold`,`shop_buy_price`,`limittype0`,`limitvalue0`,`limittype1`,`limitvalue1`,`applytype0`,`applyvalue0`,`applytype1`,`applyvalue1`,`applytype2`,`applyvalue2`,`value0`,`value1`,`value2`,`value3`,`value4`,`value5`,`socket0`,`socket1`,`socket2`,`socket3`,`socket4`,`socket5`,`refined_vnum`,`refine_set`,`magic_pct`,`specular`,`socket_pct`) VALUES ('119223','??????','Smocza Łuska','14','3','0','1','0','0','0','0','24000','24000','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','64928','127','65008','21631','4855','0','0','0','0','0');
INSERT INTO `item_proto` (`vnum`,`name`,`local_name`,`type`,`subtype`,`weight`,`size`,`antiflag`,`flag`,`wearflag`,`immuneflag`,`gold`,`shop_buy_price`,`limittype0`,`limitvalue0`,`limittype1`,`limitvalue1`,`applytype0`,`applyvalue0`,`applytype1`,`applyvalue1`,`applytype2`,`applyvalue2`,`value0`,`value1`,`value2`,`value3`,`value4`,`value5`,`socket0`,`socket1`,`socket2`,`socket3`,`socket4`,`socket5`,`refined_vnum`,`refine_set`,`magic_pct`,`specular`,`socket_pct`) VALUES ('119224','??????','Piasek Kwarcowy','14','3','0','1','0','0','0','0','24000','24000','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','64928','127','65008','21631','4855','0','0','0','0','0');
INSERT INTO `item_proto` (`vnum`,`name`,`local_name`,`type`,`subtype`,`weight`,`size`,`antiflag`,`flag`,`wearflag`,`immuneflag`,`gold`,`shop_buy_price`,`limittype0`,`limitvalue0`,`limittype1`,`limitvalue1`,`applytype0`,`applyvalue0`,`applytype1`,`applyvalue1`,`applytype2`,`applyvalue2`,`value0`,`value1`,`value2`,`value3`,`value4`,`value5`,`socket0`,`socket1`,`socket2`,`socket3`,`socket4`,`socket5`,`refined_vnum`,`refine_set`,`magic_pct`,`specular`,`socket_pct`) VALUES ('119225','??????','Niebieski Kryształ','14','3','0','1','0','0','0','0','24000','24000','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','64928','127','65008','21631','4855','0','0','0','0','0');
INSERT INTO `item_proto` (`vnum`,`name`,`local_name`,`type`,`subtype`,`weight`,`size`,`antiflag`,`flag`,`wearflag`,`immuneflag`,`gold`,`shop_buy_price`,`limittype0`,`limitvalue0`,`limittype1`,`limitvalue1`,`applytype0`,`applyvalue0`,`applytype1`,`applyvalue1`,`applytype2`,`applyvalue2`,`value0`,`value1`,`value2`,`value3`,`value4`,`value5`,`socket0`,`socket1`,`socket2`,`socket3`,`socket4`,`socket5`,`refined_vnum`,`refine_set`,`magic_pct`,`specular`,`socket_pct`) VALUES ('119226','??????','Demoniczne Prochy','14','3','0','1','0','0','0','0','24000','24000','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','64928','127','65008','21631','4855','0','0','0','0','0');
INSERT INTO `item_proto` (`vnum`,`name`,`local_name`,`type`,`subtype`,`weight`,`size`,`antiflag`,`flag`,`wearflag`,`immuneflag`,`gold`,`shop_buy_price`,`limittype0`,`limitvalue0`,`limittype1`,`limitvalue1`,`applytype0`,`applyvalue0`,`applytype1`,`applyvalue1`,`applytype2`,`applyvalue2`,`value0`,`value1`,`value2`,`value3`,`value4`,`value5`,`socket0`,`socket1`,`socket2`,`socket3`,`socket4`,`socket5`,`refined_vnum`,`refine_set`,`magic_pct`,`specular`,`socket_pct`) VALUES ('119227','??????','Orkowa Maczuga','14','3','0','1','0','0','0','0','24000','24000','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','64928','127','65008','21631','4855','0','0','0','0','0');
INSERT INTO `item_proto` (`vnum`,`name`,`local_name`,`type`,`subtype`,`weight`,`size`,`antiflag`,`flag`,`wearflag`,`immuneflag`,`gold`,`shop_buy_price`,`limittype0`,`limitvalue0`,`limittype1`,`limitvalue1`,`applytype0`,`applyvalue0`,`applytype1`,`applyvalue1`,`applytype2`,`applyvalue2`,`value0`,`value1`,`value2`,`value3`,`value4`,`value5`,`socket0`,`socket1`,`socket2`,`socket3`,`socket4`,`socket5`,`refined_vnum`,`refine_set`,`magic_pct`,`specular`,`socket_pct`) VALUES ('119228','??????','Magiczne Nasiona','14','3','0','1','0','0','0','0','24000','24000','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','64928','127','65008','21631','4855','0','0','0','0','0');
INSERT INTO `item_proto` (`vnum`,`name`,`local_name`,`type`,`subtype`,`weight`,`size`,`antiflag`,`flag`,`wearflag`,`immuneflag`,`gold`,`shop_buy_price`,`limittype0`,`limitvalue0`,`limittype1`,`limitvalue1`,`applytype0`,`applyvalue0`,`applytype1`,`applyvalue1`,`applytype2`,`applyvalue2`,`value0`,`value1`,`value2`,`value3`,`value4`,`value5`,`socket0`,`socket1`,`socket2`,`socket3`,`socket4`,`socket5`,`refined_vnum`,`refine_set`,`magic_pct`,`specular`,`socket_pct`) VALUES ('119229','??????','Kość Palca','14','3','0','1','0','0','0','0','24000','24000','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','64928','127','65008','21631','4855','0','0','0','0','0');

 

Ponieważ wyświetla się błąd:

 

Nie mogę również dodawać innych z gb1414cośtam.

Nie wiem o co chodzi. ;/

 

sf2010.

[XdanielXmetin2]

f5

[RaymanGT]

Dodałem poprawniony ss.

[Lesteross]

Hmm... sądze że źle skopiowałeś.

Po prostu uciąłeś z przodu 'I'

[RaymanGT]

Hmm... sądze że źle skopiowałeś.

Po prostu uciąłeś z przodu 'I'

 

Słuszna uwaga, lecz teraz jest takie coś:

[Lesteross]

Zamiast 'local_name' sprawdź 'locale_name'.

Najlepiej sprawdź jak masz w tabeli 'item_proto' w trzeciej kolumnie.

[szymano123]

Zamiast local_name ma być locale_name.

[RaymanGT]

Działa, do zamknięcia.