Ace1 Posted February 4, 2014 Share Posted February 4, 2014 Hello,  everytime when i'm starting this core i get this error  MySQL client library: 5.5.35 MySQL server ver: 5.5.35-0+wheezy1 [ERROR]: In mysql_stmt_prepare() id: 55, sql: "SELECT name, security, help FROM command" [ERROR]: Unknown column 'security' in 'field list' [ERROR]: In mysql_stmt_prepare() id: 58, sql: "SELECT difficulty_entry_1, difficulty_entry_2, difficulty_entry_3, KillCredit1, KillCredit2, modelid1, modelid2, modelid3, modelid4, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, exp, 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, spell5, spell6, spell7, spell8, PetSpellDataId, VehicleId, mingold, maxgold, AIName, MovementType, InhabitType, Health_mod, Mana_mod, Armor_mod, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, equipment_id, mechanic_immune_mask, flags_extra, ScriptName FROM creature_template WHERE entry = ?" [ERROR]: Unknown column 'trainer_spell' in 'field list' DatabasePool burnworld NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. Cannot connect to world database 127.0.0.1;3306;******;*********;burnworld   so my question is why the db acc is the right one :/  N8boy 1 Quote Link to comment Share on other sites More sharing options...
Ace1 Posted February 4, 2014 Author Share Posted February 4, 2014 so i made it work but now it stops at >> Loaded 0 hotfix info entries. DB table `hotfix_data` is empty. Loading missing KeyChains... Â Quote Link to comment Share on other sites More sharing options...
kontownik Posted February 4, 2014 Share Posted February 4, 2014 Well I just follow  the wiki - first time working on Warcraft server and it's working for me - did u follow the wiki?   My guess its when u made a mistake in cmake config - u dont check Mysql as wiki said.   edit3:  emmm did u import all databases? U start at "sqlbase" directory. Then u import skyfire updates - sql schemas - if u use phpmyadmin just IMPORT them !  Proper way:  sqlbaseauth_database.sql sqlbasecharacters_database.sql world beta dev's database is here -   -------------------------------------------------------------------------------- You now get auth (login database) - char (character race, faction etc) - world (scripts, npc's spawns etc) data --------------------------------------------------------------------------------  when u get the basic - import this.  sqlupdatesworld * ALL OF THEM *   *drunk grammar sry about that  ** DTB it's one of my fav. animes..... HOPE IT WILL HELP YOU - I'LL BE RLY PROUD IF CLICK THIS LIKE BUTTON RIGHT HERE ----- >>>>>> Quote Link to comment Share on other sites More sharing options...
kelhorn Posted February 4, 2014 Share Posted February 4, 2014 Yep. Probably a problem with updating db properly. Quote Link to comment Share on other sites More sharing options...
Ace1 Posted February 5, 2014 Author Share Posted February 5, 2014 new db new core and it works ^^ Quote Link to comment Share on other sites More sharing options...
Ace1 Posted February 5, 2014 Author Share Posted February 5, 2014 but i can't accept quest, cast spell, talk to the trainers and the fighting animation doesn't work. does anyone know why? Quote Link to comment Share on other sites More sharing options...
kontownik Posted February 5, 2014 Share Posted February 5, 2014 yup Quote Link to comment Share on other sites More sharing options...
Admin/Master Developers SkyFire Posted February 6, 2014 Admin/Master Developers Share Posted February 6, 2014 Sometime this week I will compile a list of working stuff and a list of broken stuff. I may add it in a wiki format so we can keep it updated. Don't know if I will get it done tonight but I will get it started. Ace1 1 Quote Link to comment Share on other sites More sharing options...
way Posted February 6, 2014 Share Posted February 6, 2014 thank you again alterego Quote Link to comment Share on other sites More sharing options...
Ace1 Posted February 6, 2014 Author Share Posted February 6, 2014 thank you guys Quote Link to comment Share on other sites More sharing options...
Unknow64 Posted February 8, 2014 Share Posted February 8, 2014 Hi  at first sorry for my grammar i'm french..   Well I just follow  the wiki - first time working on Warcraft server and it's working for me - did u follow the wiki?   My guess its when u made a mistake in cmake config - u dont check Mysql as wiki said.   edit3:  emmm did u import all databases? U start at "sqlbase" directory. Then u import skyfire updates - sql schemas - if u use phpmyadmin just IMPORT them !  Proper way:  sqlbaseauth_database.sql sqlbasecharacters_database.sql world beta dev's database is here -   -------------------------------------------------------------------------------- You now get auth (login database) - char (character race, faction etc) - world (scripts, npc's spawns etc) data --------------------------------------------------------------------------------  when u get the basic - import this.  sqlupdatesworld * ALL OF THEM *   *drunk grammar sry about that  ** DTB it's one of my fav. animes..... HOPE IT WILL HELP YOU - I'LL BE RLY PROUD IF CLICK THIS LIKE BUTTON RIGHT HERE ----- >>>>>>  When you say that sqlupdatesworld * ALL OF THEM *  I have upload all sql but i got many error with this files i would like to know if i'm alone or not ^^  See picture : http://i61.tinypic.com/11bm928.png  i know there are no support for 5.4.2 but i'm blocked at this point  Thank you in advance for help guys Quote Link to comment Share on other sites More sharing options...
kontownik Posted February 9, 2014 Share Posted February 9, 2014 It's latest NPC dump - you can skip this it's broken anyway (wrong aura ID's etc.). Server should run without them. Quote Link to comment Share on other sites More sharing options...
Unknow64 Posted February 9, 2014 Share Posted February 9, 2014 Ok thank you Kontownik  Yes my server run but there is many error in worldserver.exe  Spawns, spell etc.. Quote Link to comment Share on other sites More sharing options...
kontownik Posted February 9, 2014 Share Posted February 9, 2014 Got exactly same errors, core is new and scripts are outdated. Server is very bugged it's just a prototype or sandbox. Â For missing spells I think it's core error. Or scripts changed in time and don't use some spell-effects. Â You can delete most scripts - and for example start on Outland, when you fix all sql related error you can move on to new areas. etc. but its stupid and long process. It's possible to dump console errors to .txt file? I will be best option here. Â Â I will hunt down some errors in my free-time. And if u like to, post your fixes here, on this section for unsupported core. And when 5.4.7 final release will pop out we can post all of them in bug-tracker. Quote Link to comment Share on other sites More sharing options...
Admin/Master Developers SkyFire Posted February 9, 2014 Admin/Master Developers Share Posted February 9, 2014 Will update some of the scripts soon as I get spell casting done. Traveling all this week so time is limited. Some of the 4.0.6 scripts will still work with some minor updates. Quote Link to comment Share on other sites More sharing options...
Unknow64 Posted February 9, 2014 Share Posted February 9, 2014 I can upload my Server.log and DBerrors.log if someone need it   Thank you for answer Kontownik and AlterEgo Quote Link to comment Share on other sites More sharing options...
kontownik Posted February 9, 2014 Share Posted February 9, 2014 AlterEgo did ur and other devs works on this parser(5.4.2) will gone? Maybe some bugged unsupported release?  Why? u ask... Well, we got around 400mb of sniff files (5.4.2) here. Just laying and waiting - I think its 80%-85% of basic databases. And as we can see u got problems with your parsing methods (ex. auras). You're busy - anyone is  - but we can complete your parser.  There is nothing hard with it. Just learn the patterns - do some test on retail thats all.  If u can and its not a part of some secret mass-murder weapon.  It will be really helpful. Thanks for your good job. Quote Link to comment Share on other sites More sharing options...
Admin/Master Developers SkyFire Posted February 10, 2014 Admin/Master Developers Share Posted February 10, 2014 It's not some secret mass-murder weapon. I will release the updated parser source when I get home this week. I do this in my spare time as I travel a lot. As for anyone being gone. We are just on hold for now. Prepping for 5.4.7 release. Quote Link to comment Share on other sites More sharing options...
kontownik Posted February 10, 2014 Share Posted February 10, 2014 Sure thing but backward compatibility will be great coz of sniff files around here. Thx for u reply. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.