Report "unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page in Help and Support Posted February 27, 2013 All, Was wondering what the correct way was to install the 4.3.4 database? Is this the correct order? TDB_full_434.04_2013_02_14.sql then the updates from TrinityCore_4.3.4_DB_Alpha folder04? I'm running this: Using SSL version: OpenSSL 1.0.0-fips Using ACE version: 6.0.3 TrinityCore rev. d3ad8a494112 2013-02-27 16:19:09 +0100 (4.3.4 branch) (Unix, Release) (worldserver-daemon) Realmlist gamebuild: 15595 Version: TrinityCore rev. 2013-02-14 00:00:00 +0000 (2277f6...2277f6db44a4dabf98611TDB 434.04 4 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, Armor_mod, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, mechanic_immune_mask, flags_extra, ScriptName FROM creature_template WHERE entry = ?" Unknown column 'trainer_spell' in 'field list' DatabasePool T4_world 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;user:pass;T4_world
"unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page
in Help and Support
Posted
All,
Was wondering what the correct way was to install the 4.3.4 database?
Is this the correct order?
TDB_full_434.04_2013_02_14.sql
then the updates from
TrinityCore_4.3.4_DB_Alpha folder04?
I'm running this: