Jump to content
  • 0

[ZERO] MySQL related unresolved external symbols when compiling


Zaronz

Question

Greetings, I have a problem when compiling the newest version of MaNGOS zero(18.1).

I have followd the Generic Windows guide step by step, yet I encounter this compile error which looks like a rookie mistake on my side.

This is on a Windows 64bit computer, running Windows 8 and using Visual Studio Express 2012 to build the Project. Here's the errors:

 Error	1	error LNK2019: unresolved external symbol _mysql_server_init@12 referenced in function "public: __thiscall DatabaseMysql::DatabaseMysql(void)" (??0DatabaseMysql@@QAE@XZ)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\realmd\mangos-shared.lib(DatabaseMysql.obj)	realmd
Error	2	error LNK2019: unresolved external symbol _mysql_server_end@0 referenced in function "public: virtual __thiscall DatabaseMysql::~DatabaseMysql(void)" (??1DatabaseMysql@@UAE@XZ)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\realmd\mangos-shared.lib(DatabaseMysql.obj)	realmd
Error	3	error LNK2019: unresolved external symbol _mysql_thread_init@0 referenced in function "public: virtual void __thiscall DatabaseMysql::ThreadStart(void)" (?ThreadStart@DatabaseMysql@@UAEXXZ)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\realmd\mangos-shared.lib(DatabaseMysql.obj)	realmd
Error	4	error LNK2001: unresolved external symbol _mysql_thread_init@0	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\realmd\mangos-shared.lib(SqlDelayThread.obj)	realmd
Error	5	error LNK2019: unresolved external symbol _mysql_thread_end@0 referenced in function "public: virtual void __thiscall DatabaseMysql::ThreadEnd(void)" (?ThreadEnd@DatabaseMysql@@UAEXXZ)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\realmd\mangos-shared.lib(DatabaseMysql.obj)	realmd
Error	6	error LNK2001: unresolved external symbol _mysql_thread_end@0	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\realmd\mangos-shared.lib(SqlDelayThread.obj)	realmd
Error	7	error LNK2019: unresolved external symbol _mysql_num_fields@4 referenced in function "public: virtual bool __thiscall MySqlPreparedStatement::prepare(void)" (?prepare@MySqlPreparedStatement@@UAE_NXZ)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\realmd\mangos-shared.lib(DatabaseMysql.obj)	realmd
Error	8	error LNK2019: unresolved external symbol _mysql_fetch_fields@4 referenced in function "private: bool __thiscall MySQLConnection::_Query(char const *,struct st_mysql_res * *,struct st_mysql_field * *,unsigned __int64 *,unsigned int *)" (?_Query@MySQLConnection@@AAE_NPBDPAPAUst_mysql_res@@PAPAUst_mysql_field@@PA_KPAI@Z)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\realmd\mangos-shared.lib(DatabaseMysql.obj)	realmd
Error	9	error LNK2019: unresolved external symbol _mysql_field_count@4 referenced in function "private: bool __thiscall MySQLConnection::_Query(char const *,struct st_mysql_res * *,struct st_mysql_field * *,unsigned __int64 *,unsigned int *)" (?_Query@MySQLConnection@@AAE_NPBDPAPAUst_mysql_res@@PAPAUst_mysql_field@@PA_KPAI@Z)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\realmd\mangos-shared.lib(DatabaseMysql.obj)	realmd
Error	10	error LNK2019: unresolved external symbol _mysql_affected_rows@4 referenced in function "private: bool __thiscall MySQLConnection::_Query(char const *,struct st_mysql_res * *,struct st_mysql_field * *,unsigned __int64 *,unsigned int *)" (?_Query@MySQLConnection@@AAE_NPBDPAPAUst_mysql_res@@PAPAUst_mysql_field@@PA_KPAI@Z)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\realmd\mangos-shared.lib(DatabaseMysql.obj)	realmd
Error	11	error LNK2019: unresolved external symbol _mysql_error@4 referenced in function "public: virtual bool __thiscall MySQLConnection::Execute(char const *)" (?Execute@MySQLConnection@@UAE_NPBD@Z)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\realmd\mangos-shared.lib(DatabaseMysql.obj)	realmd
Error	12	error LNK2019: unresolved external symbol _mysql_init@4 referenced in function "public: virtual bool __thiscall MySQLConnection::Initialize(char const *)" (?Initialize@MySQLConnection@@UAE_NPBD@Z)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\realmd\mangos-shared.lib(DatabaseMysql.obj)	realmd
Error	13	error LNK2019: unresolved external symbol _mysql_real_connect@32 referenced in function "public: virtual bool __thiscall MySQLConnection::Initialize(char const *)" (?Initialize@MySQLConnection@@UAE_NPBD@Z)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\realmd\mangos-shared.lib(DatabaseMysql.obj)	realmd
Error	14	error LNK2019: unresolved external symbol _mysql_query@8 referenced in function "public: virtual bool __thiscall MySQLConnection::Execute(char const *)" (?Execute@MySQLConnection@@UAE_NPBD@Z)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\realmd\mangos-shared.lib(DatabaseMysql.obj)	realmd
Error	15	error LNK2019: unresolved external symbol _mysql_store_result@4 referenced in function "private: bool __thiscall MySQLConnection::_Query(char const *,struct st_mysql_res * *,struct st_mysql_field * *,unsigned __int64 *,unsigned int *)" (?_Query@MySQLConnection@@AAE_NPBDPAPAUst_mysql_res@@PAPAUst_mysql_field@@PA_KPAI@Z)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\realmd\mangos-shared.lib(DatabaseMysql.obj)	realmd
Error	16	error LNK2019: unresolved external symbol _mysql_get_server_info@4 referenced in function "public: virtual bool __thiscall MySQLConnection::Initialize(char const *)" (?Initialize@MySQLConnection@@UAE_NPBD@Z)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\realmd\mangos-shared.lib(DatabaseMysql.obj)	realmd
Error	17	error LNK2019: unresolved external symbol _mysql_get_client_info@0 referenced in function "public: virtual bool __thiscall MySQLConnection::Initialize(char const *)" (?Initialize@MySQLConnection@@UAE_NPBD@Z)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\realmd\mangos-shared.lib(DatabaseMysql.obj)	realmd
Error	18	error LNK2019: unresolved external symbol _mysql_options@12 referenced in function "public: virtual bool __thiscall MySQLConnection::Initialize(char const *)" (?Initialize@MySQLConnection@@UAE_NPBD@Z)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\realmd\mangos-shared.lib(DatabaseMysql.obj)	realmd
Error	19	error LNK2019: unresolved external symbol _mysql_free_result@4 referenced in function "public: virtual __thiscall MySqlPreparedStatement::~MySqlPreparedStatement(void)" (??1MySqlPreparedStatement@@UAE@XZ)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\realmd\mangos-shared.lib(DatabaseMysql.obj)	realmd
Error	20	error LNK2001: unresolved external symbol _mysql_free_result@4	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\realmd\mangos-shared.lib(QueryResultMysql.obj)	realmd
Error	21	error LNK2019: unresolved external symbol _mysql_real_escape_string@16 referenced in function "public: virtual unsigned long __thiscall MySQLConnection::escape_string(char *,char const *,unsigned long)" (?escape_string@MySQLConnection@@UAEKPADPBDK@Z)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\realmd\mangos-shared.lib(DatabaseMysql.obj)	realmd
Error	22	error LNK2019: unresolved external symbol _mysql_thread_safe@0 referenced in function "public: __thiscall DatabaseMysql::DatabaseMysql(void)" (??0DatabaseMysql@@QAE@XZ)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\realmd\mangos-shared.lib(DatabaseMysql.obj)	realmd
Error	23	error LNK2019: unresolved external symbol _mysql_stmt_init@4 referenced in function "public: virtual bool __thiscall MySqlPreparedStatement::prepare(void)" (?prepare@MySqlPreparedStatement@@UAE_NXZ)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\realmd\mangos-shared.lib(DatabaseMysql.obj)	realmd
Error	24	error LNK2019: unresolved external symbol _mysql_stmt_prepare@12 referenced in function "public: virtual bool __thiscall MySqlPreparedStatement::prepare(void)" (?prepare@MySqlPreparedStatement@@UAE_NXZ)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\realmd\mangos-shared.lib(DatabaseMysql.obj)	realmd
Error	25	error LNK2019: unresolved external symbol _mysql_stmt_execute@4 referenced in function "public: virtual bool __thiscall MySqlPreparedStatement::execute(void)" (?execute@MySqlPreparedStatement@@UAE_NXZ)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\realmd\mangos-shared.lib(DatabaseMysql.obj)	realmd
Error	26	error LNK2019: unresolved external symbol _mysql_stmt_param_count@4 referenced in function "public: virtual bool __thiscall MySqlPreparedStatement::prepare(void)" (?prepare@MySqlPreparedStatement@@UAE_NXZ)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\realmd\mangos-shared.lib(DatabaseMysql.obj)	realmd
Error	27	error LNK2019: unresolved external symbol _mysql_stmt_bind_param@8 referenced in function "public: virtual void __thiscall MySqlPreparedStatement::bind(class SqlStmtParameters const &)" (?bind@MySqlPreparedStatement@@UAEXABVSqlStmtParameters@@@Z)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\realmd\mangos-shared.lib(DatabaseMysql.obj)	realmd
Error	28	error LNK2019: unresolved external symbol _mysql_stmt_close@4 referenced in function "public: virtual __thiscall MySqlPreparedStatement::~MySqlPreparedStatement(void)" (??1MySqlPreparedStatement@@UAE@XZ)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\realmd\mangos-shared.lib(DatabaseMysql.obj)	realmd
Error	29	error LNK2019: unresolved external symbol _mysql_stmt_result_metadata@4 referenced in function "public: virtual bool __thiscall MySqlPreparedStatement::prepare(void)" (?prepare@MySqlPreparedStatement@@UAE_NXZ)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\realmd\mangos-shared.lib(DatabaseMysql.obj)	realmd
Error	30	error LNK2019: unresolved external symbol _mysql_stmt_error@4 referenced in function "public: virtual void __thiscall MySqlPreparedStatement::bind(class SqlStmtParameters const &)" (?bind@MySqlPreparedStatement@@UAEXABVSqlStmtParameters@@@Z)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\realmd\mangos-shared.lib(DatabaseMysql.obj)	realmd
Error	31	error LNK2019: unresolved external symbol _mysql_autocommit@8 referenced in function "public: virtual bool __thiscall MySQLConnection::Initialize(char const *)" (?Initialize@MySQLConnection@@UAE_NPBD@Z)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\realmd\mangos-shared.lib(DatabaseMysql.obj)	realmd
Error	32	error LNK2019: unresolved external symbol _mysql_close@4 referenced in function "public: virtual __thiscall MySQLConnection::~MySQLConnection(void)" (??1MySQLConnection@@UAE@XZ)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\realmd\mangos-shared.lib(DatabaseMysql.obj)	realmd
Error	33	error LNK2019: unresolved external symbol _mysql_fetch_row@4 referenced in function "public: virtual bool __thiscall QueryResultMysql::NextRow(void)" (?NextRow@QueryResultMysql@@UAE_NXZ)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\realmd\mangos-shared.lib(QueryResultMysql.obj)	realmd
Error	34	error LNK1120: 30 unresolved externals	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\bin\Release\realmd.exe	realmd
Error	35	error LNK2019: unresolved external symbol _mysql_server_init@12 referenced in function "public: __thiscall DatabaseMysql::DatabaseMysql(void)" (??0DatabaseMysql@@QAE@XZ)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\mangosd\mangos-shared.lib(DatabaseMysql.obj)	mangosd
Error	36	error LNK2019: unresolved external symbol _mysql_server_end@0 referenced in function "public: virtual __thiscall DatabaseMysql::~DatabaseMysql(void)" (??1DatabaseMysql@@UAE@XZ)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\mangosd\mangos-shared.lib(DatabaseMysql.obj)	mangosd
Error	37	error LNK2019: unresolved external symbol _mysql_thread_init@0 referenced in function "public: virtual void __thiscall DatabaseMysql::ThreadStart(void)" (?ThreadStart@DatabaseMysql@@UAEXXZ)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\mangosd\mangos-shared.lib(DatabaseMysql.obj)	mangosd
Error	38	error LNK2001: unresolved external symbol _mysql_thread_init@0	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\mangosd\mangos-shared.lib(SqlDelayThread.obj)	mangosd
Error	39	error LNK2019: unresolved external symbol _mysql_thread_end@0 referenced in function "public: virtual void __thiscall DatabaseMysql::ThreadEnd(void)" (?ThreadEnd@DatabaseMysql@@UAEXXZ)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\mangosd\mangos-shared.lib(DatabaseMysql.obj)	mangosd
Error	40	error LNK2001: unresolved external symbol _mysql_thread_end@0	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\mangosd\mangos-shared.lib(SqlDelayThread.obj)	mangosd
Error	41	error LNK2019: unresolved external symbol _mysql_num_fields@4 referenced in function "public: virtual bool __thiscall MySqlPreparedStatement::prepare(void)" (?prepare@MySqlPreparedStatement@@UAE_NXZ)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\mangosd\mangos-shared.lib(DatabaseMysql.obj)	mangosd
Error	42	error LNK2019: unresolved external symbol _mysql_fetch_fields@4 referenced in function "private: bool __thiscall MySQLConnection::_Query(char const *,struct st_mysql_res * *,struct st_mysql_field * *,unsigned __int64 *,unsigned int *)" (?_Query@MySQLConnection@@AAE_NPBDPAPAUst_mysql_res@@PAPAUst_mysql_field@@PA_KPAI@Z)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\mangosd\mangos-shared.lib(DatabaseMysql.obj)	mangosd
Error	43	error LNK2019: unresolved external symbol _mysql_field_count@4 referenced in function "private: bool __thiscall MySQLConnection::_Query(char const *,struct st_mysql_res * *,struct st_mysql_field * *,unsigned __int64 *,unsigned int *)" (?_Query@MySQLConnection@@AAE_NPBDPAPAUst_mysql_res@@PAPAUst_mysql_field@@PA_KPAI@Z)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\mangosd\mangos-shared.lib(DatabaseMysql.obj)	mangosd
Error	44	error LNK2019: unresolved external symbol _mysql_affected_rows@4 referenced in function "private: bool __thiscall MySQLConnection::_Query(char const *,struct st_mysql_res * *,struct st_mysql_field * *,unsigned __int64 *,unsigned int *)" (?_Query@MySQLConnection@@AAE_NPBDPAPAUst_mysql_res@@PAPAUst_mysql_field@@PA_KPAI@Z)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\mangosd\mangos-shared.lib(DatabaseMysql.obj)	mangosd
Error	45	error LNK2019: unresolved external symbol _mysql_error@4 referenced in function "public: virtual bool __thiscall MySQLConnection::Execute(char const *)" (?Execute@MySQLConnection@@UAE_NPBD@Z)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\mangosd\mangos-shared.lib(DatabaseMysql.obj)	mangosd
Error	46	error LNK2019: unresolved external symbol _mysql_init@4 referenced in function "public: virtual bool __thiscall MySQLConnection::Initialize(char const *)" (?Initialize@MySQLConnection@@UAE_NPBD@Z)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\mangosd\mangos-shared.lib(DatabaseMysql.obj)	mangosd
Error	47	error LNK2019: unresolved external symbol _mysql_real_connect@32 referenced in function "public: virtual bool __thiscall MySQLConnection::Initialize(char const *)" (?Initialize@MySQLConnection@@UAE_NPBD@Z)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\mangosd\mangos-shared.lib(DatabaseMysql.obj)	mangosd
Error	48	error LNK2019: unresolved external symbol _mysql_query@8 referenced in function "public: virtual bool __thiscall MySQLConnection::Execute(char const *)" (?Execute@MySQLConnection@@UAE_NPBD@Z)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\mangosd\mangos-shared.lib(DatabaseMysql.obj)	mangosd
Error	49	error LNK2019: unresolved external symbol _mysql_store_result@4 referenced in function "private: bool __thiscall MySQLConnection::_Query(char const *,struct st_mysql_res * *,struct st_mysql_field * *,unsigned __int64 *,unsigned int *)" (?_Query@MySQLConnection@@AAE_NPBDPAPAUst_mysql_res@@PAPAUst_mysql_field@@PA_KPAI@Z)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\mangosd\mangos-shared.lib(DatabaseMysql.obj)	mangosd
Error	50	error LNK2019: unresolved external symbol _mysql_get_server_info@4 referenced in function "public: virtual bool __thiscall MySQLConnection::Initialize(char const *)" (?Initialize@MySQLConnection@@UAE_NPBD@Z)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\mangosd\mangos-shared.lib(DatabaseMysql.obj)	mangosd
Error	51	error LNK2019: unresolved external symbol _mysql_get_client_info@0 referenced in function "public: virtual bool __thiscall MySQLConnection::Initialize(char const *)" (?Initialize@MySQLConnection@@UAE_NPBD@Z)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\mangosd\mangos-shared.lib(DatabaseMysql.obj)	mangosd
Error	52	error LNK2019: unresolved external symbol _mysql_options@12 referenced in function "public: virtual bool __thiscall MySQLConnection::Initialize(char const *)" (?Initialize@MySQLConnection@@UAE_NPBD@Z)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\mangosd\mangos-shared.lib(DatabaseMysql.obj)	mangosd
Error	53	error LNK2019: unresolved external symbol _mysql_free_result@4 referenced in function "public: virtual __thiscall MySqlPreparedStatement::~MySqlPreparedStatement(void)" (??1MySqlPreparedStatement@@UAE@XZ)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\mangosd\mangos-shared.lib(DatabaseMysql.obj)	mangosd
Error	54	error LNK2001: unresolved external symbol _mysql_free_result@4	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\mangosd\mangos-shared.lib(QueryResultMysql.obj)	mangosd
Error	55	error LNK2019: unresolved external symbol _mysql_real_escape_string@16 referenced in function "public: virtual unsigned long __thiscall MySQLConnection::escape_string(char *,char const *,unsigned long)" (?escape_string@MySQLConnection@@UAEKPADPBDK@Z)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\mangosd\mangos-shared.lib(DatabaseMysql.obj)	mangosd
Error	56	error LNK2019: unresolved external symbol _mysql_thread_safe@0 referenced in function "public: __thiscall DatabaseMysql::DatabaseMysql(void)" (??0DatabaseMysql@@QAE@XZ)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\mangosd\mangos-shared.lib(DatabaseMysql.obj)	mangosd
Error	57	error LNK2019: unresolved external symbol _mysql_stmt_init@4 referenced in function "public: virtual bool __thiscall MySqlPreparedStatement::prepare(void)" (?prepare@MySqlPreparedStatement@@UAE_NXZ)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\mangosd\mangos-shared.lib(DatabaseMysql.obj)	mangosd
Error	58	error LNK2019: unresolved external symbol _mysql_stmt_prepare@12 referenced in function "public: virtual bool __thiscall MySqlPreparedStatement::prepare(void)" (?prepare@MySqlPreparedStatement@@UAE_NXZ)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\mangosd\mangos-shared.lib(DatabaseMysql.obj)	mangosd
Error	59	error LNK2019: unresolved external symbol _mysql_stmt_execute@4 referenced in function "public: virtual bool __thiscall MySqlPreparedStatement::execute(void)" (?execute@MySqlPreparedStatement@@UAE_NXZ)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\mangosd\mangos-shared.lib(DatabaseMysql.obj)	mangosd
Error	60	error LNK2019: unresolved external symbol _mysql_stmt_param_count@4 referenced in function "public: virtual bool __thiscall MySqlPreparedStatement::prepare(void)" (?prepare@MySqlPreparedStatement@@UAE_NXZ)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\mangosd\mangos-shared.lib(DatabaseMysql.obj)	mangosd
Error	61	error LNK2019: unresolved external symbol _mysql_stmt_bind_param@8 referenced in function "public: virtual void __thiscall MySqlPreparedStatement::bind(class SqlStmtParameters const &)" (?bind@MySqlPreparedStatement@@UAEXABVSqlStmtParameters@@@Z)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\mangosd\mangos-shared.lib(DatabaseMysql.obj)	mangosd
Error	62	error LNK2019: unresolved external symbol _mysql_stmt_close@4 referenced in function "public: virtual __thiscall MySqlPreparedStatement::~MySqlPreparedStatement(void)" (??1MySqlPreparedStatement@@UAE@XZ)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\mangosd\mangos-shared.lib(DatabaseMysql.obj)	mangosd
Error	63	error LNK2019: unresolved external symbol _mysql_stmt_result_metadata@4 referenced in function "public: virtual bool __thiscall MySqlPreparedStatement::prepare(void)" (?prepare@MySqlPreparedStatement@@UAE_NXZ)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\mangosd\mangos-shared.lib(DatabaseMysql.obj)	mangosd
Error	64	error LNK2019: unresolved external symbol _mysql_stmt_error@4 referenced in function "public: virtual void __thiscall MySqlPreparedStatement::bind(class SqlStmtParameters const &)" (?bind@MySqlPreparedStatement@@UAEXABVSqlStmtParameters@@@Z)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\mangosd\mangos-shared.lib(DatabaseMysql.obj)	mangosd
Error	65	error LNK2019: unresolved external symbol _mysql_autocommit@8 referenced in function "public: virtual bool __thiscall MySQLConnection::Initialize(char const *)" (?Initialize@MySQLConnection@@UAE_NPBD@Z)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\mangosd\mangos-shared.lib(DatabaseMysql.obj)	mangosd
Error	66	error LNK2019: unresolved external symbol _mysql_close@4 referenced in function "public: virtual __thiscall MySQLConnection::~MySQLConnection(void)" (??1MySQLConnection@@UAE@XZ)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\mangosd\mangos-shared.lib(DatabaseMysql.obj)	mangosd
Error	67	error LNK2019: unresolved external symbol _mysql_fetch_row@4 referenced in function "public: virtual bool __thiscall QueryResultMysql::NextRow(void)" (?NextRow@QueryResultMysql@@UAE_NXZ)	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\mangosd\mangos-shared.lib(QueryResultMysql.obj)	mangosd
Error	68	error LNK1120: 30 unresolved externals	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\Release\mangosd.exe	mangosd

