Aokromes

Other Database issues From where i get the database? https://github.com/TrinityCore/TrinityCore/releases Navicat gives error when trying to import TDB Avoid to use Navicat to import TDB, it don't follows all the sql standards and gives problem when trying to import files with /* */ or prepared statements. Importing TDB is really slow We recommend to use mysql cli to import TDB, it's the faster way. How i use mysql cli? On linux computers: mysql --default-character-set=utf8 -u USERNAME -pPASSWORD DATABASE < FILENAME.sql On windows computers: cd pathtomysql.exe mysql --default-character-set=utf8 -u USERNAME -pPASSWORD DATABASE < PATHTOFILENAME.sql Replace CAPS for the needed username, password, database and files. There are to much sql files under sql/updates directory Use http://www.trinitycore.org/f/topic/43-windowslinux-combine-sql-updates/ and then follow the "How i use mysql cli" with the created file.

Extractor Issues I am looking to extract maps but extractor is for wow 4. No it's not, vmap4extractor/vmap4assembler means it's extractor for Vmaps Version 4, no Vmaps for wow 4. TCE00013 I get MMAP:loadMap: 5303952.mmtile was built with generator v4, expected v5 constantly. You are trying to use some old mmaps version, recompile tools with the updated source you are using and re-extract all again. TCE00014 I get Couldn't open RootWmo while running extractor. It's not real error, you can ignore it. I can't extract Vmaps You need to extract maps 1st. My mobs casts spells through walls You need to extract and enable vmaps. Note: on some terrains mobs (and players) can cast through walls and it's blizzlike. My mobs walks through walls For this you need mmaps, atm Trinitycore this feature is disabled by default (extraction can take hours). Enable it on config. I used to use Mangos, can i reuse Maps/Vmaps/mmaps? No, you can't TC's versions for maps,vmaps and mmapsare diferent. TCE00015 I get error opening casc storage 'C:/Program Files (x86)World Of WarcraftData': UNKNOWN or FILE_NOT_FOUND Use battle.net repair to get missing files. Be sure .build.info exist on your wow directory and you are running the extractor where your wow binary is located for example: C:\games\World of Warcraft You may have used 6.x/7.x extractor trying to extract older wow version, you cannot use any extractor version with any wow version, the extractors belongs to especific wow versions. Be sure you have wow binaries / bnet launcher closed. TCE00017 I get error running map extractor, i get "No locales detected " Be sure you are running the extractor where your wow binary is located (for example: C:\games\World of Warcraft). Also, be sure you are running the correct version of wow for the selected branch. I am unable to extract files on master, it's stuck forever Run your wow client and exit and re-run extractor If you have crashes extracting maps on 4.3.4 branch can be because you have downloaded one incomplete client. If you have crashes extracting maps on 6.x branch can be because you are trying to use one localized client, switch locales to enus to allow extraction. If you cannot extract maps on master branch, be sure you have wow and bnet launcher closed, if that still fails change language to enus, if you are on enus change to another language and return to enus.

Features FAQ Wintergrasp works? ATM wintergrasp is WIP, there are a lot of bugs that needs to be fixed. What instances/arenas/bgs are working? Most of instances works on Triniycore, some are really blizzlike, others are fully broken, you can read about the status of some at http://www.trinitycore.org/f/topic/5166-arenasbgsinstances-status/ (needs login to be seen) On my bgs we have 10 vs 5 players making it easy mode for one faction. You can enable Battleground.InvitationType = 1 on your worldserver.conf file. Warden works? Yes, it does, but it doesn't have 100% sucess rate, and some of the "hacks" it detects are malware, if you see any entry of warden that it's malware detection and you have one malwarebytes/adware scan post it at TrinityCore (warden doesn't detects all hacks, not even on retail) How i can close one instance/bg? How i can disable one spell? Use disables system, read Disables

