PDA

View Full Version : I need help With Executing Tele Npc Error.



ghostrevan
05-08-10, 02:34 PM
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?

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_me nu_id,minlevel,maxlevel,minhealth,maxhealth,minman a,maxmana,armor,faction_A,faction_H,npcflag,speed_ walk,speed_run,scale,rank,dmg_multiplier,unit_flag s,type,type_flags,InhabitType,unk16,unk17,RegenHea lth,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,13893639 0,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_me nu_id,minlevel,maxlevel,minhealth,maxhealth,minman a,maxmana,armor,faction_A,faction_H,npcflag,speed_ walk,speed_run,scale,rank,dmg_multiplier,unit_flag s,type,type_flags,InhabitType,unk16,unk17,RegenHea lth,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,13893639 0,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_me nu_id,minlevel,maxlevel,minhealth,maxhealth,minman a,maxmana,armor,faction_A,faction_H,npcflag,speed_ walk,speed_run,scale,rank,dmg_multiplier,unit_flag s,type,type_flags,InhabitType,unk16,unk17,RegenHea lth,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,13893639 0,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_me nu_id,minlevel,maxlevel,minhealth,maxhealth,minman a,maxmana,armor,faction_A,faction_H,npcflag,speed_ walk,speed_run,scale,rank,dmg_multiplier,unit_flag s,type,type_flags,InhabitType,unk16,unk17,RegenHea lth,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,13893639 0,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'

Avidgamer
05-08-10, 02:44 PM
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

Dimman
05-08-10, 03:21 PM
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

Avidgamer
05-08-10, 03:35 PM
Fatcow, you realise it would be easier for him to just change it so he has it, rather then removing it?

ghostrevan
05-08-10, 03:39 PM
testing know thx.

Dimman
05-08-10, 05:38 PM
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')


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