Link to comment
Share on other sites

16 answers to this question

Recommended Posts

Thanks for the reply, I was in fact using 5.5 as that's what the guide told me to(Windows Generic). However, I have changed to version 5.6 now.

CMake was not very happy with the change, this is the result I got when I tried to generate after switching to 5.6:

Could NOT find Doxygen (missing: DOXYGEN_EXECUTABLE) 
Visual C++ 2012 detected.
MySQL not found.
Could NOT find MYSQL (missing: MYSQL_LIBRARIES MYSQL_INCLUDE_DIR) 
CMake Error: The following variables are used in this project, but they are set to NOTFOUND.
Please set them or make sure they are set and tested correctly in the CMake files:
MYSQL_INCLUDE_DIR (ADVANCED)
 used as include directory in directory G:/MaNGOS Vanilla Server Project/MangosZero/server/src/tools/vmap-assembler
 used as include directory in directory G:/MaNGOS Vanilla Server Project/MangosZero/server/src/tools/mmap-generator
 used as include directory in directory G:/MaNGOS Vanilla Server Project/MangosZero/server/src/game
 used as include directory in directory G:/MaNGOS Vanilla Server Project/MangosZero/server/src/game/vmap
 used as include directory in directory G:/MaNGOS Vanilla Server Project/MangosZero/server/src/game/AuctionHouseBot
 used as include directory in directory G:/MaNGOS Vanilla Server Project/MangosZero/server/src/game/BattleGround
 used as include directory in directory G:/MaNGOS Vanilla Server Project/MangosZero/server/src/game/OutdoorPvP
 used as include directory in directory G:/MaNGOS Vanilla Server Project/MangosZero/server/src/game/movement
 used as include directory in directory G:/MaNGOS Vanilla Server Project/MangosZero/server/src/realmd
 used as include directory in directory G:/MaNGOS Vanilla Server Project/MangosZero/server/src/mangosd
 used as include directory in directory G:/MaNGOS Vanilla Server Project/MangosZero/server/src/bindings/scripts
