dravce15a

Thanks!

I have MySQL running it is visible in services tab in task manager, there are: MSSQL$SQLEXPRESS(running),MSSQLServerADHelper100(stoped),MySQL55(running). This only happens with worldserver, auth server starts with no problems. P.S, I have enable SQLDriverLogFile, and now I get the same error as Thatguy I think: 2012-05-13 09:41:31 Opening DatabasePool 'world'. Asynchronous connections: 1, synchronous connections: 1. 2012-05-13 09:41:31 MySQL client library: 5.5.9 2012-05-13 09:41:31 MySQL server ver: 5.5.24 2012-05-13 09:41:31 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements. 2012-05-13 09:41:31 MySQL client library: 5.5.9 2012-05-13 09:41:31 MySQL server ver: 5.5.24 2012-05-13 09:41:31 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements. 2012-05-13 09:41:31 [ERROR]: In mysql_stmt_prepare() id: 56, 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, HoverHeight, 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 = ?" 2012-05-13 09:41:31 [ERROR]: Unknown column 'HoverHeight' in 'field list' 2012-05-13 09:41:31 [ERROR]: In mysql_stmt_prepare() id: 58, sql: "SELECT c.country FROM ip2nationCountries c, ip2nation i WHERE i.ip < ? AND c.code = i.country ORDER BY i.ip DESC LIMIT 0,1" 2012-05-13 09:41:31 [ERROR]: Table 'world.ip2nationcountries' doesn't exist EDIT: I have imported the updates and it gives me an diffrent error now, something about vmaps, so I am extracting them, and hopefully will work. Thanks for the help guys! Best regards

Hi forum, I came across a problem I could not solve even after reading almost every topic created about the same situation. The problem is worldserver.exe throws out an error saying: 2012-05-12 22:25:29 Using configuration file worldserver.conf. 2012-05-12 22:25:29 Using SSL version: OpenSSL 1.0.0g 18 Jan 2012 (library: OpenSSL 1.0.0g 18 Jan 2012) 2012-05-12 22:25:29 Using ACE version: 5.8.3 2012-05-12 22:25:29 TrinityCore rev. 0000-00-00 00:00:00 +0000 (Archived) (Win32, Release) (worldserver-daemon) 2012-05-12 22:25:29 <Ctrl-C> to stop. 2012-05-12 22:25:29 ______ __ 2012-05-12 22:25:29 /\__ _\ __ __/\ \__ 2012-05-12 22:25:29 \/_/\ \/ _ __ /\_\ ___ /\_\ \, _\ __ __ 2012-05-12 22:25:29 \ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \ 2012-05-12 22:25:29 \ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \ 2012-05-12 22:25:29 \ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \ 2012-05-12 22:25:29 \/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \ 2012-05-12 22:25:29 C O R E /\___/ 2012-05-12 22:25:29 http://TrinityCore.org \/__/ 2012-05-12 22:25:29 ERROR: DatabasePool world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. 2012-05-12 22:25:29 ERROR: Cannot connect to world database 127.0.0.1;3306;root;xxx;world I am using windows 7, 32bit, MySQL version is 5.5.24, I have deleted .dist extensions from both authserver and worldserver, There are both of the .conf files: AUTHSERVER: realmlist in database is set to 127.0.0.1, I have followed the inscructions on wiki, to setup the database... And so I ran out of ideas what could be causing the problem... Hope you can help! Best regards P.S I have shortened the .conf files a bit because they were to long for this post.