Jump to content
TrinityCore

Leaderboard

Popular Content

Showing content with the highest reputation on 07/16/15 in Posts

  1. Manual Database Installation Since TrinityCore looks to be hard for starters we made few threads where you can search for help for your problems. If you have problems importing the databases and you get "unknown column" "missing table" "Duplicate column" errors the best way is to reimport your databases: Since TrinityCores databases are very large use mysql --default-character-set=utf8 --max_allowed_packet=10000000 to avoid import failures because timeout/mysql gone away/etc 1) Clone desired branch. 2) Download the last released TDB from https://github.com/TrinityCore/TrinityCore/releases 3) Extract TDB files and put world database into your binary directory. 4) Start core 5) Profit. 6) NOTICE WE NEVER IMPORT sql/updates/auth or sql/updates/character files on fresh installation, also DON'T IMPORT sql/base/dev/world_database.sql. If you still have problems post at http://www.trinitycore.org/f/topic/328-unknown-column-missing-table-duplicate-column-error-sql-problems-sqldriverlogfile-answer-on-1st-post-of-1st-page/ writing what branch of TrinityCore you are trying to use. In case you are going to hand apply TDB and updates: 1) Clone desired branch.2) Import sql/create/create_mysql.sql3) Import sql/base/auth_database.sql4) Import sql/base/character_database.sql5) DON'T Import sql/base/world_database.sql, THIS TABLE IS ONLY TO ALLOW OUR BOT TEST SQL FILES6) Download the last released TDB from https://github.com/TrinityCore/TrinityCore/releases7) Apply TDB8) check TrinityCore/sql/old/ directory, if you see TDBxx_to_TDByy_updates where xx is the number of the TDB release you have download, you have downloaded one outdated database return to forum and download the last avariable database.9) Apply updates from sql/updates/world into world database10) Apply updates from sql/updates/hotfixes into hotfixes database (6.x branch ONLY)11) Profit.12) NOTICE WE NEVER IMPORT sql/updates/auth or sql/updates/character files on fresh installation, also DON'T IMPORT sql/base/dev/world_database.sql.
    1 point
×
×
  • Create New...