MYSQL_LIBRARIES (ADVANCED)
 linked by target "mangos-game" in directory G:/MaNGOS Vanilla Server Project/MangosZero/server/src/game
 linked by target "mangos-vmap" in directory G:/MaNGOS Vanilla Server Project/MangosZero/server/src/game/vmap
 linked by target "mangos-auctionhouse-bot" in directory G:/MaNGOS Vanilla Server Project/MangosZero/server/src/game/AuctionHouseBot
 linked by target "mangos-battleground" in directory G:/MaNGOS Vanilla Server Project/MangosZero/server/src/game/BattleGround
 linked by target "mangos-outdoor-pvp" in directory G:/MaNGOS Vanilla Server Project/MangosZero/server/src/game/OutdoorPvP
 linked by target "mangos-movement" in directory G:/MaNGOS Vanilla Server Project/MangosZero/server/src/game/movement
 linked by target "realmd" in directory G:/MaNGOS Vanilla Server Project/MangosZero/server/src/realmd
 linked by target "mangosd" in directory G:/MaNGOS Vanilla Server Project/MangosZero/server/src/mangosd

Configuring incomplete, errors occurred!
See also "G:/MaNGOS Vanilla Server Project/MangosZero/sourcefiles/CMakeFiles/CMakeOutput.log".

