vendor help!!!

[galcybele]

Hey all im having problms with my vendors i use db ncdb r461 and when i created the vendor in wow-v, then i click on acsent and then execute, i get this error. sql dump import error. what am i doing wrong? Im using 2.2.0 db if that helps.

[slyfox101]

It would help if you posted the error's exact words...

[Acespades]

Alot of repacks aren't working... try this one

http://www.mmowned.com/forums/emulat...ng-center.html

[galcybele]

This is my error

Query:

CREATE TABLE `accounts` (

 `acct` bigint(20) NOT NULL auto_increment,

 `login` varchar(255) NOT NULL default '',

 `password` varchar(28) NOT NULL default '',

 `gm` varchar(27) NOT NULL default '',

 `banned` int(30) NOT NULL default '0',

 `lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,

 `lastip` varchar(15) NOT NULL default '',

 `email` varchar(50) NOT NULL default '',

 `flags` int(11) NOT NULL default '0',

 PRIMARY KEY  (`acct`,`login`),

 UNIQUE KEY `acct` (`acct`)

 ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1



Error occured at:2007-10-06 01:39:30

Line no.:26

Error Code: 1050 - Table 'accounts' already exists


Query:

CREATE TABLE `accounts` (

 `acct` bigint(20) NOT NULL auto_increment,

 `login` varchar(255) NOT NULL default '',

 `password` varchar(28) NOT NULL default '',

 `gm` varchar(27) NOT NULL default '',

 `banned` int(30) NOT NULL default '0',

 `lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,

 `lastip` varchar(15) NOT NULL default '',

 `email` varchar(50) NOT NULL default '',

 `flags` int(11) NOT NULL default '0',

 PRIMARY KEY  (`acct`,`login`),

 UNIQUE KEY `acct` (`acct`)

 ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1



Error occured at:2007-10-06 01:39:37

Line no.:26

Error Code: 1050 - Table 'accounts' already exists


Query:

INSERT INTO creature_names VALUES (50000, "Armor", "Dungeon I", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0)



Error occured at:2007-10-06 17:43:12

Line no.:64

Error Code: 1136 - Column count doesn't match value count at row 1


Query:

INSERT INTO creature_names VALUES (50000, "Armor", "Dungeon I", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0)



Error occured at:2007-10-06 17:43:26

Line no.:64

Error Code: 1136 - Column count doesn't match value count at row 1


Query:

insert into `gameobject_names` (`entry`, `Type`, `DisplayID`, `Name`, `spellfocus`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `unknown1`, `unknown2`, `unknown3`, `unknown4`, `unknown5`, `unknown6`, `unknown7`, `unknown8`, `unknown9`, `unknown10`, `unknown11`, `unknown12`, `unknown13`, `unknown14`) values('1000000','14','467','House','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0')



Error occured at:2007-10-06 17:46:37

Line no.:1

Error Code: 1062 - Duplicate entry '1000000' for key 1


Query:

˛
        

 






Error occured at:2007-10-06 19:28:17

Line no.:4109

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 1


Query:

INSERT INTO `trainers` VALUES ('372', '186', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '60', '0', 'Hello, Ä.')



Error occured at:2007-10-06 21:00:33

Line no.:964350

Error Code: 1406 - Data too long for column 'TalkText' at row 1


Query:

ascentacsentacsentascent





Error occured at:2007-10-06 21:29:27

Line no.:2

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 'ascentacsentacsentascent' at line 1


Query:

create table `accounts` (

 `acct` double ,

 `login` varchar (255),

 `password` varchar (28),

 `gm` varchar (27),

 `banned` double ,

 `lastlogin` timestamp ,

 `lastip` varchar (15),

 `email` varchar (50),

 `flags` double 

 )



Error occured at:2007-10-06 21:47:48

Line no.:17

Error Code: 1050 - Table 'accounts' already exists


Query:

INSERT INTO creature_names VALUES (50005, "Tier", "3", 0, 4, 0, 3, 0, 0, 19654, 1, 1, 1, 0)



Error occured at:2007-10-09 17:12:38

Line no.:4

Error Code: 1136 - Column count doesn't match value count at row 1


Query:

INSERT INTO creature_names VALUES (50005, "Tier", "3", 0, 4, 0, 3, 0, 0, 19654, 1, 1, 1, 0)



Error occured at:2007-10-09 17:14:50

Line no.:4

Error Code: 1136 - Column count doesn't match value count at row 1


Query:

INSERT INTO creature_names VALUES (50005, "Tier", "3", 0, 4, 0, 3, 0, 0, 19654, 1, 1, 1, 0)



Error occured at:2007-10-09 17:23:21

Line no.:4

Error Code: 1136 - Column count doesn't match value count at row 1


Query:

INSERT INTO creature_proto (entry, level, faction, health, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, item1slotdisplay, item1info1, item1info2, item2slotdisplay, item2info1, item2info2, item3slotdisplay, item3info1, item3info2, respawntime, resistance0_armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money)

 VALUES (30000,  90, 814,  100000,  100000,  1, 16388, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0)



Error occured at:2007-10-09 18:50:43

Line no.:2

Error Code: 1054 - Unknown column 'level' in 'field list'


Query:

INSERT INTO creature_proto (entry, level, faction, health, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, item1slotdisplay, item1info1, item1info2, item2slotdisplay, item2info1, item2info2, item3slotdisplay, item3info1, item3info2, respawntime, resistance0_armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money)

 VALUES (30000,  90, 814,  100000,  100000,  1, 16388, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0)



Error occured at:2007-10-09 18:50:56

Line no.:2

Error Code: 1054 - Unknown column 'level' in 'field list'


Query:

INSERT INTO creature_proto (entry, level, faction, health, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, item1slotdisplay, item1info1, item1info2, item2slotdisplay, item2info1, item2info2, item3slotdisplay, item3info1, item3info2, respawntime, resistance0_armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money)

 VALUES (30002,  90, 814,  100000,  100000,  1, 16388, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0)



Error occured at:2007-10-09 18:51:44

Line no.:2

Error Code: 1054 - Unknown column 'level' in 'field list'


Query:

INSERT INTO creature_proto (entry, level, faction, health, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, item1slotdisplay, item1info1, item1info2, item2slotdisplay, item2info1, item2info2, item3slotdisplay, item3info1, item3info2, respawntime, resistance0_armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money)

 VALUES (30000,  90, 814,  100000,  100000,  1, 16388, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0)



Error occured at:2007-10-09 20:05:29

Line no.:2

Error Code: 1054 - Unknown column 'level' in 'field list'


Query:

INSERT INTO creature_proto (entry, level, faction, health, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, item1slotdisplay, item1info1, item1info2, item2slotdisplay, item2info1, item2info2, item3slotdisplay, item3info1, item3info2, respawntime, resistance0_armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money)

 VALUES (30000,  90, 814,  100000,  100000,  1, 16388, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0)



Error occured at:2007-10-09 20:09:18

Line no.:2

Error Code: 1054 - Unknown column 'level' in 'field list'


Query:

INSERT INTO creature_proto (entry, level, faction, health, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, item1slotdisplay, item1info1, item1info2, item2slotdisplay, item2info1, item2info2, item3slotdisplay, item3info1, item3info2, respawntime, resistance0_armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money)

 VALUES (30000,  90, 814,  100000,  100000,  1, 16388, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0)



Error occured at:2007-10-09 20:09:20

Line no.:2

Error Code: 1054 - Unknown column 'level' in 'field list'


Query:

INSERT INTO creature_proto (entry, level, faction, health, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, item1slotdisplay, item1info1, item1info2, item2slotdisplay, item2info1, item2info2, item3slotdisplay, item3info1, item3info2, respawntime, resistance0_armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money)

 VALUES (30000,  90, 814,  100000,  100000,  1, 16388, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0)



Error occured at:2007-10-09 20:09:22

Line no.:2

Error Code: 1054 - Unknown column 'level' in 'field list'


Query:

INSERT INTO creature_proto (entry, level, faction, health, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, item1slotdisplay, item1info1, item1info2, item2slotdisplay, item2info1, item2info2, item3slotdisplay, item3info1, item3info2, respawntime, resistance0_armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money)

 VALUES (30000,  90, 814,  100000,  100000,  1, 16388, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0)



Error occured at:2007-10-09 20:09:22

Line no.:2

Error Code: 1054 - Unknown column 'level' in 'field list'


Query:

INSERT INTO creature_proto (entry, level, faction, health, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, item1slotdisplay, item1info1, item1info2, item2slotdisplay, item2info1, item2info2, item3slotdisplay, item3info1, item3info2, respawntime, resistance0_armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money)

 VALUES (30000,  90, 814,  100000,  100000,  1, 16388, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0)



Error occured at:2007-10-09 20:09:23

Line no.:2

Error Code: 1054 - Unknown column 'level' in 'field list'


Query:

INSERT INTO items (entry, class, subclass, field4, name, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 

 VALUES (20000,2,7,-1,"The Legions Blade","The Legions Blade","The Legions Blade","The Legions Blade",42348,4,0,0000,0000,13,-1,-1,80,80,0,0,0,0,0,0,0,2,1,0,7,100,3,150,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,441,597,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10,10,10,10,10,10,1500,0,0,34696,2,0,0,0,0,34696,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,"Carved From The Hands Of Legion",0,0,0,0,0,-1,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)



Error occured at:2007-10-09 20:54:08

Line no.:2

Error Code: 1062 - Duplicate entry '20000' for key 1


Query:

INSERT INTO creature_proto (entry, level, faction, health, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, item1slotdisplay, item1info1, item1info2, item2slotdisplay, item2info1, item2info2, item3slotdisplay, item3info1, item3info2, respawntime, resistance0_armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money)

 VALUES (30000,  90, 814,  100000,  100000,  1, 16388, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0)



Error occured at:2007-10-09 21:54:30

Line no.:2

Error Code: 1054 - Unknown column 'level' in 'field list'

ahahaha i fixed it silly me thanks anyways guys.

nope its not fixed, someone please help??

[galcybele]

please anyone??

[slyfox101]

That's a list of all of the errors you've ever gotten. Why don't you just copy the batch and execute it as a query?

[galcybele]

i did that i downloadedd the batch from wow-v, and then i i right clicked acsent adn then clicked restore from sql dump, and the nclicked the file and boom error. what am i doing wrong?

[tonks1]

the wow-v vendors never work lol or may-b its jsut me but idk

[galcybele]

so how can i make vendors /cry

[slyfox101]

INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, item1slotdisplay, item1info1, item1info2, item2slotdisplay, item2info1, item2info2, item3slotdisplay, item3info1, item3info2, respawntime, resistance0_armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money)

VALUES (30000, 90, 90, 814, 100000, 100000, 100000, 16388, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0)

Just execute that as a query, it should work.

[galcybele]

into which field? like creatures? vendors?? what one?

[slyfox101]

Copy and paste that into a query dude, and then execute the query. It's quite simple...

You using SQLyog or Navicat?

[galcybele]

sqlyog lol yea i mis read before what u said i understand it lol.

[galcybele]

didnt work i got an error again.