[ol][li] rm -rf /home//TrinityCore/build[/li]
[li]cd ~/TrinityCore[/li]
[li]mkdir build[/li]
[li]cd build[/li]
[li]cmake …/ -DCMAKE_INSTALL_PREFIX=/home//server -DTOOLS=1 -DWITH_WARNINGS=1[/li]
[li]make[/li]
[/ol]
At 14%, on the database_CXX_prefix files, it throws the errors I quoted earlier in the thread.
This is exactly the process I have followed since before the switch from mariadb; I do not modify any of the build files before I run cmake. I have not modified the build environment since I first built my Fedora Server 28 install and installed the required packages as per the install instructions on the wiki. I did one “dnf update” after the server was online, and that was before my first build attempt, which compiled but threw the initial mysql_stmt_prepare errors in my OP.
Issue still persists after commit 17539f1cb319f0d8d089038a4b10924d145ee248 . Seems to be somewhere else. Getting the same error when trying to load Spell Rank Data.
Loading Game Object Templates…
>> Loaded 21567 game object templates in 616 ms
Loading Game Object template addons…
>> Loaded 21500 game object template addons in 201 ms
Loading Transport templates…
>> Loaded 30 transport templates in 13 ms
Loading Transport animations and rotations…
Loading Spell Rank Data…
[1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘’ at line 1
Error while parsing SQL. Core fix required.
Went to Ubuntu Server 17.10, and the build compiled without any problems.
Out of curiosity, built a new Fedora Server 28 install, and at first build attempt, got the same error as above:
[CODE][ 14%] Generating CXX prefix source src/server/database/cotire/database_CXX_prefix.cxx
[ 14%] Generating CXX prefix header src/server/database/cotire/database_CXX_prefix.hxx
[ 14%] Building CXX precompiled header src/server/database/cotire/database_CXX_prefix.hxx.pch
In file included from /home/trinity-lk/TrinityCore/build/src/server/database/cotire/database_CXX_prefix.hxx:4:
In file included from /home/trinity-lk/TrinityCore/build/src/server/database/cotire/database_CXX_prefix.cxx:4:
In file included from /home/trinity-lk/TrinityCore/src/server/database/PrecompiledHeaders/databasePCH.h:30:
In file included from /usr/include/mysql/mysql.h:84:
/usr/include/mysql/mysql/client_plugin.h:108:8: fatal error: definition of type ‘MYSQL’ conflicts with typedef of the same name
struct MYSQL;
^
/home/trinity-lk/TrinityCore/src/server/database/Database/DatabaseEnvFwd.h:48:25: note: ‘MYSQL’ declared here
typedef struct st_mysql MYSQL;
^
1 error generated.
CMake Error at /home/trinity-lk/TrinityCore/dep/cotire/CMake/cotire.cmake:1885 (message):
cotire: error 1 precompiling
/home/trinity-lk/TrinityCore/build/src/server/database/cotire/database_CXX_prefix.hxx.
Call Stack (most recent call first):
/home/trinity-lk/TrinityCore/dep/cotire/CMake/cotire.cmake:3558 (cotire_precompile_prefix_header)