Note: I did not receive any CMake errors last time, using MySQL verson 5.5. I do not understand why CMake can't find MySQL now.

Link to comment
Share on other sites

You need to add the Mysql include path in cmake by hand, for some reason this occured to me too when i changed to win 7.

check the advanced tab and set

MYSQL_INLUDE_DIR C:/Program Files/MySQL/MySQL Server 5.6/include

probably you will have to set the library also

MYSQL_LIBRARIES C:/Program Files/MySQL/MySQL Server 5.6/lib/libmysql.dll

change path according to yours if you use an other one.

Link to comment
Share on other sites

Hi again, and thanks a lot for the suggestions. I tried out what Evildead suggested but received some errors related to libmysql:

Error	11	error LNK1181: cannot open input file '..\..\..\bin\Release\mangosd.lib'	G:\MaNGOS Vanilla Server Project\MangosZero\sourcefiles\src\bindings\scripts\LINK	mangos-scripts
Error	7	error LNK1107: invalid or corrupt file: cannot read at 0x368	C:\Program Files\MySQL\MySQL Server 5.6\lib\libmysql.dll	1	1	realmd
Error	8	error LNK1107: invalid or corrupt file: cannot read at 0x368	C:\Program Files\MySQL\MySQL Server 5.6\lib\libmysql.dll	1	1	vmap-assembler
Error	9	error LNK1107: invalid or corrupt file: cannot read at 0x368	C:\Program Files\MySQL\MySQL Server 5.6\lib\libmysql.dll	1	1	mmap-generator
Error	10	error LNK1107: invalid or corrupt file: cannot read at 0x368	C:\Program Files\MySQL\MySQL Server 5.6\lib\libmysql.dll	1	1	mangosd

