[Problem]Wpisy do navicat'a

szogun5555 · 21 Stycznia 2014

Witam dziś podczas dodawania broni w navi wyskoczył mi taki błąd co za tym idzie oczywiście bronie się nie dodały, proszę o pomoc jak to naprawić: Column count doesn't match value count at row 1

Natalia<3 · 21 Stycznia 2014

Masz złe wpisy w jakiejś kolumnie nie zgadza się wartość ;] Przejrzyj wpisy czy są aby na pewno dobre a nie pomieszane ;p Np tam gdzie nie powinno być nic możesz mieć jakąś wartość lub możesz mieć za dużo wartości a za mało kolumn ;p

szogun5555 · 22 Stycznia 2014

wpis wygląda tak;

INSERT INTO `item_proto` VALUES ('53549','53549','Miecz Zlo. Smoka+9','1','0','0','2','32','1','16','0','360000','2770000','1','149','0','0','7','44','37','12','15','20','0','0','0','319','379','0','0','64896','127','65008','21631','4855','0','0','15','100','3');

INSERT INTO `item_proto` VALUES ('53548','53548','Miecz Zlo. Smoka+8','1','0','0','2','32','1','16','0','360000','1845000','1','149','0','0','7','42','37','10','15','16','0','0','0','288','328','0','0','64896','127','65008','21631','4855','909','89','15','80','3');

INSERT INTO `item_proto` VALUES ('53547','53547','Miecz Zlo. Smoka+7','1','0','0','2','32','1','16','0','360000','1320000','1','149','0','0','7','40','37','9','15','14','0','0','0','245','299','0','0','64896','127','65008','21631','4855','908','88','15','65','3');

INSERT INTO `item_proto` VALUES ('53546','53546','Miecz. Zlo. Smoka+6','1','0','0','2','32','1','16','0','360000','975000','1','149','0','0','7','38','37','8','15','11','0','0','0','222','268','0','0','64896','127','65008','21631','4855','907','87','15','50','3');

INSERT INTO `item_proto` VALUES ('53545','53545','Miecz. Zlo. Smoka+5','1','0','0','2','32','1','16','0','360000','750000','1','149','0','0','7','36','37','6','15','10','0','0','0','210','245','0','0','64896','127','65008','21631','4855','906','86','15','40','3');

INSERT INTO `item_proto` VALUES ('53544','53544','Miecz. Zlo. Smoka+4','1','0','0','2','32','1','16','0','360000','600000','1','149','0','0','7','34','37','5','15','8','0','0','0','201','232','0','0','64896','127','65008','21631','4855','905','85','15','30','3');

INSERT INTO `item_proto` VALUES ('53543','53543','Miecz. Zlo. Smoka+3','1','0','0','2','32','1','16','0','360000','500000','1','149','0','0','7','32','37','3','15','6','0','0','0','171','206','0','0','64896','127','65008','21631','4855','904','84','15','30','3');

INSERT INTO `item_proto` VALUES ('53542','53542','Miecz. Zlo. Smoka+2','1','0','0','2','32','1','16','0','360000','435000','1','149','0','0','7','30','37','2','15','5','0','0','0','156','181','0','0','64896','127','65008','21631','4855','903','83','15','30','3');

INSERT INTO `item_proto` VALUES ('53541','53541','Miecz. Zlo. Smoka+1','1','0','0','2','32','1','16','0','360000','395000','1','149','0','0','7','28','37','1','15','2','0','0','0','141','162','0','0','64896','127','65008','21631','4855','902','82','15','30','3');

INSERT INTO `item_proto` VALUES ('53540','53540','Miecz. Zlo. Smoka+0','1','0','0','2','32','1','16','0','360000','360000','1','149','0','0','7','26','37','1','15','2','0','0','0','136','141','0','0','64896','127','65008','21631','4855','901','81','15','30','3');

INSERT INTO `item_proto` VALUES ('53539','53539','Miecz Zlotego. Smoka+9','1','0','0','2','44','1','16','0','360000','2770000','1','149','0','0','7','45','9','35','37','12','0','335','385','267','292','0','0','64896','127','65008','21631','4855','0','0','15','100','3');

INSERT INTO `item_proto` VALUES ('53538','53538','Miecz Zlotego. Smoka+8','1','0','0','2','44','1','16','0','360000','1845000','1','149','0','0','7','41','9','32','37','10','0','322','379','249','279','0','0','64896','127','65008','21631','4855','919','89','15','80','3');

