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

leonardofan

Members
 View Profile  See their activity

  • Posts

    42

  • Joined

  • Last visited

 Content Type 

Posts posted by leonardofan

  3. Compile or cmake problems

    in Help and Support

    Posted 

    build/CMakeFiles/CMakeOutput.log".
root@nostalriusbr:/home/miguel/build# cmake ../ -DPREFIX=/home/`echo $USER`/server
-- Detected 64-bit platform
-- UNIX: Using default configuration directory
-- UNIX: Using default library directory
-- UNIX: Configuring uninstall target
-- UNIX: Created uninstall target
-- UNIX: Detected compiler: /usr/bin/cc
CMake Error at cmake/compiler/gcc/settings.cmake:7 (message):
  GCC: MagicWoWCore requires version 4.9.0 to build but found 4.8.4
Call Stack (most recent call first):
  cmake/platform/unix/settings.cmake:29 (include)
  cmake/macros/CheckPlatform.cmake:13 (include)
  CMakeLists.txt:58 (include)


-- Configuring incomplete, errors occurred!

     

     

    System: Ubuntu 14.04
    Version TDB 61

  4. erro updates

    in Help and Support

    Posted


    Using configuration file /home/root/servidor/etc/worldserver.conf.
    Using SSL version: OpenSSL 1.0.1f 6 Jan 2014 (library: OpenSSL 1.0.1f 6 Jan 2014)
    Using Boost version: 1.54.0
    Updating Auth database...
    >> Auth database is up-to-date! Containing 2 new and 8 archived updates.
    Updating Character database...
    >> Character database is up-to-date! Containing 1 new and 12 archived updates.
    Updating World database...
    >> Reapplying update "2015_12_20_00_world.sql" '88C8D50' -> 'CD45E89' (it changed)...
    ERROR 1062 (23000) at line 3: Duplicate entry '79520' for key 'PRIMARY'

    Applying of file '/home/TrinityCore/sql/updates/world/2015_12_20_00_world.sql' to database 'world' failed! If you are an user pull the latest revision from the repository. If you are a developer fix your sql query.
    Could not update the World database, see log for details.
    root@servidor-1:/home/root/servidor/bin#

     

     

    Ubuntu 14.04
    Revisão: http://prntscr.com/9rpknr
    TrinityCore db version: 60

  7. TrinityCore 4.3.4.15595

    in Chillout Room

    Posted

    AUTHSERVER

    Using configuration file /home/cataclysm/server/etc/authserver.conf.
Using SSL version: OpenSSL 1.0.1f 6 Jan 2014 (library: OpenSSL 1.0.1f 6 Jan 2014)
Using Boost version: 1.54.0
Opening DatabasePool 'auth'. Asynchronous connections: 1, synchronous connections: 1.
MySQL client library: 5.5.43
MySQL server ver: 5.5.43-0ubuntu0.14.04.1
Connected to MySQL database at 127.0.0.1
In mysql_stmt_prepare() id: 89, sql: "UPDATE battlenet_accounts SET v = ?, s = ? WHERE email = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 90, sql: "UPDATE battlenet_accounts SET sessionKey = ?, online = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 96, sql: "UPDATE battlenet_accounts SET failed_logins = failed_logins + 1 WHERE email = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 97, sql: "UPDATE battlenet_accounts SET last_ip = ?, last_login = NOW(), locale = ?, failed_logins = 0, os = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 99, sql: "INSERT INTO battlenet_accounts (`email`,`sha_pass_hash`) VALUES (?, ?)"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 102, sql: "UPDATE battlenet_accounts SET v = '', s = '', sha_pass_hash = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 103, sql: "SELECT 1 FROM battlenet_accounts WHERE id = ? AND sha_pass_hash = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 104, sql: "UPDATE battlenet_accounts SET locked = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 105, sql: "UPDATE battlenet_accounts SET lock_country = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
DatabasePool auth NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. Read wiki at http://collab.kpsn.org/display/tc/TrinityCore+Home
Cannot connect to database
root@wowpandora:/home/cataclysm/server/bin#

     

    WORLDSERVER

    Using configuration file /home/cataclysm/server/etc/worldserver.conf.
Using SSL version: OpenSSL 1.0.1f 6 Jan 2014 (library: OpenSSL 1.0.1f 6 Jan 2014)
Using Boost version: 1.54.0
In mysql_stmt_prepare() id: 68, sql: "UPDATE creature SET zoneId = ?, areaId = ? WHERE guid = ?"
Unknown column 'zoneId' in 'field list'
In mysql_stmt_prepare() id: 69, sql: "UPDATE gameobject SET zoneId = ?, areaId = ? WHERE guid = ?"
Unknown column 'zoneId' in 'field list'
DatabasePool cworld NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. Read wiki at http://collab.kpsn.org/display/tc/TrinityCore+Home
Cannot connect to world database 127.0.0.1;3306;root;heuheuh' --' help;cworld
root@wowpandora:/home/cataclysm/server/bin#

     

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

    in Help and Support

    Posted

    Hello all, I've compiled my server everything right so that the db I downloaded the trinitycore so far so good so that when I open my worldserver.exe appears the following error:

     

    txt server: 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) (Win32, 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: 29, sql: "SELECT point, position_x, position_y, position_z, orientation, move_flag, delay, action, action_chance FROM waypoint_data WHERE id = ? ORDER BY point"
    Unknown column 'orientation' in 'field list'
    In mysql_stmt_prepare() id: 32, sql: "SELECT position_x, position_y, position_z, orientation FROM waypoint_data WHERE id = ? ORDER BY point DESC LIMIT 1"
    Unknown column 'orientation' 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 'unit_flags2' 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;localhost;;world
     

     

    site: postimage.org/image/8pp3fav3l/ image

×
×
  • Create New...