Follow us on
Follow us on Facebook Follow us on Twitter Watch us on YouTube


MMOCoin

Results 1 to 6 of 6
  1. #1
    Beginner

    Join Date
    Jan 2010
    Posts
    15
    Rep Power
    17
    Reputation
    4

    Question I need help With Executing Tele Npc Error.


    Register to remove this ad
    ive got an error when i execute MaNGOS Portal Master 4.0
    In A Other Repack did not had this Failure
    this come's up just know
    i think I have to change the Entry ID ore something I would like to hear what to do exactly?
    Code:
    Query:
    insert into `creature_template` (`entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `baseattacktime`, `family`, `type`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `mingold`, `maxgold`)
    values ('11135', '30583', '0', '0', '0', "The unborn", "Chaos", '1', '255', '1', '99999999', '99999999', '99999999', '99999999', '7', '7', '129', '2.50', '8.00', '1', '4', '1000', '99999999', '100', '0', '10', '99999', '99999', '99999', '99999', '99999', '99999', '999990000', '999990000')
    
    Error occured at:2010-07-28 14:43:41
    Line no.:2
    Error Code: 1062 - Duplicate entry '11135' for key 1
    
    Query:
    INSERT INTO `npc_vendor` (`entry`,`item`) VALUES 
    ('11135','51220'), 
    ('11135','51221'), 
    ('11135','51222'), 
    ('11135','51223'), 
    ('11135','51224'), 
    ('11135','49983'), 
    ('11135','50802'), 
    ('11135','51225'), 
    ('11135','51226'), 
    ('11135','51227'), 
    ('11135','51228'), 
    ('11135','51229'), 
    ('11135','51230'), 
    ('11135','51231'), 
    ('11135','51232'), 
    ('11135','51233'), 
    ('11135','51234'), 
    ('11135','51862'), 
    ('11135','51899'), 
    ('11135','51235'), 
    ('11135','51236'), 
    ('11135','51237'), 
    ('11135','51238'), 
    ('11135','51239'), 
    ('11135','51240'), 
    ('11135','51241'), 
    ('11135','51242'), 
    ('11135','51243'), 
    ('11135','51244'), 
    ('11135','51250'), 
    ('11135','51251'), 
    ('11135','51253'), 
    ('11135','51254'), 
    ('11135','51255'), 
    ('11135','51256'), 
    ('11135','51257'), 
    ('11135','51258'), 
    ('11135','51259'), 
    ('11135','51270'), 
    ('11135','51271'), 
    ('11135','51272'), 
    ('11135','51273'), 
    ('11135','51274'), 
    ('11135','51275'), 
    ('11135','51276'), 
    ('11135','51277'), 
    ('11135','51278'), 
    ('11135','51279'), 
    ('11135','51280'), 
    ('11135','51281'), 
    ('11135','51282'), 
    ('11135','51283'), 
    ('11135','51284'), 
    ('11135','51285'), 
    ('11135','51286'), 
    ('11135','51287'), 
    ('11135','51288'), 
    ('11135','51289'), 
    ('11135','51290'), 
    ('11135','51291'), 
    ('11135','51292'), 
    ('11135','51293'), 
    ('11135','51294'), 
    ('11135','51300'), 
    ('11135','51301'), 
    ('11135','51302'), 
    ('11135','51303'), 
    ('11135','51304'), 
    ('11135','51305'), 
    ('11135','51306'), 
    ('11135','51307'), 
    ('11135','51308'), 
    ('11135','51309'), 
    ('11135','50639'), 
    ('11135','51310'), 
    ('11135','51311'), 
    ('11135','51312'), 
    ('11135','51313'), 
    ('11135','51314'), 
    ('11135','50639')
    
    Error occured at:2010-07-28 14:44:04
    Line no.:81
    Error Code: 1062 - Duplicate entry '11135-50639-0' for key 1
    
    Query:
    INSERT INTO `npc_vendor` (`entry`,`item`) VALUES 
    ('11135','51220'), 
    ('11135','51221'), 
    ('11135','51222'), 
    ('11135','51223'), 
    ('11135','51224'), 
    ('11135','49983'), 
    ('11135','50802'), 
    ('11135','51225'), 
    ('11135','51226'), 
    ('11135','51227'), 
    ('11135','51228'), 
    ('11135','51229'), 
    ('11135','51230'), 
    ('11135','51231'), 
    ('11135','51232'), 
    ('11135','51233'), 
    ('11135','51234'), 
    ('11135','51862'), 
    ('11135','51899'), 
    ('11135','51235'), 
    ('11135','51236'), 
    ('11135','51237'), 
    ('11135','51238'), 
    ('11135','51239'), 
    ('11135','51240'), 
    ('11135','51241'), 
    ('11135','51242'), 
    ('11135','51243'), 
    ('11135','51244'), 
    ('11135','51250'), 
    ('11135','51251'), 
    ('11135','51253'), 
    ('11135','51254'), 
    ('11135','51255'), 
    ('11135','51256'), 
    ('11135','51257'), 
    ('11135','51258'), 
    ('11135','51259'), 
    ('11135','51270'), 
    ('11135','51271'), 
    ('11135','51272'), 
    ('11135','51273'), 
    ('11135','51274'), 
    ('11135','51275'), 
    ('11135','51276'), 
    ('11135','51277'), 
    ('11135','51278'), 
    ('11135','51279'), 
    ('11135','51280'), 
    ('11135','51281'), 
    ('11135','51282'), 
    ('11135','51283'), 
    ('11135','51284'), 
    ('11135','51285'), 
    ('11135','51286'), 
    ('11135','51287'), 
    ('11135','51288'), 
    ('11135','51289'), 
    ('11135','51290'), 
    ('11135','51291'), 
    ('11135','51292'), 
    ('11135','51293'), 
    ('11135','51294'), 
    ('11135','51300'), 
    ('11135','51301'), 
    ('11135','51302'), 
    ('11135','51303'), 
    ('11135','51304'), 
    ('11135','51305'), 
    ('11135','51306'), 
    ('11135','51307'), 
    ('11135','51308'), 
    ('11135','51309'), 
    ('11135','50639'), 
    ('11135','51310'), 
    ('11135','51311'), 
    ('11135','51312'), 
    ('11135','51313'), 
    ('11135','51314'), 
    ('11135','50639')
    
    Error occured at:2010-07-28 14:44:20
    Line no.:81
    Error Code: 1146 - Table 'characters.npc_vendor' doesn't exist
    
    Query:
    INSERT INTO `npc_vendor` (`entry`,`item`) VALUES 
    ('11135','51220'), 
    ('11135','51221'), 
    ('11135','51222'), 
    ('11135','51223'), 
    ('11135','51224'), 
    ('11135','49983'), 
    ('11135','50802'), 
    ('11135','51225'), 
    ('11135','51226'), 
    ('11135','51227'), 
    ('11135','51228'), 
    ('11135','51229'), 
    ('11135','51230'), 
    ('11135','51231'), 
    ('11135','51232'), 
    ('11135','51233'), 
    ('11135','51234'), 
    ('11135','51862'), 
    ('11135','51899'), 
    ('11135','51235'), 
    ('11135','51236'), 
    ('11135','51237'), 
    ('11135','51238'), 
    ('11135','51239'), 
    ('11135','51240'), 
    ('11135','51241'), 
    ('11135','51242'), 
    ('11135','51243'), 
    ('11135','51244'), 
    ('11135','51250'), 
    ('11135','51251'), 
    ('11135','51253'), 
    ('11135','51254'), 
    ('11135','51255'), 
    ('11135','51256'), 
    ('11135','51257'), 
    ('11135','51258'), 
    ('11135','51259'), 
    ('11135','51270'), 
    ('11135','51271'), 
    ('11135','51272'), 
    ('11135','51273'), 
    ('11135','51274'), 
    ('11135','51275'), 
    ('11135','51276'), 
    ('11135','51277'), 
    ('11135','51278'), 
    ('11135','51279'), 
    ('11135','51280'), 
    ('11135','51281'), 
    ('11135','51282'), 
    ('11135','51283'), 
    ('11135','51284'), 
    ('11135','51285'), 
    ('11135','51286'), 
    ('11135','51287'), 
    ('11135','51288'), 
    ('11135','51289'), 
    ('11135','51290'), 
    ('11135','51291'), 
    ('11135','51292'), 
    ('11135','51293'), 
    ('11135','51294'), 
    ('11135','51300'), 
    ('11135','51301'), 
    ('11135','51302'), 
    ('11135','51303'), 
    ('11135','51304'), 
    ('11135','51305'), 
    ('11135','51306'), 
    ('11135','51307'), 
    ('11135','51308'), 
    ('11135','51309'), 
    ('11135','50639'), 
    ('11135','51310'), 
    ('11135','51311'), 
    ('11135','51312'), 
    ('11135','51313'), 
    ('11135','51314'), 
    ('11135','50639')
    
    Error occured at:2010-07-28 14:44:30
    Line no.:81
    Error Code: 1146 - Table 'realmd.npc_vendor' doesn't exist
    
    Query:
    INSERT INTO `npc_vendor` (`entry`,`item`) VALUES 
    ('11135','51220'), 
    ('11135','51221'), 
    ('11135','51222'), 
    ('11135','51223'), 
    ('11135','51224'), 
    ('11135','49983'), 
    ('11135','50802'), 
    ('11135','51225'), 
    ('11135','51226'), 
    ('11135','51227'), 
    ('11135','51228'), 
    ('11135','51229'), 
    ('11135','51230'), 
    ('11135','51231'), 
    ('11135','51232'), 
    ('11135','51233'), 
    ('11135','51234'), 
    ('11135','51862'), 
    ('11135','51899'), 
    ('11135','51235'), 
    ('11135','51236'), 
    ('11135','51237'), 
    ('11135','51238'), 
    ('11135','51239'), 
    ('11135','51240'), 
    ('11135','51241'), 
    ('11135','51242'), 
    ('11135','51243'), 
    ('11135','51244'), 
    ('11135','51250'), 
    ('11135','51251'), 
    ('11135','51253'), 
    ('11135','51254'), 
    ('11135','51255'), 
    ('11135','51256'), 
    ('11135','51257'), 
    ('11135','51258'), 
    ('11135','51259'), 
    ('11135','51270'), 
    ('11135','51271'), 
    ('11135','51272'), 
    ('11135','51273'), 
    ('11135','51274'), 
    ('11135','51275'), 
    ('11135','51276'), 
    ('11135','51277'), 
    ('11135','51278'), 
    ('11135','51279'), 
    ('11135','51280'), 
    ('11135','51281'), 
    ('11135','51282'), 
    ('11135','51283'), 
    ('11135','51284'), 
    ('11135','51285'), 
    ('11135','51286'), 
    ('11135','51287'), 
    ('11135','51288'), 
    ('11135','51289'), 
    ('11135','51290'), 
    ('11135','51291'), 
    ('11135','51292'), 
    ('11135','51293'), 
    ('11135','51294'), 
    ('11135','51300'), 
    ('11135','51301'), 
    ('11135','51302'), 
    ('11135','51303'), 
    ('11135','51304'), 
    ('11135','51305'), 
    ('11135','51306'), 
    ('11135','51307'), 
    ('11135','51308'), 
    ('11135','51309'), 
    ('11135','50639'), 
    ('11135','51310'), 
    ('11135','51311'), 
    ('11135','51312'), 
    ('11135','51313'), 
    ('11135','51314'), 
    ('11135','50639')
    
    Error occured at:2010-07-28 14:51:45
    Line no.:81
    Error Code: 1062 - Duplicate entry '11135-51220-0' for key 1
    
    Query:
    INSERT INTO `npc_vendor` (`entry`,`item`) VALUES 
    ('11139','51220'), 
    ('11139','51221'), 
    ('11139','51222'), 
    ('11139','51223'), 
    ('11139','51224'), 
    ('11139','49983'), 
    ('11139','50802'), 
    ('11139','51225'), 
    ('11139','51226'), 
    ('11139','51227'), 
    ('11139','51228'), 
    ('11139','51229'), 
    ('11139','51230'), 
    ('11139','51231'), 
    ('11139','51232'), 
    ('11139','51233'), 
    ('11139','51234'), 
    ('11139','51862'), 
    ('11139','51899'), 
    ('11139','51235'), 
    ('11139','51236'), 
    ('11139','51237'), 
    ('11139','51238'), 
    ('11139','51239'), 
    ('11139','51240'), 
    ('11139','51241'), 
    ('11139','51242'), 
    ('11139','51243'), 
    ('11139','51244'), 
    ('11139','51250'), 
    ('11139','51251'), 
    ('11139','51253'), 
    ('11139','51254'), 
    ('11139','51255'), 
    ('11139','51256'), 
    ('11139','51257'), 
    ('11139','51258'), 
    ('11139','51259'), 
    ('11139','51270'), 
    ('11139','51271'), 
    ('11139','51272'), 
    ('11139','51273'), 
    ('11139','51274'), 
    ('11139','51275'), 
    ('11139','51276'), 
    ('11139','51277'), 
    ('11139','51278'), 
    ('11139','51279'), 
    ('11139','51280'), 
    ('11139','51281'), 
    ('11139','51282'), 
    ('11139','51283'), 
    ('11139','51284'), 
    ('11139','51285'), 
    ('11139','51286'), 
    ('11139','51287'), 
    ('11139','51288'), 
    ('11139','51289'), 
    ('11139','51290'), 
    ('11139','51291'), 
    ('11139','51292'), 
    ('11139','51293'), 
    ('11139','51294'), 
    ('11139','51300'), 
    ('11139','51301'), 
    ('11139','51302'), 
    ('11139','51303'), 
    ('11139','51304'), 
    ('11139','51305'), 
    ('11139','51306'), 
    ('11139','51307'), 
    ('11139','51308'), 
    ('11139','51309'), 
    ('11139','50639'), 
    ('11139','51310'), 
    ('11139','51311'), 
    ('11139','51312'), 
    ('11139','51313'), 
    ('11139','51314'), 
    ('11139','50639')
    
    Error occured at:2010-07-28 15:01:53
    Line no.:81
    Error Code: 1062 - Duplicate entry '11139-50639-0' for key 1
    
    Query:
    INSERT INTO `npc_vendor` (`entry`,`item`) VALUES 
    ('500000','51220'), 
    ('500000','51221'), 
    ('500000','51222'), 
    ('500000','51223'), 
    ('500000','51224'), 
    ('500000','49983'), 
    ('500000','50802'), 
    ('500000','51225'), 
    ('500000','51226'), 
    ('500000','51227'), 
    ('500000','51228'), 
    ('500000','51229'), 
    ('500000','51230'), 
    ('500000','51231'), 
    ('500000','51232'), 
    ('500000','51233'), 
    ('500000','51234'), 
    ('500000','51862'), 
    ('500000','51899'), 
    ('500000','51235'), 
    ('500000','51236'), 
    ('500000','51237'), 
    ('500000','51238'), 
    ('500000','51239'), 
    ('500000','51240'), 
    ('500000','51241'), 
    ('500000','51242'), 
    ('500000','51243'), 
    ('500000','51244'), 
    ('500000','51250'), 
    ('500000','51251'), 
    ('500000','51253'), 
    ('500000','51254'), 
    ('500000','51255'), 
    ('500000','51256'), 
    ('500000','51257'), 
    ('500000','51258'), 
    ('500000','51259'), 
    ('500000','51270'), 
    ('500000','51271'), 
    ('500000','51272'), 
    ('500000','51273'), 
    ('500000','51274'), 
    ('500000','51275'), 
    ('500000','51276'), 
    ('500000','51278'), 
    ('500000','51279'), 
    ('500000','51280'), 
    ('500000','51281'), 
    ('500000','51282'), 
    ('500000','51283'), 
    ('500000','51284'), 
    ('500000','51285'), 
    ('500000','51286'), 
    ('500000','51287'), 
    ('500000','51288'), 
    ('500000','51289'), 
    ('500000','51290'), 
    ('500000','51291'), 
    ('500000','51292'), 
    
    
    Error occured at:2010-07-28 15:06:23
    Line no.:62
    Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 61
    
    Query:
    INSERT INTO `npc_vendor` (`entry`,`item`) VALUES 
    ('11135','51220'), 
    ('11135','51221'), 
    ('11135','51222'), 
    ('11135','51223'), 
    ('11135','51224'), 
    ('11135','49983'), 
    ('11135','50802'), 
    ('11135','51225'), 
    ('11135','51226'), 
    ('11135','51227'), 
    ('11135','51228'), 
    ('11135','51229'), 
    ('11135','51230'), 
    ('11135','51231'), 
    ('11135','51232'), 
    ('11135','51233'), 
    ('11135','51234'), 
    ('11135','51862'), 
    ('11135','51899'), 
    ('11135','51235'), 
    ('11135','51236'), 
    ('11135','51237'), 
    ('11135','51238'), 
    ('11135','51239'), 
    ('11135','51240'), 
    ('11135','51241'), 
    ('11135','51242'), 
    ('11135','51243'), 
    ('11135','51244'), 
    ('11135','51250'), 
    ('11135','51251'), 
    ('11135','51253'), 
    ('11135','51254'), 
    ('11135','51255'), 
    ('11135','51256'), 
    ('11135','51257'), 
    ('11135','51258'), 
    ('11135','51259'), 
    ('11135','51270'), 
    ('11135','51271'), 
    ('11135','51272'), 
    ('11135','51273'), 
    ('11135','51274'), 
    ('11135','51275'), 
    ('11135','51276'), 
    ('11135','51277'), 
    ('11135','51278'), 
    ('11135','51279'), 
    ('11135','51280'), 
    ('11135','51281'), 
    ('11135','51282'), 
    ('11135','51283'), 
    ('11135','51284'), 
    ('11135','51285'), 
    ('11135','51286'), 
    ('11135','51287'), 
    ('11135','51288'), 
    ('11135','51289'), 
    ('11135','51290'), 
    ('11135','51291'), 
    ('11135','51292'), 
    ('11135','51293'), 
    ('11135','51294'), 
    ('11135','51300'), 
    ('11135','51301'), 
    ('11135','51302'), 
    ('11135','51303'), 
    ('11135','51304'), 
    ('11135','51305'), 
    ('11135','51306'), 
    ('11135','51307'), 
    ('11135','51308'), 
    ('11135','51309'), 
    ('11135','50639'), 
    ('11135','51310'), 
    ('11135','51311'), 
    ('11135','51312'), 
    ('11135','51313'), 
    ('11135','51314'), 
    ('11135','50639'),
    
    
    Error occured at:2010-07-28 15:08:26
    Line no.:82
    Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 81
    
    Query:
    INSERT INTO `npc_vendor` (`entry`,`item`) VALUES 
    ('11135','51220'), 
    ('11135','51221'), 
    ('11135','51222'), 
    ('11135','51223'), 
    ('11135','51224'), 
    ('11135','49983'), 
    ('11135','50802'), 
    ('11135','51225'), 
    ('11135','51226'), 
    ('11135','51227'), 
    ('11135','51228'), 
    ('11135','51229'), 
    ('11135','51230'), 
    ('11135','51231'), 
    ('11135','51232'), 
    ('11135','51233'), 
    ('11135','51234'), 
    ('11135','51862'), 
    ('11135','51899'), 
    ('11135','51235'), 
    ('11135','51236'), 
    ('11135','51237'), 
    ('11135','51238'), 
    ('11135','51239'), 
    ('11135','51240'), 
    ('11135','51241'), 
    ('11135','51242'), 
    ('11135','51243'), 
    ('11135','51244'), 
    ('11135','51250'), 
    ('11135','51251'), 
    ('11135','51253'), 
    ('11135','51254'), 
    ('11135','51255'), 
    ('11135','51256'), 
    ('11135','51257'), 
    ('11135','51258'), 
    ('11135','51259'), 
    ('11135','51270'), 
    ('11135','51271'), 
    ('11135','51272'), 
    ('11135','51273'), 
    ('11135','51274'), 
    ('11135','51275'), 
    ('11135','51276'), 
    ('11135','51277'), 
    ('11135','51278'), 
    ('11135','51279'), 
    ('11135','51280'), 
    ('11135','51281'), 
    ('11135','51282'), 
    ('11135','51283'), 
    ('11135','51284'), 
    ('11135','51285'), 
    ('11135','51286'), 
    ('11135','51287'), 
    ('11135','51288'), 
    ('11135','51289'), 
    ('11135','51290'), 
    ('11135','51291'), 
    ('11135','51292'), 
    ('11135','51293'), 
    ('11135','51294'), 
    ('11135','51300'), 
    ('11135','51301'), 
    ('11135','51302'), 
    ('11135','51303'), 
    ('11135','51304'), 
    ('11135','51305'), 
    ('11135','51306'), 
    ('11135','51307'), 
    ('11135','51308'), 
    ('11135','51309'), 
    ('11135','50639'), 
    ('11135','51310'), 
    ('11135','51311'), 
    ('11135','51312'), 
    ('11135','51313'), 
    ('11135','51314'), 
    ('11135','50639'),
    
    
    Error occured at:2010-07-28 15:08:28
    Line no.:82
    Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 81
    
    Query:
    INSERT INTO `npc_vendor` (`entry`,`item`) VALUES 
    ('59998','51220'), 
    ('59998','51221'), 
    ('59998','51222'), 
    ('59998','51223'), 
    ('59998','51224'), 
    ('59998','49983'), 
    ('59998','50808'), 
    ('59998','51225'), 
    ('59998','51226'), 
    ('59998','51227'), 
    ('59998','51228'), 
    ('59998','51229'), 
    ('59998','51230'), 
    ('59998','51231'), 
    ('59998','51232'), 
    ('59998','51233'), 
    ('59998','51234'), 
    ('59998','51862'), 
    ('59998','51899'), 
    ('59998','51235'), 
    ('59998','51236'), 
    ('59998','51237'), 
    ('59998','51238'), 
    ('59998','51239'), 
    ('59998','51240'), 
    ('59998','51241'), 
    ('59998','51242'), 
    ('59998','51243'), 
    ('59998','51244'), 
    ('59998','51250'), 
    ('59998','51251'), 
    ('59998','51253'), 
    ('59998','51254'), 
    ('59998','51255'), 
    ('59998','51256'), 
    ('59998','51257'), 
    ('59998','51258'), 
    ('59998','51259'), 
    ('59998','51270'), 
    ('59998','51271'), 
    ('59998','51272'), 
    ('59998','51273'), 
    ('59998','51274'), 
    ('59998','51275'), 
    ('59998','51276'), 
    ('59998','51277'), 
    ('59998','51278'), 
    ('59998','51279'), 
    ('59998','51280'), 
    ('59998','51281'), 
    ('59998','51282'), 
    ('59998','51283'), 
    ('59998','51284'), 
    ('59998','51285'), 
    ('59998','51286'), 
    ('59998','51287'), 
    ('59998','51288'), 
    ('59998','51289'), 
    ('59998','51290'), 
    ('59998','51291'), 
    ('59998','51292'), 
    ('59998','51293'), 
    ('59998','51294'), 
    ('59998','51295'), 
    ('59998','51296'), 
    ('59998','51297'), 
    ('59998','51298'), 
    ('59998','51299'), 
    ('59998','51300'), 
    ('59998','51301'), 
    ('59998','51302'), 
    ('59998','51303'), 
    ('59998','51304'), 
    ('59998','51305'), 
    ('59998','51306'), 
    ('59998','51307'), 
    ('59998','51308'), 
    ('59998','51309'), 
    ('59998','50639'), 
    ('59998','51310'), 
    ('59998','51311'), 
    ('59998','51312'), 
    ('59998','51313'), 
    ('59998','51314'), 
    ('59998','50639')
    
    Error occured at:2010-07-29 03:13:11
    Line no.:86
    Error Code: 1062 - Duplicate entry '59998-50639-0' for key 1
    
    Query:
    INSERT INTO `npc_vendor` (`entry`,`item`) VALUES 
    ('59998','51220'), 
    ('59998','51221'), 
    ('59998','51222'), 
    ('59998','51223'), 
    ('59998','51224'), 
    ('59998','49983'), 
    ('59998','50808'), 
    ('59998','51225'), 
    ('59998','51226'), 
    ('59998','51227'), 
    ('59998','51228'), 
    ('59998','51229'), 
    ('59998','51230'), 
    ('59998','51231'), 
    ('59998','51232'), 
    ('59998','51233'), 
    ('59998','51234'), 
    ('59998','51862'), 
    ('59998','51899'), 
    ('59998','51235'), 
    ('59998','51236'), 
    ('59998','51237'), 
    ('59998','51238'), 
    ('59998','51239'), 
    ('59998','51240'), 
    ('59998','51241'), 
    ('59998','51242'), 
    ('59998','51243'), 
    ('59998','51244'), 
    ('59998','51250'), 
    ('59998','51251'), 
    ('59998','51253'), 
    ('59998','51254'), 
    ('59998','51255'), 
    ('59998','51256'), 
    ('59998','51257'), 
    ('59998','51258'), 
    ('59998','51259'), 
    ('59998','51270'), 
    ('59998','51271'), 
    ('59998','51272'), 
    ('59998','51273'), 
    ('59998','51274'), 
    ('59998','51275'), 
    ('59998','51276'), 
    ('59998','51277'), 
    ('59998','51278'), 
    ('59998','51279'), 
    ('59998','51280'), 
    ('59998','51281'), 
    ('59998','51282'), 
    ('59998','51283'), 
    ('59998','51284'), 
    ('59998','51285'), 
    ('59998','51286'), 
    ('59998','51287'), 
    ('59998','51288'), 
    ('59998','51289'), 
    ('59998','51290'), 
    ('59998','51291'), 
    ('59998','51292'), 
    ('59998','51293'), 
    ('59998','51294'), 
    ('59998','51295'), 
    ('59998','51296'), 
    ('59998','51297'), 
    ('59998','51298'), 
    ('59998','51299'), 
    ('59998','51300'), 
    ('59998','51301'), 
    ('59998','51302'), 
    ('59998','51303'), 
    ('59998','51304'), 
    ('59998','51305'), 
    ('59998','51306'), 
    ('59998','51307'), 
    ('59998','51308'), 
    ('59998','51309'), 
    ('59998','50639'), 
    ('59998','51310'), 
    ('59998','51311'), 
    ('59998','51312'), 
    ('59998','51313'), 
    ('59998','51314'), 
    ('59998','50639')
    
    Error occured at:2010-07-29 03:13:17
    Line no.:86
    Error Code: 1062 - Duplicate entry '59998-51220-0' for key 1
    
    Query:
    INSERT INTO `npc_vendor` (`entry`,`item`) VALUES 
    ('59995','50630'), 
    ('59995','50627'), 
    ('59995','50628'), 
    ('59995','50620'), 
    ('59995','50622'), 
    ('59995','50627'), 
    ('59995','50628'), 
    ('59995','50620'), 
    ('59995','50622'), 
    ('59995','50609'), 
    ('59995','50404'), 
    ('59995','50604'), 
    ('59995','50400'), 
    ('59995','50366'), 
    ('59995','50364'), 
    ('59995','50349'), 
    ('59995','50348'), 
    ('59995','47553'), 
    ('59995','47552'), 
    ('59995','47554'), 
    ('59995','47551'), 
    ('59995','47550'), 
    ('59995','47549'), 
    ('59995','47548'), 
    ('59995','47547'), 
    ('59995','47546'), 
    ('59995','47545')
    
    Error occured at:2010-07-29 03:50:44
    Line no.:28
    Error Code: 1062 - Duplicate entry '59995-50627-0' for key 1
    
    Query:
    INSERT INTO `npc_vendor` (`entry`,`item`) VALUES 
    ('59995','50630'), 
    ('59995','50627'), 
    ('59995','50628'), 
    ('59995','50620'), 
    ('59995','50622'), 
    ('59995','50627'), 
    ('59995','50628'), 
    ('59995','50620'), 
    ('59995','50622'), 
    ('59995','50609'), 
    ('59995','50404'), 
    ('59995','50604'), 
    ('59995','50400'), 
    ('59995','50366'), 
    ('59995','50364'), 
    ('59995','50349'), 
    ('59995','50348'), 
    ('59995','47553'), 
    ('59995','47552'), 
    ('59995','47554'), 
    ('59995','47551'), 
    ('59995','47550'), 
    ('59995','47549'), 
    ('59995','47548'), 
    ('59995','47547'), 
    ('59995','47546'), 
    ('59995','47545')
    
    Error occured at:2010-07-29 03:50:55
    Line no.:28
    Error Code: 1062 - Duplicate entry '59995-50630-0' for key 1
    
    Query:
    INSERT INTO `creature_involvedrelation` (`id`, `quest`) 
    VALUES ('50004', '50003')
    
    Error occured at:2010-07-30 00:27:34
    Line no.:4
    Error Code: 1062 - Duplicate entry '50004-50003' for key 1
    
    Query:
    INSERT INTO `creature_involvedrelation` (`id`, `quest`) 
    VALUES ('50004', '50003')
    
    Error occured at:2010-07-30 00:28:23
    Line no.:4
    Error Code: 1062 - Duplicate entry '50004-50003' for key 1
    
    Query:
    INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `SrcItemId`, `SrcItemCount`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewOrReqMoney`, `PrevQuestId`, `SuggestedPlayers`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewSpellCast`, `EndText`, `SkillOrClass`, `RewMoneyMaxLevel`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `CharTitleId`, `RequiredSkillValue`) 
    VALUES ('50003', '21', '1', '1', '0', '0', '0', '0', 'Welcome To ChaosCraft!', 'Welcome To ChaosCraft!$BWell If you are new You need to know that you need to Respect The Owner of This Server: Ghostrevan Respect The GM\'s Joshua , Mike. Be fare have fun and play nice', 'Get To Stormwind / Orgrimmar$BFor the mall\'s!$Bhave fun playing$BBy Ghostrevan', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100000000', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '166644', '', '', '', '', '0', '0')
    
    Error occured at:2010-07-30 00:28:29
    Line no.:2
    Error Code: 1062 - Duplicate entry '50003' for key 1
    
    Query:
    INSERT INTO `creature_involvedrelation` (`id`, `quest`) 
    VALUES ('50004', '50003')
    
    Error occured at:2010-07-30 00:29:11
    Line no.:4
    Error Code: 1062 - Duplicate entry '50004-50003' for key 1
    
    Query:
    INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `SrcItemId`, `SrcItemCount`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewOrReqMoney`, `PrevQuestId`, `SuggestedPlayers`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewSpellCast`, `EndText`, `SkillOrClass`, `RewMoneyMaxLevel`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `CharTitleId`, `RequiredSkillValue`) 
    VALUES ('50003', '21', '1', '1', '0', '0', '0', '0', 'Welcome To ChaosCraft!', 'Welcome To ChaosCraft!$BWell If you are new You need to know that you need to Respect The Owner of This Server: Ghostrevan Respect The GM\'s Joshua , Mike. Be fare have fun and play nice', 'Get To Stormwind / Orgrimmar$BFor the mall\'s!$Bhave fun playing$BBy Ghostrevan', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100000000', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '166644', '', '', '', '', '0', '0')
    
    Error occured at:2010-07-30 00:32:10
    Line no.:2
    Error Code: 1062 - Duplicate entry '50003' for key 1
    
    Query:
    INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `SrcItemId`, `SrcItemCount`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewOrReqMoney`, `PrevQuestId`, `SuggestedPlayers`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewSpellCast`, `EndText`, `SkillOrClass`, `RewMoneyMaxLevel`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `CharTitleId`, `RequiredSkillValue`) 
    VALUES ('50003', '21', '1', '1', '0', '0', '0', '0', 'Welcome To ChaosCraft!', 'Welcome To ChaosCraft!$BWell If you are new You need to know that you need to Respect The Owner of This Server: Ghostrevan Respect The GM\'s Joshua , Mike. Be fare have fun and play nice', 'Get To Stormwind / Orgrimmar$BFor the mall\'s!$Bhave fun playing$BBy Ghostrevan', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100000000', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '166644', '', '', '', '', '0', '0')
    
    Error occured at:2010-07-30 00:32:34
    Line no.:2
    Error Code: 1062 - Duplicate entry '50003' for key 1
    
    Query:
    INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `SrcItemId`, `SrcItemCount`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewOrReqMoney`, `PrevQuestId`, `SuggestedPlayers`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewSpellCast`, `EndText`, `SkillOrClass`, `RewMoneyMaxLevel`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `CharTitleId`, `RequiredSkillValue`) 
    VALUES ('50003', '21', '1', '1', '0', '0', '0', '0', 'Welcome To ChaosCraft!', 'Welcome To ChaosCraft!$BWell If you are new You need to know that you need to Respect The Owner of This Server: Ghostrevan Respect The GM\'s Joshua , Mike. Be fare have fun and play nice', 'Get To Stormwind / Orgrimmar$BFor the mall\'s!$Bhave fun playing$BBy Ghostrevan', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100000000', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '166644', '', '', '', '', '0', '0')
    
    Error occured at:2010-07-30 00:32:38
    Line no.:2
    Error Code: 1062 - Duplicate entry '50003' for key 1
    
    Query:
    INSERT INTO `creature_involvedrelation` (`id`, `quest`) 
    VALUES ('50004', '50003')
    
    Error occured at:2010-07-30 00:36:05
    Line no.:4
    Error Code: 1062 - Duplicate entry '50004-50003' for key 1
    
    Query:
    UPDATE `quest_template` SET `XPCOLUMNNAMEHERE` = 1337 WHERE `entry` = QUEST ID
    
    Error occured at:2010-07-31 03:25:25
    Line no.:1
    Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ID' at line 1
    
    Query:
    INSERT INTO `creature_template` VALUES (799997, 0, 0, 0, 0, 0, 30583, 0, 30583, 0, 'Arena Season 5_Savage', 'Server Vendors', NULL, 0, 81, 81, 10000, 10000, 10000, 10000, 10029, 35, 35, 4224, 1.15, 1.14286, 1, 1, 349, 523, 0, 131, 3.2, 1600, 1600, 0, 0, 0, 0, 0, 0, 0, 0, 279, 418, 105, 7, 138936390, 0, 0, 0, 999, 999, 999, 999, 999, 999, 0, 0, 0, 0, 0, 1500, 1700, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, '')
    
    Error occured at:2010-08-04 22:41:59
    Line no.:6
    Error Code: 1136 - Column count doesn't match value count at row 1
    
    Query:
    INSERT INTO `creature_template` VALUES (799997, 0, 0, 0, 0, 0, 30583, 0, 30583, 0, 'Arena Season 5_Savage', 'Server Vendors', NULL, 0, 81, 81, 10000, 10000, 10000, 10000, 10029, 35, 35, 4224, 1.15, 1.14286, 1, 1, 349, 523, 0, 131, 3.2, 1600, 1600, 0, 0, 0, 0, 0, 0, 0, 0, 279, 418, 105, 7, 138936390, 0, 0, 0, 999, 999, 999, 999, 999, 999, 0, 0, 0, 0, 0, 1500, 1700, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, '')
    
    Error occured at:2010-08-04 22:42:23
    Line no.:6
    Error Code: 1136 - Column count doesn't match value count at row 1
    
    Query:
    INSERT INTO `creature_template` VALUES (799997, 0, 0, 0, 0, 0, 30583, 0, 30583, 0, 'Arena Season 5_Savage', 'Server Vendors', NULL, 0, 81, 81, 10000, 10000, 10000, 10000, 10029, 35, 35, 4224, 1.15, 1.14286, 1, 1, 349, 523, 0, 131, 3.2, 1600, 1600, 0, 0, 0, 0, 0, 0, 0, 0, 279, 418, 105, 7, 138936390, 0, 0, 0, 999, 999, 999, 999, 999, 999, 0, 0, 0, 0, 0, 1500, 1700, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, '')
    
    Error occured at:2010-08-04 22:43:20
    Line no.:6
    Error Code: 1136 - Column count doesn't match value count at row 1
    
    Query:
    INSERT INTO `creature_template` VALUES (799997, 0, 0, 0, 0, 0, 30583, 0, 30583, 0, 'Arena Season 5_Savage', 'Server Vendors', NULL, 0, 81, 81, 10000, 10000, 10000, 10000, 10029, 35, 35, 4224, 1.15, 1.14286, 1, 1, 349, 523, 0, 131, 3.2, 1600, 1600, 0, 0, 0, 0, 0, 0, 0, 0, 279, 418, 105, 7, 138936390, 0, 0, 0, 999, 999, 999, 999, 999, 999, 0, 0, 0, 0, 0, 1500, 1700, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, '')
    
    Error occured at:2010-08-04 22:43:25
    Line no.:6
    Error Code: 1136 - Column count doesn't match value count at row 1
    
    Query:
    INSERT INTO `creature_template` VALUES (799997, 0, 0, 0, 0, 0, 23777, 0, 23777, 0, 'Arena Season 5_Savage', 'Server Vendors', NULL, 0, 81, 81, 10000, 10000, 10000, 10000, 10029, 35, 35, 4224, 1.15, 1.14286, 1, 1, 349, 523, 0, 131, 3.2, 1600, 1600, 0, 0, 0, 0, 0, 0, 0, 0, 279, 418, 105, 7, 138936390, 0, 0, 0, 999, 999, 999, 999, 999, 999, 0, 0, 0, 0, 0, 1500, 1700, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, '')
    
    Error occured at:2010-08-04 22:46:56
    Line no.:6
    Error Code: 1136 - Column count doesn't match value count at row 1
    
    Query:
    DELETE FROM conditions WHERE SourceTypeOrReferenceId=15 AND SourceGroup>=@GOPTION AND SourceGroup<=@GOPTION+6 AND ConditionTypeOrReference=6 AND (ConditionValue1=469 OR ConditionValue1=67)
    
    Error occured at:2010-08-04 22:54:35
    Line no.:24
    Error Code: 1146 - Table 'mangos.conditions' doesn't exist
    
    Query:
    DELETE FROM conditions WHERE SourceTypeOrReferenceId=15 AND SourceGroup>=@GOPTION AND SourceGroup<=@GOPTION+6 AND ConditionTypeOrReference=6 AND (ConditionValue1=469 OR ConditionValue1=67)
    
    Error occured at:2010-08-04 22:54:40
    Line no.:24
    Error Code: 1146 - Table 'mangos.conditions' doesn't exist
    
    Query:
    INSERT INTO creature_template (entry,modelid_1,modelid_3,name,IconName,gossip_menu_id,minlevel,maxlevel,minhealth,maxhealth,minmana,maxmana,armor,faction_A,faction_H,npcflag,speed_walk,speed_run,scale,rank,dmg_multiplier,unit_flags,type,type_flags,InhabitType,unk16,unk17,RegenHealth,flags_extra) 
    VALUES (@TELENPC,21572,21572,'Portal Master','Directions',@GMENU,71,71,13700,13700,6540,6540,5700,35,35,3,1,1.14286,1.25,1,1,2,7,138936390,3,1,1,1,2)
    
    Error occured at:2010-08-05 04:14:20
    Line no.:29
    Error Code: 1054 - Unknown column 'modelid_1' in 'field list'
    
    Query:
    INSERT INTO creature_template (entry, difficulty_entry_1, difficulty_entry_2, difficulty_entry_3, KillCredit1, KillCredit2, modelid_1, modelid_2, modelid_3, modelid_4, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed_walk, speed_run, scale, rank, mindmg, maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime, rangeattacktime, unit_class, unit_flags, dynamicflags, family, trainer_type, trainer_spell, trainer_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, type, type_flags, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, PetSpellDataId, mingold, maxgold, AIName, MovementType, InhabitType, unk16, unk17, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, equipment_id, mechanic_immune_mask, flags_extra, ScriptName) VALUES 
    (@JUKENPC, 0, 0, 0, 0, 0, 21661, 0, 21661, 0, @NPCNAME, NULL, 'interact', @GOPTION, 71, 71, 13700, 13700, 6540, 6540, 5700, 35, 35, 3, 1, 1.14286, 0.5, 1, 0, 0, 0, 0, 1, 0, 0, 1, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 138936390, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 2, '')
    
    Error occured at:2010-08-05 04:33:02
    Line no.:30
    Error Code: 1054 - Unknown column 'modelid_1' in 'field list'
    
    Query:
    INSERT INTO creature_template (entry,modelid_1,modelid_3,name,IconName,gossip_menu_id,minlevel,maxlevel,minhealth,maxhealth,minmana,maxmana,armor,faction_A,faction_H,npcflag,speed_walk,speed_run,scale,rank,dmg_multiplier,unit_flags,type,type_flags,InhabitType,unk16,unk17,RegenHealth,flags_extra) 
    VALUES (@TELENPC,21572,21572,'Portal Master','Directions',@GMENU,71,71,13700,13700,6540,6540,5700,35,35,3,1,1.14286,1.25,1,1,2,7,138936390,3,1,1,1,2)
    
    Error occured at:2010-08-05 04:34:15
    Line no.:29
    Error Code: 1054 - Unknown column 'modelid_1' in 'field list'
    
    Query:
    INSERT INTO creature_template (entry,modelid_1,modelid_3,name,IconName,gossip_menu_id,minlevel,maxlevel,minhealth,maxhealth,minmana,maxmana,armor,faction_A,faction_H,npcflag,speed_walk,speed_run,scale,rank,dmg_multiplier,unit_flags,type,type_flags,InhabitType,unk16,unk17,RegenHealth,flags_extra) 
    VALUES (@TELENPC,21572,21572,'Portal Master','Directions',@GMENU,71,71,13700,13700,6540,6540,5700,35,35,3,1,1.14286,1.25,1,1,2,7,138936390,3,1,1,1,2)
    
    Error occured at:2010-08-05 04:38:00
    Line no.:29
    Error Code: 1054 - Unknown column 'modelid_1' in 'field list'
    
    Query:
    INSERT INTO `creature_template` VALUES ('90000', '0', '0', '0', '0', '0', '28186', '0', '28186', '0', 'Shadow Teleporter', 'Shadow-Legion', null, '0', '80', '80', '25000', '25000', '0', '0', '10000', '35', '35', '1', '1', '1', '3.5', '1', '2750', '2750', '0', '250', '1', '1000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '3', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', 'custom_npc_teleportmaster')
    
    Error occured at:2010-08-05 04:44:16
    Line no.:1
    Error Code: 1136 - Column count doesn't match value count at row 1
    
    Query:
    INSERT INTO `creature_template` VALUES ('90000', '0', '0', '0', '0', '0', '28186', '0', '28186', '0', 'Shadow Teleporter', 'Shadow-Legion', null, '0', '80', '80', '25000', '25000', '0', '0', '10000', '35', '35', '1', '1', '1', '3.5', '1', '2750', '2750', '0', '250', '1', '1000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '3', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', 'custom_npc_teleportmaster')
    
    Error occured at:2010-08-05 04:44:31
    Line no.:1
    Error Code: 1136 - Column count doesn't match value count at row 1
    
    Query:
    INSERT INTO creature_template VALUES
    (666000, 0, 0, 0, 0, 0, 28191, 0, 0, 0, "Inner Demon", "Teleport NPC", "", 0, 80, 80, 2, 35, 35, 1, 1, 1.14286, 1, 0, 10000, 20000, 0, 6666, 1, 2000, 0, 8, 33536, 8, 0, 0, 0, 0, 0, 271, 403, 45, 7, 4096, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 2, 3, 5, 5, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 925, 0, 2, "HC_TeleportNPC", 666)
    
    Error occured at:2010-08-05 05:02:02
    Line no.:3
    Error Code: 1136 - Column count doesn't match value count at row 1
    
    Query:
    INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (999222, 0, 0, 0, 0, 0, 23574, 0, 0, 0, 'SkyNet', '', NULL, 0, 80, 80, 1000, 1000, 1000, 1000, 1000, 35, 35, 3, 2.5, 8, 3, 0, 123, 1799, 0, 0, 1, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, '')
    
    Error occured at:2010-08-05 11:22:09
    Line no.:1
    Error Code: 1062 - Duplicate entry '999222' for key 1
    
    Query:
    INSERT INTO `creature_template` VALUES (799997, 0, 0, 0, 0, 0, 23777, 0, 23777, 0, 'Arena Season 5_Savage', 'Server Vendors', NULL, 0, 81, 81, 10000, 10000, 10000, 10000, 10029, 35, 35, 4224, 1.15, 1.14286, 1, 1, 349, 523, 0, 131, 3.2, 1600, 1600, 0, 0, 0, 0, 0, 0, 0, 0, 279, 418, 105, 7, 138936390, 0, 0, 0, 999, 999, 999, 999, 999, 999, 0, 0, 0, 0, 0, 1500, 1700, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, '')
    
    Error occured at:2010-08-05 21:07:01
    Line no.:6
    Error Code: 1136 - Column count doesn't match value count at row 1
    
    Query:
    INSERT INTO creature_template (entry,modelid_1,modelid_3,name,IconName,gossip_menu_id,minlevel,maxlevel,minhealth,maxhealth,minmana,maxmana,armor,faction_A,faction_H,npcflag,speed_walk,speed_run,scale,rank,dmg_multiplier,unit_flags,type,type_flags,InhabitType,unk16,unk17,RegenHealth,flags_extra) 
    VALUES (@TELENPC,21572,21572,'Portal Master','Directions',@GMENU,71,71,13700,13700,6540,6540,5700,35,35,3,1,1.14286,1.25,1,1,2,7,138936390,3,1,1,1,2)
    
    Error occured at:2010-08-05 21:27:18
    Line no.:29
    Error Code: 1054 - Unknown column 'modelid_1' in 'field list'

  2. #2
    Banned

    Join Date
    Aug 2008
    Location
    Scotland
    Posts
    652
    Rep Power
    0
    Reputation
    103
    Line no.:2
    Error Code: 1062 - Duplicate entry '11135' for key 1

    Look at Line no. 2 - which is 11135.
    Look at key 1 - which is "entry"

    Simple way to fix it is by changing 11135 to say 11136.
    Should work

  3. #3
    Elite Member
    Dimman's Avatar
    Join Date
    Apr 2009
    Posts
    1,091
    Rep Power
    22
    Reputation
    319
    Error Code: 1062 - Duplicate entry '11135-50639-0' for key 1

    Remove that line "('11135','50639')," its already in the table (already in the vendor)

    Regards, Dimman
    No touching please.

  4. #4
    Banned

    Join Date
    Aug 2008
    Location
    Scotland
    Posts
    652
    Rep Power
    0
    Reputation
    103
    Fatcow, you realise it would be easier for him to just change it so he has it, rather then removing it?

  5. #5
    Beginner

    Join Date
    Jan 2010
    Posts
    15
    Rep Power
    17
    Reputation
    4
    testing know thx.

  6. #6
    Elite Member
    Dimman's Avatar
    Join Date
    Apr 2009
    Posts
    1,091
    Rep Power
    22
    Reputation
    319

    Register to remove this ad
    Code:
    REPLACE INTO `npc_vendor` (`entry`,`item`) VALUES 
    ('11135','51220'), 
    ('11135','51221'), 
    ('11135','51222'), 
    ('11135','51223'), 
    ('11135','51224'), 
    ('11135','49983'), 
    ('11135','50802'), 
    ('11135','51225'), 
    ('11135','51226'), 
    ('11135','51227'), 
    ('11135','51228'), 
    ('11135','51229'), 
    ('11135','51230'), 
    ('11135','51231'), 
    ('11135','51232'), 
    ('11135','51233'), 
    ('11135','51234'), 
    ('11135','51862'), 
    ('11135','51899'), 
    ('11135','51235'), 
    ('11135','51236'), 
    ('11135','51237'), 
    ('11135','51238'), 
    ('11135','51239'), 
    ('11135','51240'), 
    ('11135','51241'), 
    ('11135','51242'), 
    ('11135','51243'), 
    ('11135','51244'), 
    ('11135','51250'), 
    ('11135','51251'), 
    ('11135','51253'), 
    ('11135','51254'), 
    ('11135','51255'), 
    ('11135','51256'), 
    ('11135','51257'), 
    ('11135','51258'), 
    ('11135','51259'), 
    ('11135','51270'), 
    ('11135','51271'), 
    ('11135','51272'), 
    ('11135','51273'), 
    ('11135','51274'), 
    ('11135','51275'), 
    ('11135','51276'), 
    ('11135','51277'), 
    ('11135','51278'), 
    ('11135','51279'), 
    ('11135','51280'), 
    ('11135','51281'), 
    ('11135','51282'), 
    ('11135','51283'), 
    ('11135','51284'), 
    ('11135','51285'), 
    ('11135','51286'), 
    ('11135','51287'), 
    ('11135','51288'), 
    ('11135','51289'), 
    ('11135','51290'), 
    ('11135','51291'), 
    ('11135','51292'), 
    ('11135','51293'), 
    ('11135','51294'), 
    ('11135','51300'), 
    ('11135','51301'), 
    ('11135','51302'), 
    ('11135','51303'), 
    ('11135','51304'), 
    ('11135','51305'), 
    ('11135','51306'), 
    ('11135','51307'), 
    ('11135','51308'), 
    ('11135','51309'), 
    ('11135','50639'), 
    ('11135','51310'), 
    ('11135','51311'), 
    ('11135','51312'), 
    ('11135','51313'), 
    ('11135','51314'), 
    ('11135','50639')
    
    
    Code:
    UPDATE `npc_vendor` (`entry`,`item`) VALUES 
    ('11135','51220'), 
    ('11135','51221'), 
    ('11135','51222'), 
    ('11135','51223'), 
    ('11135','51224'), 
    ('11135','49983'), 
    ('11135','50802'), 
    ('11135','51225'), 
    ('11135','51226'), 
    ('11135','51227'), 
    ('11135','51228'), 
    ('11135','51229'), 
    ('11135','51230'), 
    ('11135','51231'), 
    ('11135','51232'), 
    ('11135','51233'), 
    ('11135','51234'), 
    ('11135','51862'), 
    ('11135','51899'), 
    ('11135','51235'), 
    ('11135','51236'), 
    ('11135','51237'), 
    ('11135','51238'), 
    ('11135','51239'), 
    ('11135','51240'), 
    ('11135','51241'), 
    ('11135','51242'), 
    ('11135','51243'), 
    ('11135','51244'), 
    ('11135','51250'), 
    ('11135','51251'), 
    ('11135','51253'), 
    ('11135','51254'), 
    ('11135','51255'), 
    ('11135','51256'), 
    ('11135','51257'), 
    ('11135','51258'), 
    ('11135','51259'), 
    ('11135','51270'), 
    ('11135','51271'), 
    ('11135','51272'), 
    ('11135','51273'), 
    ('11135','51274'), 
    ('11135','51275'), 
    ('11135','51276'), 
    ('11135','51277'), 
    ('11135','51278'), 
    ('11135','51279'), 
    ('11135','51280'), 
    ('11135','51281'), 
    ('11135','51282'), 
    ('11135','51283'), 
    ('11135','51284'), 
    ('11135','51285'), 
    ('11135','51286'), 
    ('11135','51287'), 
    ('11135','51288'), 
    ('11135','51289'), 
    ('11135','51290'), 
    ('11135','51291'), 
    ('11135','51292'), 
    ('11135','51293'), 
    ('11135','51294'), 
    ('11135','51300'), 
    ('11135','51301'), 
    ('11135','51302'), 
    ('11135','51303'), 
    ('11135','51304'), 
    ('11135','51305'), 
    ('11135','51306'), 
    ('11135','51307'), 
    ('11135','51308'), 
    ('11135','51309'), 
    ('11135','50639'), 
    ('11135','51310'), 
    ('11135','51311'), 
    ('11135','51312'), 
    ('11135','51313'), 
    ('11135','51314'), 
    ('11135','50639')
    USe them if you get errors
    No touching please.

 

 

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 -5. The time now is 03:54 AM.
Powered by vBulletin® Copyright ©2000-2026, Jelsoft Enterprises Ltd.
vBulletin Licensed to: MMOPro.org
vBulletin Skin By: PurevB.com