Aokromes
-
Posts
4497 -
Joined
-
Last visited
-
Days Won
229
Posts posted by Aokromes
-
-
Debian 10 will be shipped on 6 july.
-
delete wtf directory.
-
Detected 32-bit platform
* Install core to : C:/Program Files (x86)/TrinityCore
file STRINGS file "C:/Program Files/OpenSSL3-Win64/openssl/opensslv.h"
you cannot use 32 bits platform and 64 bits libs, also avoid to install trinitycore to directories with spaces.
-
--- Canned message start --- This thread does not belong in this section in its current form, and should be reposted in the tracker. Please read this thread to make your future help requests more effective. Read This too Search on tracker before posting any bug report. --- Canned message end ---
-
-
7 hours ago, Agrikk said:
How do I apply the SQL update files located in SQL\updates to bring my server up from 7.3.5 to 8.1.5?
I have downloaded the current master branch(8.1.5.30706), compiled it using vmaps, mmaps, gt, dbc and cameras files extracted from the latest retail client (8.1.5 30706). When I launch worldserver.exe I see it populating the databases from the included SQL files (TDB_world_735.00_2018_02_19.sql and TDB_hotfixes_735.00_2018_02_19.sql).
The problem is that when I then exit and restart worldserver.exe I get about 80,000 errors like the following:
SmartAIMgr::LoadSmartAIFromDB: Entry 18931 SourceType 0, Event 3, Link Source Event not found or invalid. Event will never trigger.
SmartAIMgr: Entry 2225800 SourceType 9 Event 7 Action 11 uses non-existent Spell entry 38679, skipped.
TSCR: DB table script_waypoint has waypoint for creature entry 17238, but creature does not have ScriptName defined and then useless.
Table `waypoint_scripts` uses deprecated direct updatefield modify command SCRIPT_COMMAND_FIELD_SET_DEPRECATED for script id 463
Scriptname: `spell_hun_improved_mend_pet` spell (Id: -19572) does not exist.
etc
I can log in to the server and create a new character, but the game is broken (no exclamation points showing for quests, can't cast spells, etc). When I run SELECT * FROM 'VERSION' my database version is still 7.3.5 even though I see in the SQL\updates folders there are .sql files that look like they'll update the version of my databases to 8.1.5. But when I attempt to execute them I get SQL errors so I don't think I am applying these update files correctly.
Help, please?
leave core to do the job, it will import all needed updates, the version is 7.3.5 because there is no full 8.1.5 database.
-
-
--- Canned message start --- This thread does not belong in this section in its current form, and should be reposted in the tracker. Please read this thread to make your future help requests more effective. Read This too Search on tracker before posting any bug report. --- Canned message end ---
-
dbc/db2 locales doens't have nothing to do with dberrors, the amount of rows is "logical" because patch version change, master branch never will have clean startup error.
-
21 hours ago, mitnick3 said:
i compiled it , on fresh git clone with no error, but i dont have dbc and maps. And patcher to run on client
there is no patcher since wow 7.3.0
-
On 6/10/2019 at 6:59 PM, FiftyTifty said:
Alrighty, got back to where I was before. Now I've run the create_mysql.sql file, but running worldserver with the trinity user throws the following error:
trinity@Ubuntu-1904-disco-64-minimal:~/server/bin$ sudo ./worldserver TrinityCore rev. d7375ad33f9d 2019-06-09 21:44:37 +0200 (3.3.5 branch) (Unix, RelWithDebInfo, Static) (worldserver-daemon) <Ctrl-C> to stop. ______ __ /\__ _\ __ __/\ \__ \/_/\ \/ _ __ /\_\ ___ /\_\ \, _\ __ __ \ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \ \ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \ \ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \ \/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \ C O R E /\___/ http://TrinityCore.org \/__/ Using configuration file /home/trinity/server/etc/worldserver.conf. Using SSL version: OpenSSL 1.1.1b 26 Feb 2019 (library: OpenSSL 1.1.1b 26 Feb 2019) Using Boost version: 1.67.0 Could not connect to MySQL database at 127.0.0.1: Access denied for user 'trinity'@'localhost' (using password: YES) DatabasePool Login NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. Read wiki at http://www.trinitycore.info/display/tc/TrinityCore+Home
I've even reissued the GRANT commands to ensure that trinity is given access to the databases, but nada. I'm thinking that it's a problem with worldserver trying to connect to 127.0.0.1, instead of localhost. How do I change that?
1st thing: you don't need to run tc with sudo.
2nd thing run https://github.com/TrinityCore/TrinityCore/blob/3.3.5/sql/create/create_mysql.sql and start worldserver without change config, if you change config, change https://github.com/TrinityCore/TrinityCore/blob/3.3.5/sql/create/create_mysql.sql to match config.
-
On 6/4/2019 at 1:20 PM, FiftyTifty said:
I've been following the guide thus far, and the previous pages have been pretty good at telling the user exactly what to do. But now that I'm at the Databases Installation section, there are no longer any steps to follow, and just unspecific advice is given: https://trinitycore.atlassian.net/wiki/spaces/tc/pages/2130092/Databases+Installation
I've downloaded the SQL database and put it next to worldserver, and I've downloaded the MySQL commands file. But what exactly do I do from then on? The guide just says to create the databases and populate them, without explaining how to do that.
what part of this is unclear?
Populating the MySQL Trinity databases
From the unpacked 7z folder copy the SQL files that start with "TDB_world_" and "TDB_hotfixes_" (master branch only) to the directory where your worldserver binary (worldserver on linux or mac, worldserver.exe on windows) is (DON'T RENAME THOSE FILES OR AUTOMATIC SETUP WILL FAIL).
NOTICE: you don't need to import any databases, only the file creating users. If you have plans to import databases manually you need to disable autoupdater on config files.If you have plans to change default mysql usernames and passwords make sure you have set valid database login information and the table names you want to use in the same config files (authserver/bnetserver/worldserver.conf) under "CONNECTIONS AND DIRECTORIES".
- Notice that the databases are not created yet. The names you set in the config will be used for the created databases.
Start worldserver and press enter when it asks if you want to create databases.
-
--- Canned message start --- Trinity does not support repacks. Please learn to compile and configure the source yourself, you will learn more and may even find that the error doesnt exist in vanilla TC. Please refer to the author of the repack for your questions if you continue to use said repack. --- Canned message end ---
-
9 hours ago, Vanclaive said:
I am really sorry to have to ask, but here goes.
Ubuntu 17.10 x64. Fresh clone of the 3.3.5 branch. I've let the worldserver create its own world database from scratch, and this is what it tells me:
TrinityCore rev. bc1f456125c1 2018-11-14 22:57:06 +0100 (3.3.5 branch) (Unix, RelWithDebInfo, Static) (worldserver-daemon)
Using SSL version: OpenSSL 1.0.2g 1 Mar 2016 (library: OpenSSL 1.0.2g 1 Mar 2016)
Using Boost version: 1.62.0
Updating Auth database...
>> Auth database is up-to-date! Containing 2 new and 42 archived updates.
Updating Character database...
>> Character database is up-to-date! Containing 1 new and 31 archived updates.
Updating World database...
>> World database is up-to-date! Containing 32 new and 4037 archived updates.
In mysql_stmt_prepare() id: 55, sql: "SELECT entry, difficulty_entry_1, difficulty_entry_2, difficulty_entry_3, KillCredit1, KillCredit2, modelid1, modelid2, modelid3, modelid4, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, exp, faction, npcflag, speed_walk, speed_run, scale, `rank`, dmgschool, BaseAttackTime, RangeAttackTime, BaseVariance, RangeVariance, unit_class, unit_flags, unit_flags2, dynamicflags, family, trainer_type, trainer_spell, trainer_class, trainer_race, type, type_flags, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, spell5, spell6, spell7, spell8, PetSpellDataId, VehicleId, mingold, maxgold, AIName, MovementType, ctm.Ground, ctm.Swim, ctm.Flight, ctm.Rooted, HoverHeight, HealthModifier, ManaModifier, ArmorModifier, DamageModifier, ExperienceModifier, RacialLeader, movementId, RegenHealth, mechanic_immune_mask, spell_school_immune_mask, flags_extra, ScriptName FROM creature_template ct LEFT JOIN creature_template_movement ctm ON ct.entry = ctm.CreatureId WHERE entry = ?"
Unknown column 'trainer_type' in 'field list'
Could not prepare statements of the World database, see log for details.Now, the funny thing is, if I don't put a TDB_full_world file in the bin directory, it grumbles about how it explicitly wants a 'TDB_full_world_335.64_2018_02_19.sql' file. If I give it this file, which I am under the impression is a little outdated, I get the error above. There is a newer TDB_full_world file, TDB_full_world_335.19041_2019_04_15.sql. Which if I put in the bin directory, is ignored. In my TrinityCore directory, the revision_data.h.in.cmake file references this newer sql file. I'm not sure why a freshly compiled worldserver would ask for this older sql file. (Manually applying this newer sql file, and all the updates thereafter, also doesn't work. but I know it's best to let the worldserver process do the updating, so manually doesn't really count.)
What's the dumb thing I'm missing, making me look especially dumb?
you are trying to use one outdated core ( 2018-11-14 22:57:06) with one to new database: TDB_full_world_335. 2019 04 1 _2019_04_15.sq
-
19 hours ago, Mr. Blazzar said:
Hi there.
I recently had to do various systems upgrades, and me being stupid, i ended up updating the mysql server i had installed to 5.7.25.
This leds to trinitycore not running due to incompatible versions. However, I am unable to re-install version 5.6
sudo apt-get install mysql-server-5.6 appears to be gone, and now refers to 5.7, according to my terminal. Am i missing something? I tried manually download it from their site, and installing the depdencies 1 by 1, but its a huge pain and so far no success.
Anyone have the correct approach?
As when i follow the linux requirements on the wiki, it re-installs 5.7.xthanks in advance
MySQL over 5.7 is UNSUPPORTED, you will need to patch TrinityCore sources to make TrinityCore work over MySQL 5.7.
OVER not 5.7 and over.
-
7 hours ago, deepwalker said:
Hi everybody,
Please i need your help. Is here somebody who can help me recompile or make new worldstart.exe ?? I have this file with code so spam me in world chat 1 message every 5mins.
But i cant make new compile files :/ Please who can this make send me message post reply and i send you picture with my problem.
Thank you so much!
read https://trinitycore.atlassian.net/wiki to learn how to compile. repacks are unsuported.
-
Since we are targeting C++17 compilers, GCC 6.3, clang 4 and Visual Studio 2017 under version 15.7 will become unsupported after summer
We give this warning to allow people to ready their systems with enough time to update (it's very likely Debian 10 will be shipped on 2nd quarter 2019).
(Visual Studio 2019 release date is on 2nd quarter 2019)
https://clang.llvm.org/cxx_status.html
https://gcc.gnu.org/projects/cxx-status.html#cxx17
-
1
-
1
-
-
TDB 335.19031 released
new naming standard:
19 year
03 month
1 1st release of month.
-
1
-
-
--- Canned message start --- This help request is in no way related to the official codebase of TrinityCore and/or TrinityDatabase and does not belong on these boards. --- Canned message end
-
On 3/18/2019 at 6:25 PM, Elvis said:
when i excute worldserver.exe after config and import the database, the app crash and print the error log: ERROR 1054 (42S22) at line 21: Unknown column 'OptionID' in 'field list'.
my configuration is like this:
when i create the database, "my create_mysql.sql" is as follows:
GRANT USAGE ON * . * TO 'root'@'localhost' IDENTIFIED BY '123456' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ;
CREATE DATABASE `world` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE `characters` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE `auth` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
GRANT ALL PRIVILEGES ON `world` . * TO 'root'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON `characters` . * TO 'root'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON `auth` . * TO 'root'@'localhost' WITH GRANT OPTION;
the authserver.conf is as follows:
LoginDatabaseInfo = "127.0.0.1;3306;root;123456;auth"
the worldserver.conf is as follows:
LoginDatabaseInfo = "127.0.0.1;3306;root;123456;auth"
WorldDatabaseInfo = "127.0.0.1;3306;root;123456;world"
CharacterDatabaseInfo = "127.0.0.1;3306;root;123456;characters"in the code, the red word 'root' is 'trinity' originally, the red word '123456' is also 'trinity' originally.
and after i excute the worldserver.exe, the app print error log ang crash.
the results of worldserver.exe and authserver.exe is shown in the picture.
enable autoupdater and leave core to do the job, if you don't want download latest TDB for master branch and apply every sql on updates directories.
-
--- Canned message start --- Trinity does not support repacks. Please learn to compile and configure the source yourself, you will learn more and may even find that the error doesnt exist in vanilla TC. Please refer to the author of the repack for your questions if you continue to use said repack. --- Canned message end ---
-
8 hours ago, Maximus311 said:
Hello,
I followed the detailed guide (https://trinitycore.atlassian.net/wiki/spaces/tc/overview?mode=global) to compile and install my server.It works but I have multiple database errors (see DBErrors.log).
Is this normal or am I doing something wrong?
I am in master branch and my client is in version 8.0.1.28153
Thank you in advance for your help.
db errors aint database instalation failure, known bugs, ignore.
-
23 hours ago, roweqharoji said:
Hi guys, this is my first post for help. I think this may be a really noob problem, but I just can't......
Sorry first if there's any mistakes.
I tried to host 4.3.4 from https://gitlab.com/trinitycore/TrinityCore_434, but with no luck I keep recieving error like The `spell_proc` table entry for spellIdXXX has Attribute PROC_ATTR_REQ_SPELLMOD, but spell has no spell mods. Proc will not be triggered. Detailed log is attached below.
I have host 3.3.5 without error, but when it comes to 4.3.4, I just can't figure out how to solve this situation. I've tried searching for similar problem, but they said it's client side issue. like this https://gitlab.com/trinitycore/TrinityCore_434/issues/165. I tried download different client data such as wowmortal, atlantiss, mangos wowregeneration...and other two client. But no luck with those...
If anyone can show me any hint, I would really appreciate
known bug it needs to be fixed. you did nothing incorrect on your side.
-
1
-
-
8 hours ago, Bluechen said:
Hi guys i have 2 questions maybe u can help me
How can change the Text from Valaatu ?
thx
trainer_locale
-
1
-
Sorry first if there's any mistakes.
GCC 6.3 / Visual Studio 2017 15.6 End Of Life
in Releases and Announcements
Posted
Debian 10 as been shipped, we recommend anyway to stop using gcc and switch to clang, also some day boost version for linux will be increased to 1.67 (debian 10 stable's version)