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

amingo

Plebs
 View Profile  See their activity

  • Posts

    10

  • Joined

  • Last visited

 Content Type 

Posts posted by amingo

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

    in Help and Support

    Posted · Edited by amingo

    im create database world => appliqued TDB_full_434.05_2013_07_17  => start worldserver = error
     

    Using configuration file worldserver.conf.

    Using SSL version: OpenSSL 1.0.1g 7 Apr 2014 (library: OpenSSL 1.0.1g 7 Apr 2014)

    Using ACE version: 6.1.4

    TrinityCore rev. unknown 1970-01-01 00:00:00 +0000 (Archived branch) (Win64, Release) (worldserver-daemon)

    <Ctrl-C> to stop.

     

    ______                       __

    /__  _       __          __/ __

    /_/ / _ __ /_    ___ /_ , _  __  __

       /`'__/ /' _ `/ / / /

        / / / _ _

         _ _  _ _ _ _ __/`____

          /_//_/   /_//_//_//_//__/ `/___/>

                                     C O R E  /___/

     

    DatabasePool world trinity 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;azerty;world

     

     

    2 méthode :

    im create database world => appliqued TDB_full_434.05_2013_07_17  => update of TrinityCore_4.3.4_DB_Alpha => database world => start worldserver = error

    DatabasePool world trinity 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;azerty;world

     

    i m lost :'(

     

    help me plz

     

    sorry for my anglish :s

     

    i m french

     

    edit 13/05/2014

    In mysql_stmt_prepare() id: 54, 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, 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'

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

    in Help and Support

    Posted

    server.log

     

    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 4.3.4 NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.

     

    used : TDB_full_434.04_2013_02_14.7z + updates => https://github.com/TrinityCore/TrinityCore_4.3.4_DB_Alpha updates 04

     

    sorry im speak in french

×
×
  • Create New...