NewWars 875 Posted August 20, 2012 Boas pessoalA uns dias que tenho tentado meter as montadas a atacar e etcFinalmente consegui.Mas agora chega na hora de implmentar no server com uam query no navicat e dame um erroDeixo aqui a query e o erroQuery's:INSERT INTO mob_proto VALUES ('20110', 'boar', 0x4E6F6E616D65202020202020202020202020202020202020, '5', '1', '0', '1', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', 'lion', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '2', '2', '400', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '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 mob_proto VALUES ('20112', 'Feuer Tiger', 0x4E6F6E616D65202020202020202020202020202020202020, '5', '1', '0', '1', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', 'lion', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '2', '2', '400', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '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 mob_proto VALUES ('20111', 'Wolf', 0x4E6F6E616D65202020202020202020202020202020202020, '5', '1', '0', '1', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', 'lion', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '2', '2', '400', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');Erro:[Err] 1136 - Column count doesn't match value count at row 1Todas elas dão o mesmo erro.Adradeço que me possam ajudar 1 Valenza reacted to this Share this post Link to post Share on other sites
0 WildEgo 1,486 Posted August 20, 2012 Contagem de colunas não confere com a contagem de valores na linha 1 - Google tradutor tens ai a tua resposta acho... Share this post Link to post Share on other sites
0 NewWars 875 Posted August 20, 2012 Eu sei ler ingles melhor que portugues --'.Eu ja meti o numero da coluna 78979 para ver se dava e ta igual Share this post Link to post Share on other sites
0 kilerbite1 3 Posted February 11, 2013 Mesmo problema. Share this post Link to post Share on other sites
0 kimameixede 70 Posted February 11, 2013 arranja outra query Share this post Link to post Share on other sites
0 vida100vida 27 Posted February 11, 2013 esta query esta a faltar alguma coisa ou o problema e com suas files. Share this post Link to post Share on other sites
Boas pessoalA uns dias que tenho tentado meter as montadas a atacar e etcFinalmente consegui.Mas agora chega na hora de implmentar no server com uam query no navicat e dame um erroDeixo aqui a query e o erroQuery's:INSERT INTO mob_proto VALUES ('20110', 'boar', 0x4E6F6E616D65202020202020202020202020202020202020, '5', '1', '0', '1', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', 'lion', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '2', '2', '400', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '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 mob_proto VALUES ('20112', 'Feuer Tiger', 0x4E6F6E616D65202020202020202020202020202020202020, '5', '1', '0', '1', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', 'lion', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '2', '2', '400', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '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 mob_proto VALUES ('20111', 'Wolf', 0x4E6F6E616D65202020202020202020202020202020202020, '5', '1', '0', '1', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', 'lion', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '2', '2', '400', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');Erro:[Err] 1136 - Column count doesn't match value count at row 1Todas elas dão o mesmo erro.Adradeço que me possam ajudar
Share this post
Link to post
Share on other sites