ThegameSeconds Posted February 17, 2015 Share Posted February 17, 2015 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 More sharing options...
Dante44® Posted February 17, 2015 Share Posted February 17, 2015 Pack and client? Link to comment Share on other sites More sharing options...
Dante44® Posted February 17, 2015 Share Posted February 17, 2015 (edited) Choose lower ID what is that 44555566 ID? That id is too big18565983 also the others change them also on itemname and weapongroup Edited February 17, 2015 by Dante44® Link to comment Share on other sites More sharing options...
ThegameSeconds Posted February 17, 2015 Author Share Posted February 17, 2015 I got it from this http://www.maxcheaters.com/topic/162663-antharas-valakas-lindvior-weapons-freya-god/ Link to comment Share on other sites More sharing options...
Pleyne Posted February 17, 2015 Share Posted February 17, 2015 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 More sharing options...
Dante44® Posted February 17, 2015 Share Posted February 17, 2015 That is for freya h5 l2j dont have the weapons in database the weapons are located in xml file Link to comment Share on other sites More sharing options...
Dante44® Posted February 17, 2015 Share Posted February 17, 2015 http://www.mediafire.com/download/1341nc7bny2t6ip/patch.7z http://www.mediafire.com/download/q0w5gd68eqx59x2/files.rar God armor and weapons Tested And Working Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now