Jump to content
TrinityCore

All Activity

This stream auto-updates     

  1. Yesterday
  2. You should set your focus on the fact you have TrinityCore rev. unknown 1970-01-01 00:00:00 +0000 in your log. It's quite useless to search the problems at the different SQL files. If you setup the files manually it's likely you will do it wrong. If your core is up to date and has a proper commit hash incl. timestamp you don't need to take care anymore for the sql update. Everything will be done automatically. Post your CMake log. I'm quite sure there is already a warning there.
  3. UPDATE: So, I completely redid everything, step by step until I reached the point where I got stuck before. The error is still present, the same as it was before. I did something new that let me learn something about the source of the error. I decided to listen to the error when it says "Please make sure you've executed all queries in the sql/updates folders." So what did I do? I executed all the files in the following folder: E:\TrinityCore\Trinity\sql\updates\world\3.3.5\*files here* This caused something interesting, the "world.updates_include" isn't the only thing not present. Everything related to world is just not there. Here is another similar error when launching one of the world files: "Table 'world.conditions' doesn't exist." At this point I'm not sure where to get these files, they just seem to be missing. Could I be using a different version of DB? I installed the 3.3.5 for both Trinity and TDB. Hopefully more information about this will help if anyone has ideas because at this point something important is missing that I don't know how to get. Additional info: I also tried launching "create_mysql"(whether is was wrong to or not, I seems like the wiki tells you to do this) and I got the following error: "Can't create database 'world': database exists" This confuses me because so much "doesn't exists".
  4. Last week
  5. Personally I think you should check why you have TrinityCore rev. unknown 1970-01-01 00:00:00 +0000 in your log. Normally there is a new timestamp and a commit hash. Maybe you made something different by pulling the git repository. Please read the wiki again. I don't know if this is the reason for your problems with the database. But at this point I don't have any more ideas, sorry.
  6. I didn't use a Repack, the Repack was a previous server I made. I following the instructions and link on the TrinityCore Wiki. This is the TrinityCore that I installed (Got link from https://trinitycore.atlassian.net/wiki/spaces/tc/pages/10977329/Windows+Core+Installation) https://github.com/TrinityCore/TrinityCore
  7. Repack is a very bad word here in this community. ;-) You have to take an original Trinity Core as descripted in the wiki. Nothing else, otherwise we can help you. TrinityCore rev. unknown 1970-01-01 00:00:00 +0000 shows that you have used a repack (or have done something else wrong) Or you have to ask the issuer of the repack what you have to do. TDB_full_world_335.64_2018_02_19.sql goes into the folder where your worldserver.exe is. But it works mostly only well together with original Trinity Core.
  8. Perhaps I missed something, I didn't do any 'setup' or installation of the TDB. Just placed the find with the worldserver and ran it. E:\TrinityCore\TrinityCore-3.3.5\sql\updates\world\3.3.5\ - There are a ton of world SQL files in here (This is the DB correct). Was I suppose to do something else with the "TDB_full_world_335.64_2018_02_19.sql" before running the worldserver? My apologies if I didn't understand your question correctly or I'm asking silly questions. I originally used Repacks to 'mod' WoW but I recently discovered the limitations so this is my first time getting and compiling a repack for myself.
  9. Yes, that's it. Is your world database still empty or was the inital setup from the TDB 335.64 successful ? Edit: 1146] Table 'world.updates_include' doesn't exist ( Ok, I think it's still empty ;-) )
  10. # # Updates.AutoSetup # Description: Auto populate empty databases. # Default: 1 - (Enabled) # 0 - (Disabled) Updates.AutoSetup = 1 Is this what you're referring to? By default this is already enabled.
  11. The crashlog is useless. This line show that you have made something wrong or didn't use original Trinity Core: TrinityCore rev. unknown 1970-01-01 00:00:00 +0000 As far as I remember you have to change in the worldserver.conf something that autopopulates an empty world database. Please recheck if it's on.
  12. Hello! I'm almost finished my TrinityCore setup but I've run into some issues with Databases and the installation. When I ran the worldserver it was able to create the Auth database and Character database without any issues but it gets stuck and displays the following error: [1146] Table 'world.updates_include' doesn't exist Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders. I've followed all the steps on the installation guide but I can't seem to get it to work. Things I've tried: I've reinstalled TrinityCore 3.3.5 Source and replace the *other Source folder with the new one. I installed the DB from here https://github.com/TrinityCore/TrinityCore/releases (TDB 335.64) - Is this not the correct DB? Deleting the DB that the worldserver created and letting it recreate the files (authserver works completely fine if that matters at all) I uploaded the most recent crash log (unknown_worldserver.exe[#].txt) and my server log to show what displays when I launch worldserver. (this doesn't display the error from above for some reason but just imagine that the error comes right after all the good stuff) I'm available to give more information if needed but I hope this is enough. Thanks to anyone who might find a solution to this mess, much appreciation. unknown_worldserver.exe_[21-6_15-35-49].txt Server.log RESOLVED I've managed to solve the issue and here is how: When you create a new SQL database (as I did) SQL server adds a world database preset inside. This makes the world server think that it already has a world database but looks inside to find some random junk. If you manage to make a clean/empty database then this issue shouldn't occur.
  13. I found 2 very simple solutions: Solution 1: Change the name back to TDB_full_world_335.63_2017_04_18.sql (or whatever you have started once with the custom project). Thanks to the magic of programming of this wonderful updater the updates are processed in the right order. The name of the full database is in revision_data.h.in.cmake . Solution 2 (not tested): Provide an own full world database file. As far as I have seen you need only to do all updates incl. custom updates into a clean database and than export it. Thanks to the table updates and its hashes the updater knows later what to do. (Additionally you may also need to save a starting file with the db structure of auth and characters at the beginning of a custom project. Depends of what kind of custom sql queries you have.)
  14. Good question. In the time back as I implemented the DB updater I thought about custom updates being compatible to the current database structure. Currently there is no possibility to prevent such conflicts that you described as part of your question.
  15. Hello, I don't understand how to use custom SQL queries in files in the /sql/custom/xxx folders in the right way. Here's an example of what I'm doing: In Juli 2017 I start a complete new project and use TDB_full_world_335.63_2017_04_18.sql and all the stuff from git repository at this date. I commit to whole stuff in my own git repository. In Aug. 2017 I made some database modifications, create therefore some custom SQL files. I let do the core an automatic update as usual. I commit the custom SQLs in my own git repository. I do regular updates of TC 3.3.5 branch and merge them in my repository. In the meantime databases and table change their structures by different TC updates. In Spring 2018 Trinity is providing a new TDB_full_world_335.64_2018_02_19.sql In June 2018 somebody else would like to start on another system a copy of our customized project. He's cloning the custom project from git repository and compiles it. At the updating process the core is asking for TDB_full_world_335.64_2018_02_19.sql After that (I guess) the core is applying outstanding TC updates and all the custom sql updates I made before. But how can I prevent possible database conflicts between my sql queries in the custom updates I made in Aug. 2017 with the database structure of Spring 2018 ?
  16. connection error (7.3)

    I am getting this same issue and tried everything as far as opening ports, turning off firewall, altering config wtf file in client to SET portal "127.0.0.1" and all other local ips and external ips and matched them at the same time to the server configs but still the same error code. Its driving me mad so any help please.
  17. hey not sure if worldserver problems go here but this is my from my crash folder https://pastebin.com/0GSJCdnu im stuck on this part https://trinitycore.atlassian.net/wiki/spaces/tc/pages/2130092/Databases+Installation starting worldserver for the first time, any pointers whats the problem plzz
  18. Discover SAI editor

    Hello TC community, I recently uninstalled my windows and I am using Discover SAI database editor for smart_scripts editing Before I used it without any troubles, but since the reinstallation of the windows I am getting this error wondering if you can help me solve it. I reinstalled MySQL couple of times, create different accounts, gave them permission and such. I am connecting to HeidiSQL without any problems if it matters. Thanks and keep the good work.
  19. Earlier
  20. Compile or cmake problems

    Client requirement was updated to 7.3.5.26822 yesterday.
  21. Compile or cmake problems

    hmm then when i run it again i'll check that out, but tell me another thing please if the current retail wow isn't 7.3.5.26654 like trinity master where is the best place to download client, yesterday i dl-ed from some private servers google drive but it wasnt compatible with trinity extractors
  22. Hello, can someone tell me how I can play legion on a LAN? I have the trinity server running without problems and from the server's PC if it allows me to log in but when all the friends of the network try to connect to the server it does not let them access, they all have put this in the WTF SET portal "172.16.5.32" which is the ip of my pc, using Wow-64_Patched patched with the tool of trinity but when they were to connect it puts this error in the client.
  23. [SOLVED]auth/worldserver.exe crashing

    --- 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 ---
  24. [SOLVED]auth/worldserver.exe crashing

    Oh Thank You so much For Replying, But the problem was not PTR, i miss some files in my "C;\build\bin\RelWithDebInfo" Folder. now it works just fine
  25. [SOLVED]auth/worldserver.exe crashing

    Hi im runing a trinity core (Master) for legion expantion, i set up evrything as the TrinityCore Tutalial asked me to do. thi is the link to tutarialhttps://trinitycore.atlassian.net/wiki/spaces/tc/pages/2130077/Installation+Guide
  26. Compile or cmake problems

    Hey Aokromes, I tried to make a fresh compile today, pulled trinity master to c:/trinity, dl-ed newest cmake specified that ⌃⌃ from the tutorial screenshot native compilers etc. and everythings working up until Visual studio builds it, I get this message and D:\Build\bin\RelWithDebInfo looks like this its missing bnetserver.exe bnetserver.pdb bnetserver.conf.dist bnetserver.cert.perm bnetserver.key.perm EDIT: this solved, had old boost installed
  1. Load more activity
×