Jump to content
Why are these forums read only? ×
TrinityCore
Why are these forums read only?

shadedmagus

Plebs
 View Profile  See their activity

  • Posts

    14

  • Joined

  • Last visited

 Content Type 

Posts posted by shadedmagus

  1. Could not prepare statements of the Character database

    in Help and Support

    Posted

    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.

     

  2. Could not prepare statements of the Character database

    in Help and Support

    Posted · Edited by shadedmagus
    I forgot to add one of the steps I take

    I have done this, several times.

    1.  rm -rf /home/<user>/TrinityCore/build
    2. cd ~/TrinityCore
    3. mkdir build
    4. cd build
    5. cmake ../ -DCMAKE_INSTALL_PREFIX=/home/<user>/server -DTOOLS=1 -DWITH_WARNINGS=1
    6. 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.

     

  3. Could not prepare statements of the Character database

    in Help and Support

    Posted

    On 5/23/2018 at 8:02 AM, Shauren said:

    You do not need to switch distros, the reason for this is mysql version 8 (and newer)

    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.

  5. Could not prepare statements of the Character database

    in Help and Support

    Posted · Edited by shadedmagus
    Clarity

    54 minutes ago, vladex said:

    Since it seems you are compiling it on linux, I am not sure this solution will work. I usually got this error on windows when using the portable mysql version. I fixed by installing the .msi installer version of mysql 5.6. You should  do the same by using the .deb installer version or whatever package installer your linux distro uses.

    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.

  6. Could not prepare statements of the Character database

    in Help and Support

    Posted

    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

  7. Could not prepare statements of the Character database

    in Help and Support

    Posted

    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.

  8. Compile or cmake problems

    in Help and Support

    Posted · Edited by shadedmagus

    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.

  9. Dbc, Maps, mmaps, Vmaps problems

    in Help and Support

    Posted · Edited by shadedmagus
    Solution found

    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!

  11. [3.3.5a] Remote connection not fully working

    in Help and Support

    Posted · Edited by shadedmagus

    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?
     

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

    in Help and Support

    Posted · Edited by shadedmagus

    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.

×
×
  • Create New...