I will try what Hikari mentioned and revert back to using MySQL 5.5 with development files in mind. Again, thanks a lot for the help, I really appreciate it.

EDIT: After reverting to MySQL 5.5, installing the full package, everything is now working. Compiled successfully.

I believe my mistake was not installing MySQL 5.5 complete edition the last time(as I already had it on my computer).

Big thanks to everyone that helped, I truly appreciate it.

Link to comment
Share on other sites

i did the same but i'm still having this problem

or at least a similar one:

mangos-shared.lib(DatabaseMysql.obj) : error LNK2019: unresolved external symbol _mysql_thread_init@0 referenced in function "public: virtual void __thiscall DatabaseMysql::ThreadStart(void)" (?ThreadStart@DatabaseMysql@@UAEXXZ)

17>mangos-shared.lib(SqlDelayThread.obj) : error LNK2001: unresolved external symbol _mysql_thread_init@0

17>mangos-shared.lib(DatabaseMysql.obj) : error LNK2019: unresolved external symbol _mysql_thread_end@0 referenced in function "public: virtual void __thiscall DatabaseMysql::ThreadEnd(void)" (?ThreadEnd@DatabaseMysql@@UAEXXZ)

17>mangos-shared.lib(SqlDelayThread.obj) : error LNK2001: unresolved external symbol _mysql_thread_end@0

17>mangos-shared.lib(DatabaseMysql.obj) : error LNK2019: unresolved external symbol _mysql_server_end@0 referenced in function "public: virtual __thiscall DatabaseMysql::~DatabaseMysql(void)" (??1DatabaseMysql@@UAE@XZ)

17>mangos-shared.lib(DatabaseMysql.obj) : error LNK2019: unresolved external symbol _mysql_real_escape_string@16 referenced in function "public: virtual unsigned long __thiscall MySQLConnection::escape_string(char *,char const *,unsigned long)" (?escape_string@MySQLConnection@@UAEKPADPBDK@Z)

17>mangos-shared.lib(DatabaseMysql.obj) : error LNK2019: unresolved external symbol _mysql_stmt_close@4 referenced in function "private: void __thiscall MySqlPreparedStatement::RemoveBinds(void)" (?RemoveBinds@MySqlPreparedStatement@@AAEXXZ)

17>mangos-shared.lib(DatabaseMysql.obj) : error LNK2019: unresolved external symbol _mysql_free_result@4 referenced in function "private: void __thiscall MySqlPreparedStatement::RemoveBinds(void)" (?RemoveBinds@MySqlPreparedStatement@@AAEXXZ)

17>mangos-shared.lib(QueryResultMysql.obj) : error LNK2001: unresolved external symbol _mysql_free_result@4

17>mangos-shared.lib(DatabaseMysql.obj) : error LNK2019: unresolved external symbol _mysql_close@4 referenced in function "public: virtual __thiscall MySQLConnection::~MySQLConnection(void)" (??1MySQLConnection@@UAE@XZ)

17>mangos-shared.lib(DatabaseMysql.obj) : error LNK2019: unresolved external symbol _mysql_fetch_fields@4 referenced in function "private: bool __thiscall MySQLConnection::_Query(char const *,struct st_mysql_res * *,struct st_mysql_field * *,unsigned __int64 *,unsigned int *)" (?_Query@MySQLConnection@@AAE_NPBDPAPAUst_mysql_res@@PAPAUst_mysql_field@@PA_KPAI@Z)

17>mangos-shared.lib(DatabaseMysql.obj) : error LNK2019: unresolved external symbol _mysql_field_count@4 referenced in function "private: bool __thiscall MySQLConnection::_Query(char const *,struct st_mysql_res * *,struct st_mysql_field * *,unsigned __int64 *,unsigned int *)" (?_Query@MySQLConnection@@AAE_NPBDPAPAUst_mysql_res@@PAPAUst_mysql_field@@PA_KPAI@Z)

17>mangos-shared.lib(DatabaseMysql.obj) : error LNK2019: unresolved external symbol _mysql_affected_rows@4 referenced in function "private: bool __thiscall MySQLConnection::_Query(char const *,struct st_mysql_res * *,struct st_mysql_field * *,unsigned __int64 *,unsigned int *)" (?_Query@MySQLConnection@@AAE_NPBDPAPAUst_mysql_res@@PAPAUst_mysql_field@@PA_KPAI@Z)

17>mangos-shared.lib(DatabaseMysql.obj) : error LNK2019: unresolved external symbol _mysql_store_result@4 referenced in function "private: bool __thiscall MySQLConnection::_Query(char const *,struct st_mysql_res * *,struct st_mysql_field * *,unsigned __int64 *,unsigned int *)" (?_Query@MySQLConnection@@AAE_NPBDPAPAUst_mysql_res@@PAPAUst_mysql_field@@PA_KPAI@Z)

17>mangos-shared.lib(DatabaseMysql.obj) : error LNK2019: unresolved external symbol _mysql_error@4 referenced in function "private: bool __thiscall MySQLConnection::_Query(char const *,struct st_mysql_res * *,struct st_mysql_field * *,unsigned __int64 *,unsigned int *)" (?_Query@MySQLConnection@@AAE_NPBDPAPAUst_mysql_res@@PAPAUst_mysql_field@@PA_KPAI@Z)

17>mangos-shared.lib(DatabaseMysql.obj) : error LNK2019: unresolved external symbol _mysql_query@8 referenced in function "private: bool __thiscall MySQLConnection::_Query(char const *,struct st_mysql_res * *,struct st_mysql_field * *,unsigned __int64 *,unsigned int *)" (?_Query@MySQLConnection@@AAE_NPBDPAPAUst_mysql_res@@PAPAUst_mysql_field@@PA_KPAI@Z)

17>mangos-shared.lib(DatabaseMysql.obj) : error LNK2019: unresolved external symbol _mysql_num_fields@4 referenced in function "public: virtual bool __thiscall MySqlPreparedStatement::prepare(void)" (?prepare@MySqlPreparedStatement@@UAE_NXZ)

17>mangos-shared.lib(DatabaseMysql.obj) : error LNK2019: unresolved external symbol _mysql_stmt_error@4 referenced in function "public: virtual bool __thiscall MySqlPreparedStatement::prepare(void)" (?prepare@MySqlPreparedStatement@@UAE_NXZ)

