Jump to content
Why are these forums read only? ×
TrinityCore
Why are these forums read only?

krtsaa

Plebs
 View Profile  See their activity

  • Posts

    10

  • Joined

  • Last visited

 Content Type 

Posts posted by krtsaa

  3. "unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page

    in Help and Support

    Posted · Edited by krtsaa

    still the same problem.. cant connect. tried compile trinity from scratch again and downloaded TDB and DB. Setup MySQL Databases again but still cannot connect. Any solution?

     

     

    BTW: Its TrinityCore 4.3.4 and im downloaded TrinityCore vmaps, dbc and maps. downloaded content is problem could someone upload working dbc, maps and vmaps?

     

    Error:

    Using configuration file worldserver.conf.
    Using SSL version: OpenSSL 1.0.1e 11 Feb 2013 (library: OpenSSL 1.0.1e 11 Feb 2013)
    Using ACE version: 6.1.4
    TrinityCore rev. 6521b1aad60d 2013-04-11 02:14:49 +0200 (master branch) (Win64, Release) (worldserver-daemon)
    <Ctrl-C> to stop.
     
     ______                       __
    /\__  _\       __          __/\ \__
    \/_/\ \/ _ __ /\_\    ___ /\_\ \, _\  __  __
       \ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
        \ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
         \ \_\ \_\  \ \_\ \_\ \_\ \_\ \__\\/`____ \
          \/_/\/_/   \/_/\/_/\/_/\/_/\/__/ `/___/> \
                                     C O R E  /\___/
    http://TrinityCore.org                    \/__/
     
    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 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;root;beta234;world
    [/code]

  5. "unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page

    in Help and Support

    Posted

    Hi, i've problem launching worldserver.exe it keep telling me this errors:

     

    Using configuration file worldserver.conf.
    Using SSL version: OpenSSL 1.0.1e 11 Feb 2013 (library: OpenSSL 1.0.1e 11 Feb 2013)
    Using ACE version: 6.1.4
    TrinityCore rev. 81908c7d7bc7 2013-04-08 15:47:32 -0400 (master branch) (Win64, Release) (worldserver-daemon)
    <Ctrl-C> to stop.
     
     ______                       __
    /\__  _\       __          __/\ \__
    \/_/\ \/ _ __ /\_\    ___ /\_\ \, _\  __  __
       \ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
        \ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
         \ \_\ \_\  \ \_\ \_\ \_\ \_\ \__\\/`____ \
          \/_/\/_/   \/_/\/_/\/_/\/_/\/__/ `/___/> \
                                     C O R E  /\___/
    http://TrinityCore.org                    \/__/
     
    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 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;root;beta234;world

     

    authserver.exe connect to my database and it runs fine. done everything as guide says.

     

    im running server from Windows 7 SP1 64bit machine.

     

    thanks in advance.

×
×
  • Create New...