Results 1 to 4 of 4
  1. #1
    Master Sergeant pewor's Avatar
    Reputation
    1
    Join Date
    May 2007
    Posts
    88
    Thanks G/R
    0/0
    CoreCoins
    0
    Trade Feedback
    0 (0%)

    [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');

  2. #2
    ★ Elder ★

    CoreCoins User 2dgreengiant's Avatar
    Reputation
    1185
    Join Date
    Feb 2007
    Posts
    7,129
    Thanks G/R
    0/1
    CoreCoins
    39177
    Trade Feedback
    0 (0%)
    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
    Master Sergeant pewor's Avatar
    Reputation
    1
    Join Date
    May 2007
    Posts
    88
    Thanks G/R
    0/0
    CoreCoins
    0
    Trade Feedback
    0 (0%)
    ok thx rep+

  4. #4
    Knight j9sjam3's Avatar
    Reputation
    14
    Join Date
    Mar 2007
    Posts
    190
    Thanks G/R
    0/0
    CoreCoins
    0
    Trade Feedback
    0 (0%)
    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 08:50 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2017 vBulletin Solutions, Inc. All rights reserved. Digital Point modules: Sphinx-based search