Jump to content

Error Execute Sql File


Recommended Posts

Some one help me about this

[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `weapon` VALUES  
(18565983, "Antharas Sword {Awake} [R99]", "rhand", "true", 970, 1, 1, "adamantaite", "s", 281, 5, "sword", 12, -3, 0, 0, 0, 433, 0, 145, -1, 0, 0, "false", "true", "true", "true", 3023, 3, 0, 0, 0, 0, 0, 0, 0, 0),
(18565986, "Antharas Dagger {Awake} [R99]", "rhand", "true", 1800, 1, 1, "adamantaite", "s", 309, 10, "dagger", 5, -3, 0, 0, 0, 325, 0, 145, -1, 0, 0, "false", "true", "true", "true", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(18565989, "Antharas Mace {Awake} [R99]]", "rhand", "true", 1350, 1, 1, "adamantaite", "s", 281, 5, "blunt", 4, 4, 0, 0, 0, 325, 0, 145, -1, 0, 0, "false", "true", "true", "true", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(18565992, "Antharas Hammer {Awake} [R99]", "rhand", "true", 1380, 1, 1, "adamantaite", "s", 342, 10, "blunt", 8, 0, 0, 0, 0, 325, 0, 145, -1, 0, 0, "false", "true", "true", "true", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(18565995, "Antharas Bigsword {Awake} [R99]", "lrhand", "true", 1650, 1, 1, "adamantaite", "s", 581, 5, "bigsword", 12, -3, 0, 0, 0, 300, 11, 145, -1, 0, 0, "false", "true", "true", "true", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(18565998, "Antharas Fist {Awake} [R99]", "lrhand", "true", 1420, 2, 2, "adamantaite", "s", 342, 10, "dualfist", 5, 0, 0, 0, 0, 379, 0, 145, -1, 0, 0, "false", "true", "true", "true", 3050, 1, 0, 0, 0, 0, 0, 0, 0, 0),
(18566001, "Antharas Polearm {Awake} [R99]", "lrhand", "true", 1730, 3, 3, "adamantaite", "s", 376, 20, "pole", 5, 4, 0, 0, 0, 379, 0, 145, -1, 0, 0, "false", "true", "true", "true", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(18566004, "Antharas Staff {Awake} [R99]", "lrhand", "true", 1300, 1, 1, "adamantaite", "s", 247, 20, "bigblunt", 4, 4, 0, 0, 0, 379, 0, 192, -1, 0, 0, "false", "true", "true", "true", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(18566007, "Antharas Stick {Awake} [R99]", "rhand", "true", 2080, 1, 1, "adamantaite", "s", 397, 10, "blunt", 8, 0, 0, 0, 0, 325, 0, 145, -1, 0, 0, "false", "true", "true", "true", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(18566010, "Antharas Spirit {Awake} [R99]", "rhand", "true", 970, 1, 1, "adamantaite", "s", 281, 5, "blunt", 12, -3, 0, 0, 0, 433, 0, 145, -1, 0, 0, "false", "true", "true", "true", 3023, 3, 0, 0, 0, 0, 0, 0, 0, 0),
(18566013, "Antharas Bow {Awake} [R99]", "lrhand", "true", 1800, 1, 1, "adamantaite", "s", 309, 10, "bow", 5, -3, 0, 0, 0, 325, 0, 145, -1, 0, 0, "false", "true", "true", "true", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(18566016, "Antharas Rapier {Awake} [R99]", "rhand", "true", 1350, 1, 1, "adamantaite", "s", 281, 5, "sword", 4, 4, 0, 0, 0, 325, 0, 145, -1, 0, 0, "false", "true", "true", "true", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(18566019, "Antharas Wingblade {Awake} [R99]", "rhand", "true", 1380, 1, 1, "adamantaite", "s", 342, 10, "sword", 8, 0, 0, 0, 0, 325, 0, 145, -1, 0, 0, "false", "true", "true", "true", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(18566022, "Antharas Crossbow {Awake} [R99]", "lrhand", "true", 1650, 1, 1, "adamantaite", "s", 581, 5, "bow", 12, -3, 0, 0, 0, 300, 11, 145, -1, 0, 0, "false", "true", "true", "true", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(18566153, "Antharas Dual Daggers {Awake} [R99]", "lrhand", "true", 1420, 2, 2, "adamantaite", "s", 342, 10, "dagger", 5, 0, 0, 0, 0, 379, 0, 145, -1, 0, 0, "false", "true", "true", "true", 3050, 1, 0, 0, 0, 0, 0, 0, 0, 0),
(18566155, "Antharas Dual sword {Awake} [R99]", "lrhand", "true", 1730, 3, 3, "adamantaite", "s", 376, 20, "dual", 5, 4, 0, 0, 0, 379, 0, 145, -1, 0, 0, "false", "true", "true", "true", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(1565587, "Antharas Shield [R99]", "lhand", "true", 1300, 1, 1, "adamantaite", "s", 247, 20, "shield", 4, 4, 0, 0, 0, 379, 0, 192, -1, 0, 0, "false", "true", "true", "true", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(18575983, "Valakas Sword {Awake} [R99]", "rhand", "true", 970, 1, 1, "adamantaite", "s", 281, 5, "sword", 12, -3, 0, 0, 0, 433, 0, 145, -1, 0, 0, "false", "true", "true", "true", 3023, 3, 0, 0, 0, 0, 0, 0, 0, 0),
(18575986, "Valakas Dagger {Awake} [R99]", "rhand", "true", 1800, 1, 1, "adamantaite", "s", 309, 10, "dagger", 5, -3, 0, 0, 0, 325, 0, 145, -1, 0, 0, "false", "true", "true", "
[Msg] Finished - Unsuccessfully
--------------------------------------------------
Link to comment
Share on other sites

Choose lower ID what is that 44555566 ID?

 

That id is too big18565983 also the others change them also on itemname and weapongroup

Edited by Dante44®
Link to comment
Share on other sites

Column count doesn't match value count at row 1

 In weapon table there are too many columns or missing some, if you don't know what is column use google translate. Long story short, you will need to add it manually, some columns may be empty ( and you should decide what to input into them by yourself, but it's so easy anyone can think it out ) or there can be too much information to input into column, so you will have to skip some from sql file.

Link to comment
Share on other sites

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share



×
×
  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock