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

Okay, so... I had a Mac 1 week ago and I have a Windows now. Installed it... finally. Anyway, I was trying to compile the Trinity Core 4.3.4 and I did. I had a Database problem, but I read this guide: http://collab.kpsn.org/display/tc/How-To_Win+4.3.4#How-To_Win4.3.4-PullTheFull%2CMasterDatabase%2CAndUpdates

 

and it turns out that the Database is 174.6 MB big, without adding anything custom. Okay, fine. I started MySQL, I started Authserver and it worked fine. (I also configured the .conf files perfectly). But, whenever I start worldserver, it instant closes and gives me these errors:

Using configuration file worldserver.conf.
Using SSL version: OpenSSL 1.0.1e 11 Feb 2013 (library: OpenSSL 1.0.1c 10 May 2012)
Using ACE version: 6.1.4
TrinityCore rev. unknown 1970-01-01 00:00:00 +0000 (Archived branch) (Win32, Release) (worldserver-daemon)
<Ctrl-C> to stop.


 ______                       __
/__  _       __          __/ __
/_/ / _ __ /_    ___ /_ , _  __  __
     /`'__/  /' _ `/   / / / 
        /   / /     _  _ 
      _ _   _ _ _ _ __/`____ 
      /_//_/   /_//_//_//_//__/ `/___/> 
                                 C O R E  /___/
http://TrinityCore.org                    /__/


In mysql_stmt_prepare() id: 55, sql: "SELECT name, permission, help FROM command"
Unknown column 'permission' 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, Armor_mod, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, mechanic_immune_mask, flags_extra, ScriptName FROM creature_template WHERE entry = ?"
Unknown column 'trainer_spell' in 'field list'
DatabasePool world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
Cannot connect to world database localhost;3306;root;ascent;world

Okay. I followed EVERYTHING from your website and... Idk, it has an error. :S Is there any fixes for this or are you guys working on it? Thanks. (

[Compile or cmake problems]

*Ragequit* I have been trying to do this for like 2 days. Can someone PLEASE help me, because I am getting mad at this. This is my first time doing this on a Mac Machine and really, I really hate it. Here is my Skype: tomislav.bundalevski

I will appreciate this SO much if someone makes a fast tutorial on How to perfectly compile on a Mac Machine and how to generate the damn files. Thank you...

[Compile or cmake problems]

Did you point CMake to the proper source folder? It can't seem to find version.h in the ace directory.

 

Yes, I have. I just saw Version.h, it only has this:

// -*- C++ -*-
// $Id: Version.h 96107 2012-08-29 06:17:32Z johnnyw $
// This is file was automatically generated by $ACE_ROOT/bin/make_release.py

#define ACE_MAJOR_VERSION 6
#define ACE_MINOR_VERSION 1
#define ACE_BETA_VERSION 4
#define ACE_VERSION "6.1.4"

What's the problem? :/

[Compile or cmake problems]

 

This usually happens if you install OpenSSL wrong. If you open CMake and check the "Grouped" and "Advanced" boxes, you can edit the field to point it to your OpenSSL directory:

 

On a Windows box it looks like this (yes, I know you said Mac but the principle is the same):

 

 

Expand the "OPENSSL" group and you'll probably see the fields are either empty or plain wrong. Just click on them to edit their values.

 

 

Well, I guess the OpenSSL thing worked smoothly, but I tried configuring it again, and it didn't work. It says an ACE problem, but I tried several things and my "lib" folder is empty. Here is some more information:

CMake Error at cmake/macros/FindACE.cmake:65 (file):
file STRINGS file
"/Users/bundalevski/Desktop/TrinityCore-4.3.4/Downloads/ACE_wrappers/include/ace/Version.h"
cannot be read.
Call Stack (most recent call first):
CMakeLists.txt:55 (find_package)


CMake Error at cmake/macros/EnsureVersion.cmake:95 (NORMALIZE_VERSION):
NORMALIZE_VERSION Macro invoked with incorrect arguments for macro named:
NORMALIZE_VERSION
Call Stack (most recent call first):
cmake/macros/FindACE.cmake:71 (ENSURE_VERSION)
CMakeLists.txt:55 (find_package)


CMake Error at cmake/macros/FindACE.cmake:73 (message):
TrinityCore needs ACE version 5.8.3 but found version
Call Stack (most recent call first):
CMakeLists.txt:55 (find_package)

http://imageshack.us/photo/my-images/24/qyid.png/

 

[Compile or cmake problems]

Hello, I am using Xcode as a Compiler in CMake and it DOESN'T seem to work? I have followed your guide and I don't find it helpful/useful (as for my Mac)... Or probably my Mac hates you lol... Here are the errors that are showing in CMake:

The C compiler identification is Clang 5.0.0
The CXX compiler identification is Clang 5.0.0
Check for working C compiler using: Xcode
Check for working C compiler using: Xcode -- works
Detecting C compiler ABI info
Detecting C compiler ABI info - done
Check for working CXX compiler using: Xcode
Check for working CXX compiler using: Xcode -- works
Detecting CXX compiler ABI info
Detecting CXX compiler ABI info - done
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: /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang
CMake Error at /Applications/CMake 2.8-11.app/Contents/share/cmake-2.8/Modules/FindPackageHandleStandardArgs.cmake:108 (message):
Could NOT find OpenSSL (missing: OPENSSL_INCLUDE_DIR)
Call Stack (most recent call first):
/Applications/CMake 2.8-11.app/Contents/share/cmake-2.8/Modules/FindPackageHandleStandardArgs.cmake:315 (_FPHSA_FAILURE_MESSAGE)
cmake/macros/FindOpenSSL.cmake:176 (find_package_handle_standard_args)
CMakeLists.txt:56 (find_package)


Configuring incomplete, errors occurred!

I also imported a Screen Shot of the CMake!

 

Can anyone help me somehow? Thank you!