Results 1 to 4 of 4
  1. #1
    New User
    Reputation
    1
    Join Date
    May 2007
    Location
    skåne land ^^
    Posts
    88
    CoreCoins
    0

    Trade Feedbacks

    Status
    n/a
    Positive
    0 (0%)
    Negative
    0 (0%)

    [Help] column erro



    Donate to Remove Ads, Get ShoutBawx - Elite Forum Access
    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
    ★ Elders ★

    CoreCoins User


    Reputation
    1184
    Join Date
    Feb 2007
    Location
    OwnedCore
    Posts
    7,184
    Blog Entries
    5
    CoreCoins
    75450

    Trade Feedbacks

    Status
    n/a
    Positive
    0 (0%)
    Negative
    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
    New User
    Reputation
    1
    Join Date
    May 2007
    Location
    skåne land ^^
    Posts
    88
    CoreCoins
    0

    Trade Feedbacks

    Status
    n/a
    Positive
    0 (0%)
    Negative
    0 (0%)
    ok thx rep+

  4. #4
    Knight j9sjam3's Avatar
    Reputation
    14
    Join Date
    Mar 2007
    Location
    Wales, UK
    Posts
    190
    CoreCoins
    0

    Trade Feedbacks

    Status
    n/a
    Positive
    0 (0%)
    Negative
    0 (0%)
    Get latest SQL from ABD.
    That should work
    <--- please click.

    *working on a decent siggy*

 

 

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -4. The time now is 06:20 AM. Powered by vBulletin® Version 4.2.0
Copyright © 2014 vBulletin Solutions, Inc. All rights reserved. Resources saved on this page: MySQL 5.88%
vBulletin Optimisation provided by vB Optimise (Pro) - vBulletin Mods & Addons Copyright © 2014 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search