Kwlotoumpas Posted June 26, 2011 Posted June 26, 2011 When im trying to install any query i get the following error!Could you please help me? INSERT INTO `custom_weapon` VALUES ('11112', 'Bow of Halisha', 'lrhand', 'true', '1650', '1', '1', 'adamantaite', 's', '581', '5', 'bow', '12', '-3.00000', '0', '0', '0', '293', '11', '132', '-1', '48800000', 2440, 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); [Err] 1136 - Column count doesn't match value count at row 1 Quote
0 Grierosu Posted June 26, 2011 Posted June 26, 2011 add me on msn grierosuandrei@yahoo.com I think the problem of your sql is because of the "material" who's adamantaite.... and dosen't exist that material or you do not have the columb for materials. Quote
0 Kwlotoumpas Posted June 26, 2011 Author Posted June 26, 2011 Adding you,thanks. Any other help is appreciated too :) Quote
0 Kwlotoumpas Posted June 27, 2011 Author Posted June 27, 2011 He didnt help me at all.Didnt even reply me with an answer.Someone would really help me please?I would really appreciate it! Quote
0 Trance Posted June 27, 2011 Posted June 27, 2011 Easy, I'll contact ya today later when I have free time. Quote
0 SweeTs Posted June 27, 2011 Posted June 27, 2011 [Err] 1136 - Column count doesn't match value count Like error says. Probably you have not enough column in custom_weapon table - too much columns in your code. Compare columns count with code and add/remove '0' :) So, add it manually or add these weapons into 'weapon' table (number of column is correct) :) Quote
0 Kwlotoumpas Posted June 27, 2011 Author Posted June 27, 2011 Easy, I'll contact ya today later when I have free time. Contact as soon as possible please.Thanks for your help tho :) Like error says. Probably you have not enough column in custom_weapon table - too much columns in your code. Compare columns count with code and add/remove '0' :) So, add it manually or add these weapons into 'weapon' table (number of column is correct) :) Which line i should remove? :O Quote
0 SweeTs Posted June 27, 2011 Posted June 27, 2011 Type manually values, one by one and see what left - remove. :) Quote
0 Tryskell Posted June 27, 2011 Posted June 27, 2011 DDDuuuuuddddeeesss (moderators : Matim Finito, etc etc) add freakin rules like "Pack/Chronicle needed else post is deleted" it's boring like shit to ask 50x it per day. "Tryskell president, tryskell president yyyyyyyyeeeeaaahhhhhh". @Topic creator, refer to line 1 of my post. You use a pack going to "IL custom" to "begin of Freya", and you hope we can help you ? Not my goal to search what pack you're using. Give more infos. Quote
0 Trance Posted June 27, 2011 Posted June 27, 2011 DDDuuuuuddddeeesss (moderators : Matim Finito, etc etc) add freakin rules like "Pack/Chronicle needed else post is deleted" it's boring like shit to ask 50x it per day. "Tryskell president, tryskell president yyyyyyyyeeeeaaahhhhhh". @Topic creator, refer to line 1 of my post. You use a pack going to "IL custom" to "begin of Freya", and you hope we can help you ? Not my goal to search what pack you're using. Give more infos. haxhxahxahaxhxah Quote
Question
Kwlotoumpas
When im trying to install any query i get the following error!Could you please help me?
[Err] 1136 - Column count doesn't match value count at row 1
9 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.