How to enable debug logs How i get good crashlogs under Linux? Under linux compile with the following flags: declare -x CFLAGS="-m64 -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O0 -g3 -ggdb3 -pipe -msse3 -fno-strength-reduce -fno-delete-null-pointer-checks -fno-strict-aliasing -frename-registers -rdynamic" declare -x CXXFLAGS="-m64 -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O0 -g3 -ggdb3 -pipe -msse3 -fno-strength-reduce -fno-delete-null-pointer-checks -fno-strict-aliasing -frename-registers -rdynamic" cmake ../ -DCMAKE_INSTALL_PREFIX=/change/path/to/trinity -DCMAKE_BUILD_TYPE=None If your core lags to much change -O0 by -Og or even -O1. Then copy TrinityCore/contrib/debugger/crashreport.gdb to your Trinitycore's bin directory and create a file with the following lines and make it runable: cp backtrace.log backtrace.`date +%Y%m%d-%H%M%S`.log screen -A -m -d -S tri_world gdb -x crashreport.gdb ./worldserver -c ../etc/worldserver.conf When your core crashes you will have a file called backtrace.log on your TrinityCore's directory. How i get good crashlogs under Windows? Select the dropdown on compile mode and change from RelWithDebug to Debug, Release mode crashlogs are useless.

Core compilation errors I don't get Trinitycore hash Read Howto properly install git on Windows I can't compile Trinitycore under CentOS 5/FreeBSD 9.0/Ubuntu 16.04LTS/Debian 8 Trinitycore needs GCC 6.3 or higher, CentOS 5 users needs to update CentOS or install GCC 6.3.0 minimum (not for newbies) (better alternative install clang 3.5 minimum). I can't compile Trinitycore under Windows XP Trinitycore needs Visual Studio 2017 you need to update to Windows 7 or higher. I can't compile Trinitycore under Linux i get c++: internal compiler error: Segmentation fault (program cc1plus) This can be because multiple reasons: 1) Selinux stronged kernels, workaround change to one standard kernel or compile with clang instead gcc or compile without pch. 2) Low ram/swap memory, increase ram/swap amount. how i do <insert here your question> under linux? If you don't know linux, buy a book, or use windows, running a server is not intended for ppl without knownledge on the OS they use. I can't compile Trinitycore i get /usr/local/include/boost/utility/result_of.hpp:189:8: error: no class template named ‘result’ in ‘const struct TaxiPathGraph::GetCompleteNodeRoute(const TaxiNodesEntry*, const TaxiNodesEntry*, const Player*, std::vector<unsigned int>&)::<lambda(const struct TaxiPathGraph::EdgeCost&)>’ Your boost version is to old, update minimum to 1.62, if you hand installed boost remember to remove apt-get installed/some other linux package tool installed version. I can't compile Trinitycore i get fatal error C1060: compiler is out of heap space C1076: compiler limit : internal heap limit reached; use /Zm to specify a higher limit Read https://msdn.microsoft.com/en-us/library/x4d2c09s.aspx I can't compile Trinitycore i get fatal error C1001: An internal error has occurred in the compiler. Update your Visual Studio. I can't compile Trinitycore i get Performing C++ SOURCE FILE Test boost_filesystem_copy_links_without_NO_SCOPED_ENUM failed with the following output: It's a very bad idea to mix experimental packages on production servers, return to stable packages (if you can't install boost after this fuckup use aptitude).

Startup errors TCE00007 Core don't starts i get: 2012-07-25 11:45:24 ERROR: Creature guid overflow!! Can't continue, shutting down server. This means you have spawned to much custom creatures, drop your world database and import a clean TDB or delete any spawn over guid 1000000 or reguid your custom guids for a lower guid (never reguid all, you will have problems with TDB updates). TCE00008 Core don't starts i get: dbc exists, and has 13 field(s) (expected 12). Extracted file might be from wrong client version or a database-update has been forgotten. You need to extract the files from the same unmodified client version of the server you are trying to run, Core don't starts it's closes as son i click the icon Use cmd to start the core instead the icon, on that way you can read the exact error, if you don't know what's cmd, stop trying to create a server or buy a windows book. I can't run Trinitycore on my AMD Athlon XP system Indeed, you can't, you need SSE2 support to run Trinitycore. TCE00009 Core don't starts, i get: 0x000007b You need mysql => 5.1. TCE00010 I can't run TrinityCore on my system i get "The ordinal 4334 Could not be located in the dynamic link library libeay32.dll found." Copy the dlls from openssl directory to where you put TrinityCore files. TCE00011 I can't run Trinitycore, i get Used MySQL library version (x.x.xx) does not match the version used to compile TrinityCore (x.x.xy) On windows copy the dlls from your build directory to where you are running core. On linux you must recompile your core (you may need to delete build directory). I get -- Performing Test boost_filesystem_copy_links_without_NO_SCOPED_ENUM - Failed error You can ignore it, it's a warning that we can't hide. TCE00012 I can't run Trinitycore, i get instance().use_certificate_chain_file("bnetserver.cert.pem", err) failed: No such file or directory You need to run trinitycore binaries from bin directory. I can't use any command, i get Table `command` contains a non-existing command 'deserter', skipped. for any command i run. You are using old style cmake, remove build directory and re-run cmake and be sure SCRIPTS or -DSCRIPTS have a value different to 0,1, the correct values are: none, static, dynamic, minimal-static, minmal-dynamic. The recommended setting to replace the old 0 is minimal-static. TCE00018 I get error running server: Map file './maps/0004331.map' is from an incompatible map version (MAPS v1.3), MAPS v1.8 is expected. Please pull your source, recompile tools, copy extractors to your wow binary directory (for example c:\games\World of Warcraft) and recreate maps using the updated mapextractor, then replace your old map files with new files. Be sure you compile the extractors for the correct version of you you are trying to use 1.3 don't means wow version 3 instead maps version 1.3 f you have problems with core being unable to find dbc/maps/mmaps/vmaps files can be because you don't have extracted the files, or you have put them on incorrect directory, check the path for them, also, using absolute paths (c:pathtotrinitycoredbc_maps_mmaps_vmaps_files) can help you better than using relative paths.

http://www.trinitycore.org/f/topic/1518-trouble-with-your-trinity-install-readme-1st-faqs/

--- Canned message start --- It appears the issue in the original post was solved, so this thread shall be closed. Should you encounter any other difficulties, please open a new thread. --- Canned message end ---

--- Canned message start --- It appears the issue in the original post was solved, so this thread shall be closed. Should you encounter any other difficulties, please open a new thread. --- Canned message end ---

Database update errors I can't apply some sql updates, i get duplicate column or column don't exist A very common mistake is to try to apply no needed sql files, for example, when you download TDB51 you have the following files: TDB_full_335.51_2013_02_14.sql this means the TDB version is for wow 3.3.5a, it's the 51th TDB version and released the year 2013, February day 14. and here comes the most common error: auth_2013_01_14_2013_02_14.sql world_2013_01_14_2013_02_14.sql Those 2 files are named year 2013, January day 14 to year 2013 February day 14, what means this? this 2 files are UPDATES from TDB 50 to TDB 51, if you have downloaded TDB51 you DON'T need to run those, because you have already more updated db version. Another very common error is to try to apply auth/character updates into a fresh downloaded core, the base files for auth/characters are updated every time they need to be updated and you don't need to run them on new server install. The same is valid for 4.3.4, if you get TDB 4.3.4-4 you don't need updates_01, 02, 03. TCE00004 I can't start core, i have applied every update and i get: [1054] Unknown column 'id' in 'field list' You are running the updates 2 times, if you merge sql files you only need to run TDB sql files and merged sql. TCE00005 I can't start core, i get spelldifficulty_dbc: spell 71356 at field id:2108 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0 or similar You forgot to apply some sql files you can fix this appling the correct 3.3.5a file on your database if you know what are you doing. I can't import some sql files, i get "Data too long for column 'description_loc1'" or similar errors Use mysql --default-character-set=utf8 -u username -pPASSWORD database < filename.sql to import your sql files. P.S. Seriously consider leave autoupdater to setup your core. I can't start core, i get: Applying update "2017_10_27_01_world.sql" 'BDDAB16'... ERROR 1067 (42000) at line 181: Invalid default value for 'start_time' line is: ALTER TABLE `game_event` ADD COLUMN `holidayStage` TINYINT UNSIGNED NOT NULL DEFAULT '0' AFTER `holiday`; Or simmilar messages wiki states you must disable mysql strict mode to run trinitycore server, read: https://stackoverflow.com/questions/40881773/how-to-turn-on-off-mysql-strict-mode-in-localhost-xampp

Repacks aren't supported on this forum, ask help on Jeuties webpage. --- Canned message start --- It appears the issue in the original post was solved, so this thread shall be closed. Should you encounter any other difficulties, please open a new thread. --- Canned message end ---

--- Canned message start --- It appears the issue in the original post was solved, so this thread shall be closed. Should you encounter any other difficulties, please open a new thread. --- Canned message end ---

The main priority is stability, since you can have all features working but 10 secs stability and that is unaceptable.

You know that the target of any software is to have features and stability and be free of bugs?

--- Canned message start --- It appears the issue in the original post was solved, so this thread shall be closed. Should you encounter any other difficulties, please open a new thread. --- Canned message end ---

--- Canned message start --- It appears the issue in the original post was solved, so this thread shall be closed. Should you encounter any other difficulties, please open a new thread. --- Canned message end ---

You have a question about a 3rd party patch posted on Custom Code and Requests? Post it on the same patch thread.

You have a question about a 3rd party patch posted on Custom Code and Requests? Post it on the same patch thread.

BTW, if you wanna try on a secondary dedicate server you can start core with http://www.trinitycore.info/How-to:Advanced:Valgrind i suggest you to disable every log and leave valgrind running for a day or so. IDK how much pop a dedicate machine can allow to test with valgrind, i tried to do one 10 man raid under a vm and the party lagged like hell.

--- Canned message start --- It appears the issue in the original post was solved, so this thread shall be closed. Should you encounter any other difficulties, please open a new thread. --- Canned message end ---

Full wotlk client+updates to 3.3.5a http://www.wow-patch.in/content/wow-client-3.0.1.php http://www.wow-patch.in/content/wow-patch-3.2.0-full.php http://www.wow-patch.in/content/wow-patch-3.3.0-full.php http://www.wow-patch.in/content/wow-patch-3.3.0a.php http://www.wow-patch.in/content/wow-patch-3.3.2.php http://www.wow-patch.in/content/wow-patch-3.3.3.php http://www.wow-patch.in/content/wow-patch-3.3.3a.php http://www.wow-patch.in/content/wow-patch-3.3.5.php http://www.wow-patch.in/content/wow-patch-3.3.5a.php

The use of valgrind is not recommended for production servers it kills performance a lot, you need a dedicated machine and very low pop to test it.

I said most

[00:37:46] <CIA-5> TrinityCore: kaelima master * r76be70a / (2 files in 2 dirs): Core/Battlefield: Fix some memory leaks - Core/Battlefield: Fix some memory leaks

Exporting mysql from windows changed the name of ip2nationCountries to ip2nationcountries, rename it back and you can start the core. btw of your log was enough with to discover the failure: In mysql_stmt_prepare() id: 58, sql: "SELECT c.country FROM ip2nationCountries c, ip2nation i WHERE i.ip < ? AND c.code = i.country ORDER BY i.ip DESC LIMIT 0,1" Table 'world.ip2nationCountries' doesn't exist Cannot connect to world database 127.0.0.1;3306;USER-HIDDEN;PASSWORD-HIDDEN;world