INSERT INTO `item_proto` VALUES ('53537','53537','Miecz Zlotego. Smoka+7','1','0','0','2','44','1','16','0','360000','1320000','1','149','0','0','7','38','9','27','37','9','0','315','366','220','249','0','0','64896','127','65008','21631','4855','918','88','15','65','3');

INSERT INTO `item_proto` VALUES ('53536','53536','Miecz. Zlotego. Smoka+6','1','0','0','2','44','1','16','0','360000','975000','1','149','0','0','7','38','9','24','37','8','0','309','351','206','224','0','0','64896','127','65008','21631','4855','917','87','15','50','3');

INSERT INTO `item_proto` VALUES ('53535','53535','Miecz. Zlotego. Smoka+5','1','0','0','2','44','1','16','0','360000','750000','1','149','0','0','7','34','9','19','37','6','0','297','342','199','215','0','0','64896','127','65008','21631','4855','916','86','15','40','3');

INSERT INTO `item_proto` VALUES ('53534','53534','Miecz. Zlotego. Smoka+4','1','0','0','2','44','1','16','0','360000','600000','1','149','0','0','7','34','9','16','37','5','0','289','325','191','207','0','0','64896','127','65008','21631','4855','915','85','15','30','3');

INSERT INTO `item_proto` VALUES ('53533','53533','Miecz. Zlotego. Smoka+3','1','0','0','2','44','1','16','0','360000','500000','1','149','0','0','7','31','9','13','37','3','0','273','318','195','199','0','0','64896','127','65008','21631','4855','914','84','15','30','3');

INSERT INTO `item_proto` VALUES ('53532','53532','Miecz. Zlotego. Smoka+2','1','0','0','2','44','1','16','0','360000','435000','1','149','0','0','7','31','9','11','37','2','0','262','309','176','193','0','0','64896','127','65008','21631','4855','913','83','15','30','3');

INSERT INTO `item_proto` VALUES ('53531','53531','Miecz. Zlotego. Smoka+1','1','0','0','2','44','1','16','0','360000','395000','1','149','0','0','7','29','9','9','37','1','0','257','302','169','189','0','0','64896','127','65008','21631','4855','912','82','15','30','3');

INSERT INTO `item_proto` VALUES ('53530','53530','Miecz. Zlotego. Smoka+0','1','0','0','2','44','1','16','0','360000','360000','1','149','0','0','7','29','9','8','37','1','0','252','297','165','182','0','0','64896','127','65008','21631','4855','911','81','15','30','3');

INSERT INTO `item_proto` VALUES ('53569','53569','Ostrze Zlo. Smoka+9','1','3','0','3','56','1','16','0','360000','2770000','1','149','0','0','7','30','37','12','16','15','0','0','0','379','410','0','0','64896','127','65008','21631','4855','0','0','15','100','3');

INSERT INTO `item_proto` VALUES ('53568','53568','Ostrze Zlo. Smoka+8','1','3','0','3','56','1','16','0','360000','1845000','1','149','0','0','7','30','37','10','16','13','0','0','0','356','399','0','0','64896','127','65008','21631','4855','929','89','15','80','3');

INSERT INTO `item_proto` VALUES ('53567','53567','Ostrze Zlo. Smoka+7','1','3','0','3','56','1','16','0','360000','1320000','1','149','0','0','7','30','37','9','16','11','0','0','0','323','386','0','0','64896','127','65008','21631','4855','928','88','15','65','3');

INSERT INTO `item_proto` VALUES ('53566','53566','Ostrze. Zlo. Smoka+6','1','3','0','3','56','1','16','0','360000','975000','1','149','0','0','7','30','37','8','16','9','0','0','0','288','315','0','0','64896','127','65008','21631','4855','927','87','15','50','3');

INSERT INTO `item_proto` VALUES ('53565','53565','Ostrze. Zlo. Smoka+5','1','3','0','3','56','1','16','0','360000','750000','1','149','0','0','7','30','37','6','16','8','0','0','0','240','299','0','0','64896','127','65008','21631','4855','926','86','15','40','3');

INSERT INTO `item_proto` VALUES ('53564','53564','Ostrze. Zlo. Smoka+4','1','3','0','3','56','1','16','0','360000','600000','1','149','0','0','7','30','37','5','16','8','0','0','0','215','279','0','0','64896','127','65008','21631','4855','925','85','15','30','3');

INSERT INTO `item_proto` VALUES ('53563','53563','Ostrze. Zlo. Smoka+3','1','3','0','3','56','1','16','0','360000','500000','1','149','0','0','7','30','37','3','16','7','0','0','0','199','230','0','0','64896','127','65008','21631','4855','924','84','15','30','3');

