Results 1 to 4 of 4
  1. #1
    Master Sergeant pewor's Avatar
    Reputation
    1
    Join Date
    May 2007
    Location
    skåne land ^^
    Posts
    88
    Thanks (Given)
    0
    Thanks (Received)
    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
    Location
    OwnedCore
    Posts
    7,130
    Thanks (Given)
    0
    Thanks (Received)
    1
    CoreCoins
    49129
    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
    Location
    skåne land ^^
    Posts
    88
    Thanks (Given)
    0
    Thanks (Received)
    0
    CoreCoins
    0
    Trade Feedback
    0 (0%)
    ok thx rep+

  4. #4
    Knight j9sjam3's Avatar
    Reputation
    14
    Join Date
    Mar 2007
    Location
    Wales, UK
    Posts
    190
    Thanks (Given)
    0
    Thanks (Received)
    0
    CoreCoins
    0
    Trade Feedback
    0 (0%)
    Get latest SQL from ABD.
    That should work
    <--- please click.

    *working on a decent siggy*

 

 
All times are GMT -5. The time now is 03:12 PM. Powered by vBulletin® Version 4.2.2
Copyright © 2016 vBulletin Solutions, Inc. All rights reserved. Digital Point modules: Sphinx-based search