17>mangos-shared.lib(DatabaseMysql.obj) : error LNK2019: unresolved external symbol _mysql_stmt_result_metadata@4 referenced in function "public: virtual bool __thiscall MySqlPreparedStatement::prepare(void)" (?prepare@MySqlPreparedStatement@@UAE_NXZ)

17>mangos-shared.lib(DatabaseMysql.obj) : error LNK2019: unresolved external symbol _mysql_stmt_param_count@4 referenced in function "public: virtual bool __thiscall MySqlPreparedStatement::prepare(void)" (?prepare@MySqlPreparedStatement@@UAE_NXZ)

17>mangos-shared.lib(DatabaseMysql.obj) : error LNK2019: unresolved external symbol _mysql_stmt_prepare@12 referenced in function "public: virtual bool __thiscall MySqlPreparedStatement::prepare(void)" (?prepare@MySqlPreparedStatement@@UAE_NXZ)

17>mangos-shared.lib(DatabaseMysql.obj) : error LNK2019: unresolved external symbol _mysql_stmt_init@4 referenced in function "public: virtual bool __thiscall MySqlPreparedStatement::prepare(void)" (?prepare@MySqlPreparedStatement@@UAE_NXZ)

17>mangos-shared.lib(DatabaseMysql.obj) : error LNK2019: unresolved external symbol _mysql_stmt_bind_param@8 referenced in function "public: virtual void __thiscall MySqlPreparedStatement::bind(class SqlStmtParameters const &)" (?bind@MySqlPreparedStatement@@UAEXABVSqlStmtParameters@@@Z)

17>mangos-shared.lib(DatabaseMysql.obj) : error LNK2019: unresolved external symbol _mysql_stmt_execute@4 referenced in function "public: virtual bool __thiscall MySqlPreparedStatement::execute(void)" (?execute@MySqlPreparedStatement@@UAE_NXZ)

17>mangos-shared.lib(DatabaseMysql.obj) : error LNK2019: unresolved external symbol _mysql_autocommit@8 referenced in function "public: virtual bool __thiscall MySQLConnection::Initialize(char const *)" (?Initialize@MySQLConnection@@UAE_NPBD@Z)

17>mangos-shared.lib(DatabaseMysql.obj) : error LNK2019: unresolved external symbol _mysql_get_server_info@4 referenced in function "public: virtual bool __thiscall MySQLConnection::Initialize(char const *)" (?Initialize@MySQLConnection@@UAE_NPBD@Z)

17>mangos-shared.lib(DatabaseMysql.obj) : error LNK2019: unresolved external symbol _mysql_get_client_info@0 referenced in function "public: virtual bool __thiscall MySQLConnection::Initialize(char const *)" (?Initialize@MySQLConnection@@UAE_NPBD@Z)

17>mangos-shared.lib(DatabaseMysql.obj) : error LNK2019: unresolved external symbol _mysql_real_connect@32 referenced in function "public: virtual bool __thiscall MySQLConnection::Initialize(char const *)" (?Initialize@MySQLConnection@@UAE_NPBD@Z)

17>mangos-shared.lib(DatabaseMysql.obj) : error LNK2019: unresolved external symbol _mysql_options@12 referenced in function "public: virtual bool __thiscall MySQLConnection::Initialize(char const *)" (?Initialize@MySQLConnection@@UAE_NPBD@Z)

17>mangos-shared.lib(DatabaseMysql.obj) : error LNK2019: unresolved external symbol _mysql_init@4 referenced in function "public: virtual bool __thiscall MySQLConnection::Initialize(char const *)" (?Initialize@MySQLConnection@@UAE_NPBD@Z)

17>mangos-shared.lib(DatabaseMysql.obj) : error LNK2019: unresolved external symbol _mysql_thread_safe@0 referenced in function "public: __thiscall DatabaseMysql::DatabaseMysql(void)" (??0DatabaseMysql@@QAE@XZ)

17>mangos-shared.lib(DatabaseMysql.obj) : error LNK2019: unresolved external symbol _mysql_server_init@12 referenced in function "public: __thiscall DatabaseMysql::DatabaseMysql(void)" (??0DatabaseMysql@@QAE@XZ)

17>mangos-shared.lib(QueryResultMysql.obj) : error LNK2019: unresolved external symbol _mysql_fetch_row@4 referenced in function "public: virtual bool __thiscall QueryResultMysql::NextRow(void)" (?NextRow@QueryResultMysql@@UAE_NXZ)

17>C:\MangosZero\sourcefiles\bin\Release\realmd.exe : fatal error LNK1120: 30 unresolved externals

Link to comment
Share on other sites

sorry.... Could you click the 'advanced' checkbox please and post that screen shot

Also if you are compiling the 64Bit bit version, it currently doesn't work - which may be the errors you are getting are related to.

zlib and bzip do not currently release 64Bit versions of their libraries

But it does compile 32 bit on 64bit windows 8

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use