INSERT INTO `item_proto` VALUES ('53562','53562','Ostrze. Zlo. Smoka+2','1','3','0','3','56','1','16','0','360000','435000','1','149','0','0','7','30','37','2','16','5','0','0','0','185','222','0','0','64896','127','65008','21631','4855','923','83','15','30','3');

INSERT INTO `item_proto` VALUES ('53561','53561','Ostrze. Zlo. Smoka+1','1','3','0','3','56','1','16','0','360000','395000','1','149','0','0','7','30','37','1','16','3','0','0','0','173','213','0','0','64896','127','65008','21631','4855','922','82','15','30','3');

INSERT INTO `item_proto` VALUES ('53560','53560','Ostrze. Zlo. Smoka+0','1','3','0','3','56','1','16','0','360000','360000','1','149','0','0','7','30','37','1','16','2','0','0','0','166','205','0','0','64896','127','65008','21631','4855','921','81','15','30','3');

INSERT INTO `item_proto` VALUES ('53559','53559','Sztylety Zlo. Smoka+9','1','1','0','1','52','1','16','0','360000','2770000','1','149','0','0','7','40','37','12','12','15','0','0','0','275','300','0','0','64896','127','65008','21631','4855','0','0','15','100','3');

INSERT INTO `item_proto` VALUES ('53558','53558','Sztylety Zlo. Smoka+8','1','1','0','1','52','1','16','0','360000','1845000','1','149','0','0','7','35','37','10','12','13','0','0','0','232','269','0','0','64896','127','65008','21631','4855','939','89','15','80','3');

INSERT INTO `item_proto` VALUES ('53557','53557','Sztylety Zlo. Smoka+7','1','1','0','1','52','1','16','0','360000','1320000','1','149','0','0','7','35','37','9','12','11','0','0','0','204','238','0','0','64896','127','65008','21631','4855','938','88','15','65','3');

INSERT INTO `item_proto` VALUES ('53556','53556','Sztylety. Zlo. Smoka+6','1','1','0','1','52','1','16','0','360000','975000','1','149','0','0','7','35','37','8','12','9','0','0','0','178','215','0','0','64896','127','65008','21631','4855','937','87','15','50','3');

INSERT INTO `item_proto` VALUES ('53555','53555','Sztylety. Zlo. Smoka+5','1','1','0','1','52','1','16','0','360000','750000','1','149','0','0','7','33','37','6','12','8','0','0','0','146','194','0','0','64896','127','65008','21631','4855','936','86','15','40','3');

INSERT INTO `item_proto` VALUES ('53554','53554','Sztylety. Zlo. Smoka+4','1','1','0','1','52','1','16','0','360000','600000','1','149','0','0','7','33','37','5','12','8','0','0','0','134','171','0','0','64896','127','65008','21631','4855','935','85','15','30','3');

INSERT INTO `item_proto` VALUES ('53553','53553','Sztylety. Zlo. Smoka+3','1','1','0','1','52','1','16','0','360000','500000','1','149','0','0','7','33','37','3','12','7','0','0','0','127','159','0','0','64896','127','65008','21631','4855','934','84','15','30','3');

INSERT INTO `item_proto` VALUES ('53552','53552','Sztylety. Zlo. Smoka+2','1','1','0','1','52','1','16','0','360000','435000','1','149','0','0','7','31','37','2','12','5','0','0','0','119','145','0','0','64896','127','65008','21631','4855','933','83','15','30','3');

INSERT INTO `item_proto` VALUES ('53551','53551','Sztylety. Zlo. Smoka+1','1','1','0','1','52','1','16','0','360000','395000','1','149','0','0','7','31','37','1','12','2','0','0','0','106','129','0','0','64896','127','65008','21631','4855','932','82','15','30','3');

INSERT INTO `item_proto` VALUES ('53550','53550','Sztylety. Zlo. Smoka+0','1','1','0','1','52','1','16','0','360000','360000','1','149','0','0','7','31','37','1','12','2','0','0','0','101','121','0','0','64896','127','65008','21631','4855','931','81','15','30','3');

INSERT INTO `item_proto` VALUES ('53519','53519','Łuk Zlo. Smoka+9','1','2','0','2','52','1','16','0','360000','1925000','1','149','0','0','7','40','37','12','15','15','0','0','0','423','515','0','0','64896','127','65008','21631','4855','0','0','15','100','3');

INSERT INTO `item_proto` VALUES ('53518','53518','Łuk Zlo. Smoka+8','1','2','0','2','52','1','16','0','360000','1280000','1','149','0','0','7','35','37','10','15','13','0','0','0','395','486','0','0','64896','127','65008','21631','4855','949','89','15','80','3');

