[Help] column erro menu

User Tag List

Results 1 to 4 of 4
  1. #1
    pewor's Avatar Member
    Reputation
    1
    Join Date
    May 2007
    Posts
    88
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    [Help] column erro

    can some one help me i will rep
    Code:
    [Err] 1136 - Column count doesn't match value count at row 1
    SQL
    Code:
    INSERT INTO creature_names VALUES (50083, "Armor", "Raid Tier VII", 0, 4, 0, 3, 0, 0, 21322, 1, 1, 1, 0);
    INSERT INTO creature_names VALUES (50085, "Weapon", "Raid Tier VII", 0, 4, 0, 3, 0, 0, 21135, 1, 1, 1, 0);
    INSERT INTO `creature_proto` VALUES ('50084', '100', '100', '1741', '1000000', '1000000', '1000000', '0.55', '4', '1000', '1000', '1000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '5', '5', '5', '5', '5', '5', '5', '1', '1', '', '0', '0', '0', '0');
    INSERT INTO `creature_proto` VALUES ('50085', '100', '100', '1741', '1000000', '1000000', '1000000', '0.55', '4', '1000', '1000', '1000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '5', '5', '5', '5', '5', '5', '5', '1', '1', '', '0', '0', '0', '0');
    INSERT INTO vendors VALUES ('50085', '94008', '1');
    INSERT INTO vendors VALUES ('50085', '94009', '1');
    INSERT INTO vendors VALUES ('50085', '94013', '1');
    INSERT INTO vendors VALUES ('50085', '94014', '1');
    INSERT INTO vendors VALUES ('50085', '94015', '1');
    INSERT INTO vendors VALUES ('50085', '94017', '1');
    INSERT INTO vendors VALUES ('50085', '94029', '1');
    INSERT INTO vendors VALUES ('50085', '94030', '1');
    INSERT INTO vendors VALUES ('50085', '94029', '1');
    INSERT INTO vendors VALUES ('50085', '94030', '1');
    INSERT INTO vendors VALUES ('50085', '94039', '1');
    INSERT INTO vendors VALUES ('50085', '94050', '1');
    INSERT INTO vendors VALUES ('50085', '94060', '1');
    INSERT INTO vendors VALUES ('50085', '94068', '1');
    INSERT INTO vendors VALUES ('50085', '94071', '1');
    INSERT INTO vendors VALUES ('50085', '94080', '1');
    INSERT INTO vendors VALUES ('50085', '94081', '1');
    INSERT INTO vendors VALUES ('50085', '94086', '1');
    INSERT INTO vendors VALUES ('50085', '94091', '1');
    INSERT INTO vendors VALUES ('50085', '94098', '1');
    INSERT INTO vendors VALUES ('50085', '94102', '1');
    INSERT INTO vendors VALUES ('50085', '94116', '1');
    INSERT INTO vendors VALUES ('50085', '94124', '1');
    INSERT INTO vendors VALUES ('50085', '94137', '1');
    INSERT INTO vendors VALUES ('50085', '94138', '1');
    INSERT INTO vendors VALUES ('50085', '94139', '1');
    INSERT INTO vendors VALUES ('50085', '94144', '1');
    INSERT INTO vendors VALUES ('50085', '94147', '1');
    INSERT INTO vendors VALUES ('50085', '94148', '1');
    
    INSERT INTO vendors VALUES ('50083', '94000', '1');
    INSERT INTO vendors VALUES ('50083', '94001', '1');
    INSERT INTO vendors VALUES ('50083', '94002', '1');
    INSERT INTO vendors VALUES ('50083', '94003', '1');
    INSERT INTO vendors VALUES ('50083', '94004', '1');
    INSERT INTO vendors VALUES ('50083', '94005', '1');
    INSERT INTO vendors VALUES ('50083', '94006', '1');
    INSERT INTO vendors VALUES ('50083', '94007', '1');
    INSERT INTO vendors VALUES ('50083', '94010', '1');
    INSERT INTO vendors VALUES ('50083', '94011', '1');
    INSERT INTO vendors VALUES ('50083', '94012', '1');
    INSERT INTO vendors VALUES ('50083', '94016', '1');
    INSERT INTO vendors VALUES ('50083', '94018', '1');
    INSERT INTO vendors VALUES ('50083', '94019', '1');
    INSERT INTO vendors VALUES ('50083', '94020', '1');
    INSERT INTO vendors VALUES ('50083', '94021', '1');
    INSERT INTO vendors VALUES ('50083', '94022', '1');
    INSERT INTO vendors VALUES ('50083', '94023', '1');
    INSERT INTO vendors VALUES ('50083', '94024', '1');
    INSERT INTO vendors VALUES ('50083', '94025', '1');
    INSERT INTO vendors VALUES ('50083', '94026', '1');
    INSERT INTO vendors VALUES ('50083', '94027', '1');
    INSERT INTO vendors VALUES ('50083', '94028', '1');
    INSERT INTO vendors VALUES ('50083', '94031', '1');
    INSERT INTO vendors VALUES ('50083', '94032', '1');
    INSERT INTO vendors VALUES ('50083', '94033', '1');
    INSERT INTO vendors VALUES ('50083', '94034', '1');
    INSERT INTO vendors VALUES ('50083', '94035', '1');
    INSERT INTO vendors VALUES ('50083', '94036', '1');
    INSERT INTO vendors VALUES ('50083', '94037', '1');
    INSERT INTO vendors VALUES ('50083', '94038', '1');
    INSERT INTO vendors VALUES ('50083', '94040', '1');
    INSERT INTO vendors VALUES ('50083', '94041', '1');
    INSERT INTO vendors VALUES ('50083', '94042', '1');
    INSERT INTO vendors VALUES ('50083', '94043', '1');
    INSERT INTO vendors VALUES ('50083', '94044', '1');
    INSERT INTO vendors VALUES ('50083', '94045', '1');
    INSERT INTO vendors VALUES ('50083', '94046', '1');
    INSERT INTO vendors VALUES ('50083', '94047', '1');
    INSERT INTO vendors VALUES ('50083', '94048', '1');
    INSERT INTO vendors VALUES ('50083', '94049', '1');
    INSERT INTO vendors VALUES ('50083', '94051', '1');
    INSERT INTO vendors VALUES ('50083', '94052', '1');
    INSERT INTO vendors VALUES ('50083', '94053', '1');
    INSERT INTO vendors VALUES ('50083', '94054', '1');
    INSERT INTO vendors VALUES ('50083', '94055', '1');
    INSERT INTO vendors VALUES ('50083', '94056', '1');
    INSERT INTO vendors VALUES ('50083', '94057', '1');
    INSERT INTO vendors VALUES ('50083', '94058', '1');
    INSERT INTO vendors VALUES ('50083', '94059', '1');
    INSERT INTO vendors VALUES ('50083', '94061', '1');
    INSERT INTO vendors VALUES ('50083', '94062', '1');
    INSERT INTO vendors VALUES ('50083', '94063', '1');
    INSERT INTO vendors VALUES ('50083', '94064', '1');
    INSERT INTO vendors VALUES ('50083', '94065', '1');
    INSERT INTO vendors VALUES ('50083', '94066', '1');
    INSERT INTO vendors VALUES ('50083', '94067', '1');
    INSERT INTO vendors VALUES ('50083', '94069', '1');
    INSERT INTO vendors VALUES ('50083', '94070', '1');
    INSERT INTO vendors VALUES ('50083', '94072', '1');
    INSERT INTO vendors VALUES ('50083', '94073', '1');
    INSERT INTO vendors VALUES ('50083', '94074', '1');
    INSERT INTO vendors VALUES ('50083', '94075', '1');
    INSERT INTO vendors VALUES ('50083', '94076', '1');
    INSERT INTO vendors VALUES ('50083', '94077', '1');
    INSERT INTO vendors VALUES ('50083', '94078', '1');
    INSERT INTO vendors VALUES ('50083', '94079', '1');
    INSERT INTO vendors VALUES ('50083', '94082', '1');
    INSERT INTO vendors VALUES ('50083', '94083', '1');
    INSERT INTO vendors VALUES ('50083', '94084', '1');
    INSERT INTO vendors VALUES ('50083', '94085', '1');
    INSERT INTO vendors VALUES ('50083', '94087', '1');
    INSERT INTO vendors VALUES ('50083', '94088', '1');
    INSERT INTO vendors VALUES ('50083', '94089', '1');
    INSERT INTO vendors VALUES ('50083', '94090', '1');
    INSERT INTO vendors VALUES ('50083', '94092', '1');
    INSERT INTO vendors VALUES ('50083', '94093', '1');
    INSERT INTO vendors VALUES ('50083', '94094', '1');
    INSERT INTO vendors VALUES ('50083', '94095', '1');
    INSERT INTO vendors VALUES ('50083', '94096', '1');
    INSERT INTO vendors VALUES ('50083', '94097', '1');
    INSERT INTO vendors VALUES ('50083', '94099', '1');
    INSERT INTO vendors VALUES ('50083', '94100', '1');
    INSERT INTO vendors VALUES ('50083', '94101', '1');
    INSERT INTO vendors VALUES ('50083', '94103', '1');
    INSERT INTO vendors VALUES ('50083', '94104', '1');
    INSERT INTO vendors VALUES ('50083', '94105', '1');
    INSERT INTO vendors VALUES ('50083', '94106', '1');
    INSERT INTO vendors VALUES ('50083', '94107', '1');
    INSERT INTO vendors VALUES ('50083', '94108', '1');
    INSERT INTO vendors VALUES ('50083', '94109', '1');
    INSERT INTO vendors VALUES ('50083', '94110', '1');
    INSERT INTO vendors VALUES ('50083', '94111', '1');
    INSERT INTO vendors VALUES ('50083', '94112', '1');
    INSERT INTO vendors VALUES ('50083', '94113', '1');
    INSERT INTO vendors VALUES ('50083', '94114', '1');
    INSERT INTO vendors VALUES ('50083', '94115', '1');
    INSERT INTO vendors VALUES ('50083', '94117', '1');
    INSERT INTO vendors VALUES ('50083', '94118', '1');
    INSERT INTO vendors VALUES ('50083', '94119', '1');
    INSERT INTO vendors VALUES ('50083', '94120', '1');
    INSERT INTO vendors VALUES ('50083', '94121', '1');
    INSERT INTO vendors VALUES ('50083', '94122', '1');
    INSERT INTO vendors VALUES ('50083', '94123', '1');
    INSERT INTO vendors VALUES ('50083', '94125', '1');
    INSERT INTO vendors VALUES ('50083', '94126', '1');
    INSERT INTO vendors VALUES ('50083', '94127', '1');
    INSERT INTO vendors VALUES ('50083', '94128', '1');
    INSERT INTO vendors VALUES ('50083', '94129', '1');
    INSERT INTO vendors VALUES ('50083', '94130', '1');
    INSERT INTO vendors VALUES ('50083', '94131', '1');
    INSERT INTO vendors VALUES ('50083', '94132', '1');
    INSERT INTO vendors VALUES ('50083', '94133', '1');
    INSERT INTO vendors VALUES ('50083', '94134', '1');
    INSERT INTO vendors VALUES ('50083', '94135', '1');
    INSERT INTO vendors VALUES ('50083', '94136', '1');
    INSERT INTO vendors VALUES ('50083', '94140', '1');
    INSERT INTO vendors VALUES ('50083', '94141', '1');
    INSERT INTO vendors VALUES ('50083', '94142', '1');
    INSERT INTO vendors VALUES ('50083', '94143', '1');
    INSERT INTO vendors VALUES ('50083', '94145', '1');
    INSERT INTO vendors VALUES ('50083', '94146', '1');
    INSERT INTO vendors VALUES ('50083', '94149', '1');
    INSERT INTO vendors VALUES ('50083', '94150', '1');

    [Help] column erro
  2. #2
    2dgreengiant's Avatar ★ Elder ★


    Reputation
    1190
    Join Date
    Feb 2007
    Posts
    7,129
    Thanks G/R
    1/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Either your sql database is outofdate or the SQL is.
    If you need me you have my skype, if you don't have my skype then you don't need me.

  3. #3
    pewor's Avatar Member
    Reputation
    1
    Join Date
    May 2007
    Posts
    88
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    ok thx rep+

  4. #4
    j9sjam3's Avatar Member
    Reputation
    14
    Join Date
    Mar 2007
    Posts
    190
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Get latest SQL from ABD.
    That should work
    <--- please click.

    *working on a decent siggy*

Similar Threads

  1. [HELP] Adding text to a specific column in a ListView
    By FuryExploiting in forum Programming
    Replies: 1
    Last Post: 09-17-2012, 01:24 AM
  2. Help! wrong number of columns?
    By Sawst in forum WoW ME Questions and Requests
    Replies: 1
    Last Post: 09-23-2009, 03:40 AM
  3. Help WoW Fish-Bot
    By Eliteplague in forum World of Warcraft General
    Replies: 1
    Last Post: 05-07-2006, 08:36 PM
  4. Hit points and talent points? Please help
    By hankusdankus in forum World of Warcraft General
    Replies: 6
    Last Post: 05-04-2006, 02:00 PM
  5. bot help
    By xwhitedeathx in forum World of Warcraft General
    Replies: 3
    Last Post: 05-01-2006, 03:50 AM
All times are GMT -5. The time now is 05:29 AM. Powered by vBulletin® Version 4.2.3
Copyright © 2024 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search