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

thedonbase

Plebs
 View Profile  See their activity

  • Posts

    8

  • Joined

  • Last visited

 Content Type 

Posts posted by thedonbase

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

    in Help and Support

    Posted

    Also, shouldn't take 2 days. (according to your OP) ;)

    335a wiki is pretty straightforward. You will learn alot, and get you a great start on understanding mysql

    First i tried using ArcEmu wich wouldn't even allow me to compile, so the day after that i used trinity wich gave me the conclussion that my mysql was outdated ,updated it and lost all my posts / and stuff on my website forums, all the other stuff for another private server and stuff so now i got everything back and trying with the 3.3.5 rev :P

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

    in Help and Support

    Posted

    The mysql error you posted almost spells it out for you. It has nothing to do with ports

    Yea but i really can't figure it out, if it is the things that are not found i don't know what to do, or hell, i don't know what to do here either. i mean i've tried getting it to run for 2 days, and i can't find  sqldriverlog and i don't know why it won't connect, as the auth.exe works

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

    in Help and Support

    Posted

    So after 2 days of working with pulling source / making the build files / complining and updating mysql database, i just got my auth to run after a fresh compile / install w/e but the world will not still run.

    i get this message

     

    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. 988a07ebcfa6 2013-04-28 17:18:49 +0200 (4.3.4 branch) (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, exp_unk, 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_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, type, type_flags, type_flags2, 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, mechanic_immune_mask, flags_extra, ScriptName FROM creature_template WHERE entry = ?"
    Unknown column 'exp_unk' in 'field list'
    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"
    Table 'world.ip2nationcountries' doesn't exist
    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;test;world
     

     

    And my database is running on port 3306, the username is root, and the pass is test obviously as the Auth is running without problems. i don't know what to do anymore.

    --------------- map files -----------
    All the map files isn't getting open as it is my second time doing this. the first time it gathered all the maps and vmaps dbcs perfectly, now it just gives me errors... any help?

×
×
  • Create New...