shadedmagus
Plebs-
Posts
14 -
Joined
-
Last visited
Recent Profile Visitors
2674 profile views
shadedmagus's Achievements
Newbie (1/14)
0
Reputation
-
Could not prepare statements of the Character database
shadedmagus replied to shadedmagus's topic in Help and Support
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: [ 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) make[2]: *** [src/server/database/CMakeFiles/database.dir/build.make:64: src/server/database/cotire/database_CXX_prefix.hxx.pch] Error 1 make[1]: *** [CMakeFiles/Makefile2:1124: src/server/database/CMakeFiles/database.dir/all] Error 2 make: *** [Makefile:130: all] Error 2 Following the instructions on the wiki precisely. -
Could not prepare statements of the Character database
shadedmagus replied to shadedmagus's topic in Help and Support
I have done this, several times. rm -rf /home/<user>/TrinityCore/build cd ~/TrinityCore mkdir build cd build cmake ../ -DCMAKE_INSTALL_PREFIX=/home/<user>/server -DTOOLS=1 -DWITH_WARNINGS=1 make 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. -
Could not prepare statements of the Character database
shadedmagus replied to shadedmagus's topic in Help and Support
Thank you for posting, Shauren. Since my build compiled and the binary couldn't open due to the reserved word "rank," and all I did was do a pull and now I can't compile, what should be my next step? Was there a regression in the database_CXX_prefix files that is keeping the compile from happening, when nothing in my build environment changed between one attempt and the next? Please advise. -
Could not prepare statements of the Character database
shadedmagus replied to shadedmagus's topic in Help and Support
I'm going to try Ubuntu 17.10 and see if I get a different result, then. I don't care for Debian and I prefer Fedora, but apparently it doesn't work for me anymore and this is the main purpose for my little server box. -
Could not prepare statements of the Character database
shadedmagus replied to shadedmagus's topic in Help and Support
But the only thing I changed from when I first reported the error statements in my original post was doing a new git pull. When I made my post, it had compiled with no issues, those errors were when I started the worldserver binary. -
Could not prepare statements of the Character database
shadedmagus replied to shadedmagus's topic in Help and Support
That's interesting, because I'm getting compile errors after pulling the latest commit just now: [ 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) make[2]: *** [src/server/database/CMakeFiles/database.dir/build.make:64: src/server/database/cotire/database_CXX_prefix.hxx.pch] Error 1 make[1]: *** [CMakeFiles/Makefile2:1124: src/server/database/CMakeFiles/database.dir/all] Error 2 make: *** [Makefile:130: all] Error 2 -
Hello, I am rebuilding my TrinityCore 3.3.5 project from scratch on Fedora Server 28. I have followed the Linux installation guide on the wiki and have reached the point where it is time to start the binaries. Authserver starts with no problems; but when I try to run worldserver, after all the databases are updated, I receive SQL errors. In mysql_stmt_prepare() id: 61, sql: "SELECT guildid, rank FROM guild_member WHERE guid = ?" 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 'FROM guild_member WHERE guid = ?' at line 1 In mysql_stmt_prepare() id: 119, sql: "INSERT INTO guild_member (guildid, guid, rank, pnote, offnote) VALUES (?, ?, ?, ?, ?)" 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 'rank, pnote, offnote) VALUES (?, ?, ?, ?, ?)' at line 1 In mysql_stmt_prepare() id: 142, sql: "UPDATE guild_member SET rank = ? WHERE guid = ?" 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 'rank = ? WHERE guid = ?' at line 1 In mysql_stmt_prepare() id: 190, sql: "UPDATE arena_team SET rating = ?, weekGames = ?, weekWins = ?, seasonGames = ?, seasonWins = ?, rank = ? WHERE arenaTeamId = ?" 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 'rank = ? WHERE arenaTeamId = ?' at line 1 In mysql_stmt_prepare() id: 242, sql: "INSERT INTO groups (guid, leaderGuid, lootMethod, looterGuid, lootThreshold, icon1, icon2, icon3, icon4, icon5, icon6, icon7, icon8, groupType, difficulty, raidDifficulty, masterLooterGuid) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" 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 'groups (guid, leaderGuid, lootMethod, looterGuid, lootThreshold, icon1, icon2, i' at line 1 In mysql_stmt_prepare() id: 246, sql: "UPDATE groups SET leaderGuid = ? WHERE guid = ?" 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 'groups SET leaderGuid = ? WHERE guid = ?' at line 1 In mysql_stmt_prepare() id: 247, sql: "UPDATE groups SET groupType = ? WHERE guid = ?" 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 'groups SET groupType = ? WHERE guid = ?' at line 1 In mysql_stmt_prepare() id: 250, sql: "UPDATE groups SET difficulty = ? WHERE guid = ?" 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 'groups SET difficulty = ? WHERE guid = ?' at line 1 In mysql_stmt_prepare() id: 251, sql: "UPDATE groups SET raiddifficulty = ? WHERE guid = ?" 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 'groups SET raiddifficulty = ? WHERE guid = ?' at line 1 In mysql_stmt_prepare() id: 327, sql: "DELETE FROM groups WHERE guid = ?" 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 'groups WHERE guid = ?' at line 1 In mysql_stmt_prepare() id: 414, sql: "REPLACE INTO calendar_invites (id, event, invitee, sender, status, statustime, rank, text) VALUES (?, ?, ?, ?, ?, ?, ?, ?)" 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 'rank, text) VALUES (?, ?, ?, ?, ?, ?, ?, ?)' at line 1 Could not prepare statements of the Character database, see log for details. The is after importing the "characters_database.sql" file in TrinityCore/sql/base. I created the databases as per "create_sql.sql" suggested, using my sql-user instead of the default "trinity" account as the only deviation. I can access the databases remotely with HeidiSQL. I'm not sure what the problem might be at this point.
-
Hello, Trying to build to current version (Updating a23c97a0fc..d9c772303c per git pull) after upgrading to Fedora 27, and I am getting the following error on the file DatabaseWorkerPool.cpp.o: [ 14%] Building CXX object src/server/database/CMakeFiles/database.dir/Database/DatabaseWorkerPool.cpp.o In file included from /home/trinity-lk/TrinityCore/src/server/database/PrecompiledHeaders/databasePCH.h:19:0, from /home/trinity-lk/TrinityCore/build/src/server/database/cotire/database_CXX_prefix.cxx:4, from /home/trinity-lk/TrinityCore/build/src/server/database/cotire/database_CXX_prefix.hxx:4: /home/trinity-lk/TrinityCore/src/server/database/Database/DatabaseWorkerPool.cpp: In constructor ‘DatabaseWorkerPool<T>::DatabaseWorkerPool()’: /home/trinity-lk/TrinityCore/src/server/database/Database/DatabaseWorkerPool.cpp:60:34: error: ‘MYSQL_SERVER_VERSION’ was not declared in this scope mysql_get_client_info(), MYSQL_SERVER_VERSION); ^ /home/trinity-lk/TrinityCore/src/common/Debugging/Errors.h:50:110: note: in definition of macro ‘WPFatal’ #define WPFatal(cond, ...) ASSERT_BEGIN do { if (!(cond)) Trinity::Fatal(__FILE__, __LINE__, __FUNCTION__, ##__VA_ARGS__); } while(0) ASSERT_END ^~~~~~~~~~~ compilation terminated due to -Wfatal-errors. make[2]: *** [src/server/database/CMakeFiles/database.dir/build.make:178: src/server/database/CMakeFiles/database.dir/Database/DatabaseWorkerPool.cpp.o] Error 1 make[1]: *** [CMakeFiles/Makefile2:1125: src/server/database/CMakeFiles/database.dir/all] Error 2 make: *** [Makefile:130: all] Error 2 I opened this file, and I noticed there's no #define statement for MYSQL_SERVER_VERSION. Is this an issue with the file? EDIT: I am running MariaDB 10.2.9, as that is what came with Fedora 27, in case that's needed.
-
Hello! The auto-update feature is awesome! Much less time to update TC now! Getting the following error when I try to start 3.3.5a worldserver on linux after updating on 30/12 (authserver started fine): VMap file '/home/trinity-lk/server/data/vmaps/000.vmtree' does not exist Please place VMAP-files (*.vmtree and *.vmtile) in the vmap-directory (/home/trinity-lk/server/data/vmaps/), or correct the DataDir setting in your worldserver.conf file. But when I run an ls in that directory, I see the 000.vmtree file in there. Should I just re-extract the vmaps, or is this a different issue? Update: Re-extracting the vmaps did the trick!
-
[3.3.5a] Remote connection not fully working
shadedmagus replied to shadedmagus's topic in Help and Support
Wow, that was it. Everything else was right, but that. Thanks! -
Hi all, I have a 3.3.5a server that I can connect to from within my network with no issues. I'm testing to see if remote connection works, and I'm running into an interesting problem...I can connect to the authserver with no issues, and it shows me the realm list...but when I try to connect to my worldserver, it times out and then kicks me back to the realm list. I'm running rev 94e4bddb903d on CentOS 7, if that helps. Authserver port - 3724 Worldserver port - 8085 I've used the internal IP address in the authserver and worldserver configs, as well as in the auth.reamlist entry for my worldserver, but that doesn't appear to be the source of the issue since I can log into auth from a public IP with no issues. I can also see the public IP I'm trying to log in from in the "last_ip" field. I checked firewalld to confirm that there are port entries for tcp/3724 and tcp/8085 - I needed those to get the connection working from within my network, so I don't think that's the problem. I set up trace-level logging for both auth and world, but I'm not seeing any messages other than the normal startup messages in world and "Updating Realm List..." in auth every so often. Any thoughts?
-
I'm not sure how this would have been fixed by an update to a table in the characters database that doesn't even exist in my database... Not that having an update log with hashes isn't a good idea, just not sure why the table was never added via updates. EDIT: Found the characters-db updates from March in my 'sql/old/3.3.5a/characters/57_2014_10_19' folder. Strange that they were moved there without my noticing. Applying them now. At any rate, I got much of the same output as ikir when I tried to start my worldserver after compiling two hours ago. It looks as though the build files weren't updated to match the new column names in the characters database.