zeukin

That's the name of my world db. I got it working. Everything's good.

I get 2 query warnings when installing character_database and 14 query warnings when installing the all_world_updates. I'm using heidisql. Where can I get a close look of the warnings? I'm using MySQL 5.5.34 btw OK I got the error for charactes_database and it is this

ERROR 1064 (42000): You have an error in your SQL syntax; chec corresponds to your MySQL server version for the right syntax inityCore/Trinity/sql/base/characters_database.sql' at line 1

OK so I found out that the main problem is installing the DB. I followed http://www.trinitycore.org/f/topic/43-windowslinux-combine-sql-updates/ this tut to combine all my sql updates cause it sure as hell is a hassle to execute them one by one and it seemed to have work despite the errors it gave me. I can login, create a char no problem. Am I in the clear?

Okay so when you have a fresh Trinity compile it has the libmysql.dll already in it but the step by step guide asks you to copy/paste libmySQL.dll: C:Program FilesMySQLMySQL Server 5.xlib so I thought maybe that's the reason and now it's giving me 0xc000007b error. I did search around to see what the error is about and one of the solutions is to disable firewall. I disabled and still nothing I get the same error. I'm going to recompile once again and see. --Update I recompiled and I'm back where world won't run and I took the screenshot quick before it went away. Hopefully you can see what the problem is.

Here is a more proper report taken from Athenas sig. What is your O.S. version? Windows 7 - What is your core version? (There is no "last version", on somedays we can do more than 1 commit, so post your correct core version) Revision 52 - Where did you grab it? https://github.com/TrinityCore/TrinityCore.git - Did you compiled yourself? Yes - Do you have all dependency's correctly installed? Gitext 2.47, I didn't need to download Visual C++ 2010 I already have Visual Studio 2010, MySQL 5.6.14, HeidiSQL 8.1.0.4545, Cmake 2.8.12.1, OpenSSL 64/32 1.0.1e both Visual C++ redistributables 2008 installed for OpenSSL to work properly. - Did you Follow our wiki? Followed it step by step. - Did you correctly updated the databases? I only added updates for world from sql/updates/world - Is your MySQL correctly configured and running? yes - What is your MySQL client? (SQLyog? MySQL command line? etc.. NOTE: please, don't use navicat) HeidiSQL - Did you opened the necessary ports? It's not public yet - Do you have any custom patches in the core? Which ones? Did you try without them? no - What is your wow client version? Did you extracted the necessary files from it? 3.3.5a, and yes I ran maps extractor, vmaps.bat and I moved mmaps generator back to bin/release and ran it to get mmaps.

I followed the complete guide on how to compile and configuring server with no difficulty, no errors. I can run auth successfully but world runs and closes immediately. I wish I knew the source of the problem to help you out more but no errors show up.

What are the commands used to import SQL files? Thanks for helping me out bud.

Where can I get the logs from to see the warning? Hmm I tried importing characters_database with sqlyog instead and no errors appeared, this could be a heidisql problem then?

I've followed everything so far on how to compile and now I'm executing the sql files. The character_databse sql located in Trinity/sql/base/character_databse gives me 2 query warnings What am I doing wrong?