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

Hi, actually I had to change these instructions since I was using a x86 MySQL... So instead of using Program Files I changed it to Program Files (x86). I guess that this is where the mistake happened.

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

Hi,

In the end I found out what the error was... I had misconfigured the mysql executable on the server config file.

This is what I had:

MySQLExecutable = "C:\Program Files (x86)\MySQL\MySQL Server 5.6\bin"

And this is what I should have:

MySQLExecutable = "C:\Program Files (x86)\MySQL\MySQL Server 5.6\bin\mysql.exe"

As you can see, I forgot to add the "mysql.exe" at the end of the config string. I assumed that only the path was needed on this case, but I guess I didn't read the example with a lot of attention:

#
#    MySQLExecutable
#        Description: The path to your mysql cli binary.
#                     If the path is left empty, built-in path from cmake is used.
#        Example:     "C:/Program Files/MySQL/MySQL Server 5.6/bin/mysql.exe"
#                     "mysql.exe"
#                     "/usr/bin/mysql"
#        Default:     ""

Anyway, everything is working now! :-)

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

Hi,

I am new to Trinity Core and I am trying to build my first server...

I've been following the tutorials, but it seems that I am stuck in the database part. I've created the 3.3.5a branch as instructed here: https://github.com/TrinityCore/TrinityCore/blob/3.3.5/sql/create/create_mysql.sql and I've ran the worldserver.exe. Unfortunately it is giving me the error below:

Using configuration file C:/Desenvolvimento/Trinity/Install/worldserver.conf.
Using SSL version: OpenSSL 1.0.2j  26 Sep 2016 (library: OpenSSL 1.0.2j  26 Sep 2016)
Using Boost version: 1.62.0
Database Auth is empty, auto populating it...
>> Applying '../TrinityCore/sql/base/auth_database.sql'...
Applying of file '../TrinityCore/sql/base/auth_database.sql' to database 'auth' failed! If you are a user, please pull the latest revision from the repository. Also make sure you have not applied any of the databases with your sql client. You cannot use auto-update system and import sql files from TrinityCore repository with your sql client. If you are a developer, please fix your sql query.
Could not populate the Login database, see log for details.

I've checked my user (trinity) and I am able to connect to the database and create tables and schemas with it. I have also configured my source folder as: SourceDirectory  = "../TrinityCore", so the path to the auth_database.sql file is valid. Can anyone help me?

Note: I am using Windows 10 with Visual Studio 2015 Community and MySQL 5.6.35. I've built all for a x32 archtecture.