INSERT INTO `item_proto` VALUES ('53517','53517','Łuk Zlo. Smoka+7','1','2','0','2','52','1','16','0','360000','915000','1','149','0','0','7','35','37','9','15','11','0','0','0','346','435','0','0','64896','127','65008','21631','4855','948','88','15','65','3');

INSERT INTO `item_proto` VALUES ('53516','53516','Łuk. Zlo. Smoka+6','1','2','0','2','52','1','16','0','360000','680000','1','149','0','0','7','35','37','8','15','9','0','0','0','312','418','0','0','64896','127','65008','21631','4855','947','87','15','50','3');

INSERT INTO `item_proto` VALUES ('53515','53515','Łuk. Zlo. Smoka+5','1','2','0','2','52','1','16','0','360000','520000','1','149','0','0','7','33','37','6','15','8','0','0','0','291','408','0','0','64896','127','65008','21631','4855','946','86','15','40','3');

INSERT INTO `item_proto` VALUES ('53514','53514','Łuk. Zlo. Smoka+4','1','2','0','2','52','1','16','0','360000','415000','1','149','0','0','7','33','37','5','15','8','0','0','0','282','382','0','0','64896','127','65008','21631','4855','945','85','15','30','3');

INSERT INTO `item_proto` VALUES ('53513','53513','Łuk. Zlo. Smoka+3','1','2','0','2','52','1','16','0','360000','350000','1','149','0','0','7','33','37','3','15','7','0','0','0','268','368','0','0','64896','127','65008','21631','4855','944','84','15','30','3');

INSERT INTO `item_proto` VALUES ('53512','53512','Łuk. Zlo. Smoka+2','1','2','0','2','52','1','16','0','360000','305000','1','149','0','0','7','31','37','2','15','5','0','0','0','245','336','0','0','64896','127','65008','21631','4855','943','83','15','30','3');

INSERT INTO `item_proto` VALUES ('53511','53511','Łuk. Zlo. Smoka+1','1','2','0','2','52','1','16','0','360000','275000','1','149','0','0','7','31','37','1','15','3','0','0','0','236','328','0','0','64896','127','65008','21631','4855','942','82','15','30','3');

INSERT INTO `item_proto` VALUES ('53510','53510','Łuk. Zlo. Smoka+0','1','2','0','2','52','1','16','0','360000','250000','1','149','0','0','7','31','37','1','15','2','0','0','0','221','322','0','0','64896','127','65008','21631','4855','941','81','15','30','3');

INSERT INTO `item_proto` VALUES ('53529','53529','Dzwon Zlo. Smoka+9','1','4','0','1','28','1','16','0','360000','2770000','1','149','0','0','7','35','37','12','13','15','0','203','212','288','342','0','0','64896','127','65008','21631','4855','0','0','15','100','3');

INSERT INTO `item_proto` VALUES ('53528','53528','Dzwon Zlo. Smoka+8','1','4','0','1','28','1','16','0','360000','1845000','1','149','0','0','7','32','37','10','13','13','0','192','208','259','312','0','0','64896','127','65008','21631','4855','959','89','15','80','3');

INSERT INTO `item_proto` VALUES ('53527','53527','Dzwon Zlo. Smoka+7','1','4','0','1','28','1','16','0','360000','1320000','1','149','0','0','7','32','37','9','13','11','0','185','196','246','296','0','0','64896','127','65008','21631','4855','958','88','15','65','3');

INSERT INTO `item_proto` VALUES ('53526','53526','Dzwon. Zlo. Smoka+6','1','4','0','1','28','1','16','0','360000','975000','1','149','0','0','7','29','37','8','13','9','0','172','177','232','282','0','0','64896','127','65008','21631','4855','957','87','15','50','3');

INSERT INTO `item_proto` VALUES ('53525','53525','Dzwon. Zlo. Smoka+5','1','4','0','1','28','1','16','0','360000','750000','1','149','0','0','7','29','37','6','13','8','0','148','169','205','275','0','0','64896','127','65008','21631','4855','956','86','15','40','3');

INSERT INTO `item_proto` VALUES ('53524','53524','Dzwon. Zlo. Smoka+4','1','4','0','1','28','1','16','0','360000','600000','1','149','0','0','7','26','37','5','13','8','0','138','152','172','242','0','0','64896','127','65008','21631','4855','955','85','15','30','3');

INSERT INTO `item_proto` VALUES ('53523','53523','Dzwon. Zlo. Smoka+3','1','4','0','1','28','1','16','0','360000','500000','1','149','0','0','7','26','37','3','13','7','0','119','148','155','223','0','0','64896','127','65008','21631','4855','954','84','15','30','3');

