Need Help With Navicat Query

[imjustbackup]

1.Im having issues with my query on navicat it would help alot of someone could help me with this...

2.well here is the issue when i try to add a vendor or some sort of vendor deal it gives me this error message

1054 - Unknown Column 'mountdisplayid' in 'feild list'

which if you look in the text below in red is where it only is located at i tried deleting it and then there isnt enough code so it still skrews up is this just a old code or am i doing something wrong plz help...

INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage,mountdisplayid, equipmodel1, equipinfo1, equipslot1, equipmodel2, equipinfo2, equipslot2, equipmodel3, equipinfo3, equipslot3, respawntime, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money, invisibility_type, death_state)
VALUES (23551, 60, 60, 35, 1, 1, 1, 1, 128, 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, 0, 0);
INSERT INTO creature_names (entry, `name`, Subname, Flags1, type, Family, Rank, unk4, SpellDataID, male_displayid, female_displayid, unknown_float1, unknown_float2, Civilian, Leader, info_str)
VALUES (23551,"Weapon/Item Enchants","WOTLK vendor",0,7,0,0,0,NULL,22906,22906,1, 1,1,NULL, '');
INSERT INTO vendors (entry, item, amount) VALUES (60000,23501,0);
INSERT INTO vendors (entry, item, amount) VALUES (60000,23502,0);
INSERT INTO vendors (entry, item, amount) VALUES (60000,23503,0);
INSERT INTO vendors (entry, item, amount) VALUES (60000,23504,0);
INSERT INTO vendors (entry, item, amount) VALUES (60000,23505,0);
INSERT INTO vendors (entry, item, amount) VALUES (60000,23506,0);
INSERT INTO vendors (entry, item, amount) VALUES (60000,23507,0);
INSERT INTO vendors (entry, item, amount) VALUES (60000,23508,0);
INSERT INTO vendors (entry, item, amount) VALUES (60000,23509,0);

BTW: i have arcemu pretty updated im starting from scratch so if you could point me in a new script all together for a enchant vendor that would be nice too...ty!

[Gastricpenguin]

There is no field called 'mountdisplayid' in your Creature_proto table. That is why it isn't working.

[imjustbackup]

how would i go about making mountdisplayid in there

BTW i think your the one who made this even though everyone else is posting and taking it in the exstration part in the .rar part it has a readme name with your name in it but everyone else is changing it to be there's idk why

[Algorithm]

run this query to add mountdisplayid to your creature_proto

ALTER TABLE `creature_proto` ADD `mountdisplayid` INT(30) unsigned NOT NULL DEFAULT '0' AFTER `rangedmaxdamage`;

[imjustbackup]

ok that solved that problem but it just finds anouther error that i dont have in my fields somewhere could it be that the query im trying to add is just to old?...and since i added that mountdisplayid does that skrew anything up with me adding more things to my database since there is a exstra field now?...lol im a nub with this stuff

even if i still thank you for trying to help i will +Rep you and we could use a person with some scripting skills on our private server if your interested

[Algorithm]

well lets put it this way. if you already execute a query mentioned in your first post. and now you trying re-executing it it will obviously give you errors.

Adding mountdisplayid in your proto structure is a must as it was an SQL update posted by arc emu devs.

Now if you need someone to help you with the server, i will do it free of charge no problem

[imjustbackup]

Well help would be nice i could use help with anything on the server right about now

add me on msn my name is [email protected]

also anyone else that is looking for some gm work on a newer server that has some sort of scripting skills or some other skills that can be usefull add me on msn at the link above or message me here