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

    Positive
    0
    Negative
    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
    ٩(-̮̮̃-̃)۶ Retired

    CoreCoins User


    Reputation
    1181
    Join Date
    Feb 2007
    Location
    OwnedCore
    Posts
    7,187
    Blog Entries
    5
    CoreCoins
    85040

    Trade Feedbacks

    Positive
    0
    Negative
    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

    Positive
    0
    Negative
    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

    Positive
    0
    Negative
    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 05:29 AM. Powered by vBulletin® Version 4.2.0
Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.
Content Relevant URLs by vBSEO
vBulletin Optimisation by vB Optimise. Digital Point modules: Sphinx-based search

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193