INSERT INTO `item_proto` VALUES ('53522','53522','Dzwon. Zlo. Smoka+2','1','4','0','1','28','1','16','0','360000','435000','1','149','0','0','7','23','37','2','13','5','0','112','135','136','212','0','0','64896','127','65008','21631','4855','953','83','15','30','3');

INSERT INTO `item_proto` VALUES ('53521','53521','Dzwon. Zlo. Smoka+1','1','4','0','1','28','1','16','0','360000','395000','1','149','0','0','7','23','37','1','13','3','0','106','121','121','201','0','0','64896','127','65008','21631','4855','952','82','15','30','3');

INSERT INTO `item_proto` VALUES ('53520','53520','Dzwon. Zlo. Smoka+0','1','4','0','1','28','1','16','0','360000','360000','1','149','0','0','7','20','37','1','13','2','0','101','106','111','169','0','0','64896','127','65008','21631','4855','951','81','15','30','3');

INSERT INTO `item_proto` VALUES ('53579','53579','Wachlarz Zlo. Smoka+9','1','5','0','1','28','1','16','0','360000','2770000','1','149','0','0','7','35','9','35','37','12','0','238','259','192','222','0','0','64896','127','65008','21631','4855','0','0','15','100','3');

INSERT INTO `item_proto` VALUES ('53578','53578','Wachlarz Zlo. Smoka+8','1','5','0','1','28','1','16','0','360000','1845000','1','149','0','0','7','32','9','32','37','10','0','223','235','169','215','0','0','64896','127','65008','21631','4855','969','89','15','80','3');

INSERT INTO `item_proto` VALUES ('53577','53577','Wachlarz Zlo. Smoka+7','1','5','0','1','28','1','16','0','360000','1320000','1','149','0','0','7','32','9','27','37','9','0','215','220','153','206','0','0','64896','127','65008','21631','4855','968','88','15','65','3');

INSERT INTO `item_proto` VALUES ('53576','53576','Wachlarz. Zlo. Smoka+6','1','5','0','1','28','1','16','0','360000','975000','1','149','0','0','7','29','9','24','37','8','0','207','209','145','203','0','0','64896','127','65008','21631','4855','967','87','15','50','3');

INSERT INTO `item_proto` VALUES ('53575','53575','Wachlarz. Zlo. Smoka+5','1','5','0','1','28','1','16','0','360000','750000','1','149','0','0','7','29','9','19','37','6','0','201','191','131','182','0','0','64896','127','65008','21631','4855','966','86','15','40','3');

INSERT INTO `item_proto` VALUES ('53574','53574','Wachlarz. Zlo. Smoka+4','1','5','0','1','28','1','16','0','360000','600000','1','149','0','0','7','26','9','16','37','5','0','188','183','125','179','0','0','64896','127','65008','21631','4855','965','85','15','30','3');

INSERT INTO `item_proto` VALUES ('53573','53573','Wachlarz. Zlo. Smoka+3','1','5','0','1','28','1','16','0','360000','500000','1','149','0','0','7','26','9','13','37','3','0','172','167','115','169','0','0','64896','127','65008','21631','4855','964','84','15','30','3');

INSERT INTO `item_proto` VALUES ('53572','53572','Wachlarz. Zlo. Smoka+2','1','5','0','1','28','1','16','0','360000','435000','1','149','0','0','7','23','9','11','37','2','0','144','156','109','149','0','0','64896','127','65008','21631','4855','963','83','15','30','3');

INSERT INTO `item_proto` VALUES ('53571','53571','Wachlarz. Zlo. Smoka+1','1','5','0','1','28','1','16','0','360000','395000','1','149','0','0','7','23','9','9','37','1','0','136','149','106','136','0','0','64896','127','65008','21631','4855','962','82','15','30','3');

INSERT INTO `item_proto` VALUES ('53570','53570','Wachlarz. Zlo. Smoka+0','1','5','0','1','28','1','16','0','360000','360000','1','149','0','0','7','20','9','8','37','1','0','124','136','101','123','0','0','64896','127','65008','21631','4855','961','81','15','30','3');

Natalia<3 · 22 Stycznia 2014

Spróbuj wgrać ręcznie którąś z tych tabelek i sprawdź gdzie jest niepoprawna wartość ;]

Zaloguj się

[Problem]Wpisy do navicat'a

Rekomendowane odpowiedzi

szogun5555

Odnośnik do komentarza

Natalia<3

Odnośnik do komentarza

szogun5555

Odnośnik do komentarza

Natalia<3

Odnośnik do komentarza

Zarchiwizowany