Leaderboard

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.

No problems, I fixed restarting the game and the server. Thanks for the support. And sorry againg for my english.

Alright now the worldserver.exe is working. All the .conf files are fine but now I'm getting this with my authserver.exe Using configuration file authserver.conf OpenSSL 1.0.01 6 Jan 2014 (Library: OpenSSL 1.0.01 6 Jan 2014) Database not specified

When I attempted to connect my 4.3.4 server to the database I recieved the familiar 2012-07-11 16:47:10 ERROR: DatabasePool world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. 2012-07-11 16:47:10 ERROR: Cannot connect to world database 127.0.0.1;3306;trinity;trinity;world error. I read through the FAQ, I have set up a number of 3.3.5 servers over the last year and a half, I knew it had to do with DB updates, so I followed the guide at: http://collab.kpsn.org/pages/viewpage.action?pageId=1704351 Yet, no matter what I did, I couldn't get the server to connect. On a hunch, I decided to pull the sql files from /sql/updates/world, which I knew the guide said explicitly not to. When I did, I recieved a ton of errors in my SQL console, but now the world server was connecting to the DB. The data is completely non functional, even worse than the usual alpha bugs the 4.3.4 branch has, but I'm wondering why did it only connect when I imported updates I'm not supposed to import? How do I get it to connect with the proper DB?

1 and 2, they are temporaly there. 3 it's result of merging branches. 4) http://www.trinitycore.org/f/topic/1518-trouble-with-your-trinity-install-readme-1st-faqs/#entry42704 and still we have people asking the same question every time.