Baked!
-
Posts
3 -
Joined
-
Last visited
Posts posted by Baked!
-
-
So I compiled the lastest trinitycore and when i compiled it there , I noticed there was already a libmysql.dll there so, I just grabbed the other two DLLs needed from OPENSSL, and the maps dbc and vmaps, and I would be ready to go, how ever when I used the libmysql already included i would get this error
The last row says its cannot connect to the login server, auth. It contained a password so I didn't include it
then when I use my libmysql.dll from the MYSQL folder I installed I get this
TrinityCore rev. 2013-01-28 19:50:01 +0100 (29cd1dbec17c) (Win32, Release) (authserver) <Ctrl-C> to stop. Using configuration file authserver.conf. OpenSSL 1.0.0j 10 May 2012 (Library: OpenSSL 1.0.0j 10 May 2012) Opening DatabasePool 'auth'. Asynchronous connections: 1, synchronous connections: 1. MySQL client library: 5.5.9 MySQL server ver: 5.5.29 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements. Connected to MySQL database at 127.0.0.1 MySQL client library: 5.5.9 MySQL server ver: 5.5.29 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements. Connected to MySQL database at 127.0.0.1 In mysql_stmt_prepare() id: 0, sql: "SELECT id, name, address, localAddress, localSubnetMask, port, icon, flag, timezone, allowedSecurityLevel, population, gamebuild FROM realmlist WHERE flag <> 3 ORDER BY name" Unknown column 'localAddress' in 'field list' DatabasePool auth NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. Cannot connect to database
-
So heres the error
Using configuration file worldserver.conf. Using SSL version: OpenSSL 1.0.1c 10 May 2012 (library: OpenSSL 1.0.1c 10 May 2012) Using ACE version: 6.1.4 TrinityCore rev. 0000-00-00 00:00:00 +0000 (Archived) (Win64, Release) (worldserver-daemon) <Ctrl-C> to stop. ______ __ /\__ _\ __ __/\ \__ \/_/\ \/ _ __ /\_\ ___ /\_\ \, _\ __ __ \ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \ \ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \ \ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \ \/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \ C O R E /\___/ http://TrinityCore.org \/__/ In mysql_stmt_prepare() id: 12, sql: "INSERT INTO npc_vendor (entry, item, maxcount, incrtime, extendedcost, type) VALUES(?, ?, ?, ?, ?, ?)" Unknown column 'type' in 'field list' In mysql_stmt_prepare() id: 13, sql: "DELETE FROM npc_vendor WHERE entry = ? AND item = ? AND type = ?" Unknown column 'type' in 'where clause' In mysql_stmt_prepare() id: 14, sql: "SELECT item, maxcount, incrtime, ExtendedCost, type FROM npc_vendor WHERE entry = ? AND type = ? ORDER BY slot ASC" Unknown column 'type' in 'field list' 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, unit_flags2, 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, Mana_mod_extra, Armor_mod, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, equipment_id, mechanic_immune_mask, flags_extra, ScriptName FROM creature_template WHERE entry = ?" Unknown column 'Mana_mod_extra' in 'field list'
Before you tell me to install the updates from the world folder, I did!
I am clueless can I get some assistance, thanks for your time !
"unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page
in Help and Support
Posted
THanks homie