Jump to content
TrinityCore

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


Apple
 Share

Recommended Posts

As simply put as I can list it:

  1. clone and compile latest core from branch 4.3.4
  2. create the databases as listed in the guide, but do NOT apply auth and characters updates
  3. import the Alpha TDB 434.05 but do not start the servers yet
  4. copy the world updates from the TDB and TC 4.3.4 repositories to a common directory and merge them (to have them applied in, hopefully, correct order)
  5. assuming step 4 succeeded, you should now be clear to fire up authserver and worldserver

I suggest the merging of the world updates before combining them is because certain tables have changed at times. In theory, the combined updates will work without errors. The auth and characters updates shouldn't be needed for new installs.

Link to comment
Share on other sites

As simply put as I can list it:

  1. clone and compile latest core from branch 4.3.4
  2. create the databases as listed in the guide, but do NOT apply auth and characters updates
  3. import the Alpha TDB 434.05 but do not start the servers yet
  4. copy the world updates from the TDB and TC 4.3.4 repositories to a common directory and merge them (to have them applied in, hopefully, correct order)
  5. assuming step 4 succeeded, you should now be clear to fire up authserver and worldserver

I suggest the merging of the world updates before combining them is because certain tables have changed at times. In theory, the combined updates will work without errors. The auth and characters updates shouldn't be needed for new installs.

And following point 4 you will delete random things that you don't must delete.

Thanks a lot! Just dragged all of the updates and merged them together, imported all of them with only a few errors. Only one issue I'm having now -- once I'm in-game and I try to talk nothing happens, something with an Opcode for CMSG/SMSG?

No defined handler for opcode [CMSG_QUERY_BATTLEFIELD_STATE 0x7202 (29186)] sent by [Player: Reppz (Guid: 1, Account: 1)]
No defined handler for opcode [CMSG_GUILD_SET_ACHIEVEMENT_TRACKING 0x1027 (4135)] sent by [Player: Reppz (Guid: 1, Account: 1)]
No defined handler for opcode [CMSG_REQUEST_CEMETERY_LIST 0x720A (29194)] sent by [Player: Reppz (Guid: 1, Account: 1)]
Prevented sending disabled opcode [SMSG_GM_MESSAGECHAT 0x6434 (25652)] to [Player: Reppz (Guid: 1, Account: 1)]

Thanks for the help <3

Edited by reppz
Link to comment
Share on other sites

And following point 4 you will delete random things that you don't must delete.

 

That's likely why there have been requests for a TDB 434.06 that is more up to date. It may be easier to merely copy the appropriate updates to the TDB repository, so there's only 1 set of updates to apply. The world updates from 2 locations are where a lot of people seem to run into trouble.

 

 

Thanks a lot! Just dragged all of the updates and merged them together, imported all of them with only a few errors. Only one issue I'm having now -- once I'm in-game and I try to talk nothing happens, something with an Opcode for CMSG/SMSG?

No defined handler for opcode [CMSG_QUERY_BATTLEFIELD_STATE 0x7202 (29186)] sent by [Player: Reppz (Guid: 1, Account: 1)]
No defined handler for opcode [CMSG_GUILD_SET_ACHIEVEMENT_TRACKING 0x1027 (4135)] sent by [Player: Reppz (Guid: 1, Account: 1)]
No defined handler for opcode [CMSG_REQUEST_CEMETERY_LIST 0x720A (29194)] sent by [Player: Reppz (Guid: 1, Account: 1)]
Prevented sending disabled opcode [SMSG_GM_MESSAGECHAT 0x6434 (25652)] to [Player: Reppz (Guid: 1, Account: 1)]

Thanks for the help <3

 

No interaction sounds like an unpatched client. Were you able to log out or did you have to terminate the client process? If you see something about being a possible cheater, that's a sure sign of the client needing to be patched.

 

Also, there are a lot of currently unimplemented opcodes, so the ones you pasted are nothing new or game breaking. Certain functionality will be missing, though.

Link to comment
Share on other sites

That's likely why there have been requests for a TDB 434.06 that is more up to date. It may be easier to merely copy the appropriate updates to the TDB repository, so there's only 1 set of updates to apply. The world updates from 2 locations are where a lot of people seem to run into trouble.

 

 

 

No interaction sounds like an unpatched client. Were you able to log out or did you have to terminate the client process? If you see something about being a possible cheater, that's a sure sign of the client needing to be patched.

 

Also, there are a lot of currently unimplemented opcodes, so the ones you pasted are nothing new or game breaking. Certain functionality will be missing, though.

 I'm able to log in and out fine, I'm able to do anything apart from type in commands or talk, I can use emotes though. I just tried it with two other clients and the same issue. Originally I had a fresh client that I used to extract all of the maps/vmaps and DBC files from, so I'm not sure if that could be affecting anything. 

Link to comment
Share on other sites

 I'm able to log in and out fine, I'm able to do anything apart from type in commands or talk, I can use emotes though. I just tried it with two other clients and the same issue. Originally I had a fresh client that I used to extract all of the maps/vmaps and DBC files from, so I'm not sure if that could be affecting anything. 

 

Ok, so it isn't an interaction problem. I misunderstood the problem you were describing, I guess.

 

Anyway, I have noticed an issue with the new chat processing code. No GM commands show anything in the chat window, but the commands perform their action. Even a simple ".help" results in nothing being displayed. I hadn't even thought to try a normal "/say" or similar. Whispers may be broken, from what you're saying. All I can say is that code is being merged from the master branch that isn't 100% operational in the 4.3.4 branch. We may have to give these guys some time to iron out the issues.

Link to comment
Share on other sites

That's likely why there have been requests for a TDB 434.06 that is more up to date. It may be easier to merely copy the appropriate updates to the TDB repository, so there's only 1 set of updates to apply. The world updates from 2 locations are where a lot of people seem to run into trouble.

4.3.4 branch is for development and people knowing what to do, no for random people trying to build private servers.

  • Upvote 2
Link to comment
Share on other sites

4.3.4 branch is for development and people knowing what to do, no for random people trying to build private servers.

 

Luckily, for the most part, that makes me qualified. Although, it sort of is a private server (for 2 players only) that I mess with. We shall really see if I "know what to do" after my current recompile (assuming the yellow ? is still missing from quest givers).

Link to comment
Share on other sites

4.3.4 branch is for development and people knowing what to do, no for random people trying to build private servers.

 

This doesn't make sense to me. I could understand if there was a 434 guide and people couldn't follow it but keeping the process a secret does nothing good for the project.

 

There are probably people who would contribute if they could get a server running but not being able to do so should not automatically negate their ability to help.

  • Upvote 1
Link to comment
Share on other sites

This doesn't make sense to me. I could understand if there was a 434 guide and people couldn't follow it but keeping the process a secret does nothing good for the project.

 

There are probably people who would contribute if they could get a server running but not being able to do so should not automatically negate their ability to help.

 

In theory, if they were capable of contributing to the project, they would also be able to take the guide (such as it is) and get a server running. In my opinion (possibly shared by many others), the inability to set up a working server is a fairly solid indication that contributions are unlikely to come from that individual.

 

C++, even plain C, is much harder than running sql files in the appropriate order. Or, for that matter, following the steps in a guide for proper installation of support libraries, obtaining the core source, and compiling it.

Link to comment
Share on other sites

 

When I loaded your world.sql I got this:

 

[1054] Unknown column 'attackpower' in 'field list'
Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.
 
Revision error maybe?

 

 

Referring to my world.sql? Which core are you running? What's the revision?

Link to comment
Share on other sites

Thanks a lot! Just dragged all of the updates and merged them together, imported all of them with only a few errors. Only one issue I'm having now -- once I'm in-game and I try to talk nothing happens, something with an Opcode for CMSG/SMSG?

Congrats, for sure you deleted cata only spawns on your database, or added scripts to incorrect mobs.

This doesn't make sense to me. I could understand if there was a 434 guide and people couldn't follow it but keeping the process a secret does nothing good for the project.

 

There are probably people who would contribute if they could get a server running but not being able to do so should not automatically negate their ability to help.

 

Secret? what secret, it's the same way as 3.3.5a, but when using them on 4.3.4 branch needs to check the guids. Also, there is a guide, but people ignores it and tries to update the server to head, when it's stated to stay on 14d80d2

In theory, if they were capable of contributing to the project, they would also be able to take the guide (such as it is) and get a server running. In my opinion (possibly shared by many others), the inability to set up a working server is a fairly solid indication that contributions are unlikely to come from that individual.

 

C++, even plain C, is much harder than running sql files in the appropriate order. Or, for that matter, following the steps in a guide for proper installation of support libraries, obtaining the core source, and compiling it.

Totally agree, people unable to run updated core are very likely unable to contribute, because running sql without knowledge can mean they will report un-existing bugs (for example, people unable to speak few months ago).

Link to comment
Share on other sites

not to make things bigger, but to take side of newbies and MrSmite

 


when it's stated to stay on 14d80d2

actually the guide says:

 

...look at the top of that list, you should see something like "Sync with TrinityCore/TrinityCore@14d80d2". Does the string after the "@" symbol match your server version? If yes, GREAT! If no, see Revision Matching below.

 

"something like" doesn't mean "stay on" and in that page you can find "sync with TrinityCore/ff3524f"

 

people who could help the project can be also people who just test their own server and find errors like what beta testers do.

if they wanted to make a server just to play, why not just join one of those free working servers that can be found online?

 

just my two cents

Link to comment
Share on other sites

In fact TDB 4.3.4 instalation guide have:

 

Because the TDB 4.3.4 is not always updated, usually you cannot use latest core revision:

If the last sync commit in the TDB 4.3.4 repository is "Sync with TrinityCore/12345example" in the core repository you have to execute

git checkout 12345example

And again 4.3.4 is NOT intended for newbies, it's for developers with knowledge of what they are doing, not to make private servers.

Link to comment
Share on other sites

TrinityCore ff3524f, and 14d80d2, and the newest pull. All three errored out with world.sql.

 

Well, try this:

  1. shutdown worldserver (assuming it was running)
  2. recreate world DB with the world.sql (because having run worldserver will effect this next step)
  3. load sql client (i.e. HeidiSQL) and check the version table in the world DB
  4. check TC and TDB 434 commits and execute any updates since that revision
  5. relaunch worldserver
Link to comment
Share on other sites

I think it's disingenuous to say that people who can't get a server running probably have nothing to contribute. There just might be people out there that are C++ developers who don't know SQL.

 

Those people may stumble on TrinityCore some day and be interested in contributing to the 434 repo. Unfortunately none of their PRs would be accepted because they can't be tested if the person doesn't understand how to get the server running.

 

This project would do itself a favor if people weren't so easily tossed into the idiot bin.

 

PS:

 

By "secret", I was referring to past forum postings where people asked for a better guide and the answer was along the lines of: "it's a development branch, figure it out".

Link to comment
Share on other sites

I think it's disingenuous to say that people who can't get a server running probably have nothing to contribute. There just might be people out there that are C++ developers who don't know SQL.

 

So, what you're saying is that SQL is trickier than C++? I have to disagree. I may have to refresh my memory on certain syntax for SQL, but there are aspects of C++ that make me scratch my head (and a web search doesn't help clear it up). Can I program? You bet I can, but I'd written C applications that some people just "knew" were written in C++ because of how they operated.

 

The point is, if they cannot type in very simple web searches to make sense of SQL error messages or even correct a syntax error, there is an extremely low chance that they would be capable of offering acceptable C++ code. That isn't to say those users are stupid, they are just not capable of being useful beyond trouble reports (aka issue tickets).

 

Let's equate C++ to a jet (or commercial pilot) and SQL as a car (having a driver's license). If someone can only drive a car, would you want them flying a passenger jet? Not without a license, I bet. However, a licensed pilot would almost certainly be capable of driving a car, too. Would you really trust a pilot that couldn't drive a car?

Link to comment
Share on other sites

So, what you're saying is that SQL is trickier than C++? I have to disagree.

No, I didn't say that at all. However, there are some people who can program C++ who don't understand SQL and vice versa. They are two different technologies and proficiency in one does not require proficiency in the other.

 

The point is, if they cannot type in very simple web searches to make sense of SQL error messages or even correct a syntax error, there is an extremely low chance that they would be capable of offering acceptable C++ code. That isn't to say those users are stupid, they are just not capable of being useful beyond trouble reports (aka issue tickets).

The inability to decipher SQL errors is irrelevant to the potential quality of C++ contributions.

 

Let's equate C++ to a jet (or commercial pilot) and SQL as a car (having a driver's license). If someone can only drive a car, would you want them flying a passenger jet? Not without a license, I bet.

This is irrelevant since a person can't fly a passenger jet legally without a pilot's license, however a person who doesn't know SQL can still program C++.

 

However, a licensed pilot would almost certainly be capable of driving a car, too. Would you really trust a pilot that couldn't drive a car?

That's like not trusting a cruise ship captain because he can't pilot a submarine. It's irrelevant anyway since a pilot (in the US) is required to have a valid driver's license.

 

The whole point of my post was simple: Just because a person is terrible at A, doesn't mean they're terrible at B. For example: A person who can't read a map might still be a good driver. To discount people simply because of a preconceived notion that they must have all skills for any skills to be valuable is not very productive.

There are already standards to weed out people who program poorly. Not being able to get the server running shouldn't be an added roadblock.

Link to comment
Share on other sites

Reading a map and driving are completely different concepts. I certainly wouldn't trust that driver on a trip, anyway. This project is NOT a matter of a trip around the block. The scale of this project is more like a cross country trip that uses back roads only. Nobody is going to hold their hand and type the code for them. If so, it's not their code but the other person's code.

Link to comment
Share on other sites

Reading a map and driving are completely different concepts. I certainly wouldn't trust that driver on a trip, anyway. This project is NOT a matter of a trip around the block. The scale of this project is more like a cross country trip that uses back roads only. Nobody is going to hold their hand and type the code for them. If so, it's not their code but the other person's code.

 

Reading a map and driving are not completely different concepts, one is a tool to make the other easier. The inability to use the tool doesn't completely negate the ability to perform the task.

 

Anyway, SQL and C++ are two different languages. Lack of knowledge in one does not automatically mean lack of knowledge in the other.

 

Regardless, I can render the entire argument invalid because even I have trouble getting a 434 server running yet I seem quite capable of providing code patches.

 

PS:

 

Honestly, which do you think is better for TrinityCore:

  • Option 1
    • User: I have a patch to fix pets falling off boats but I can't get my 434 server running to test it
    • Community: Oh well, if you can't get your server running your patch is probably worthless
  • Option 2
    • User: I have a patch to fix pets falling off boats but I can't get my 434 server running to test it
    • Community: We'd love to have a patch for that, let's help you get your server running

 

The fact that 434 is in "alpha" is irrelevant. Open source projects are always in a state of development.

Link to comment
Share on other sites

Reading a map is not a tool specifically for driving. Maps are used for many other things, too. The 2 concepts are simply separate with neither requiring the other to be of use. They may work together, but that's it. With your logic, then you and anyone else unable to get the 4.3.4 server really have no business altering the code and expecting it to be accepted into the project. The Internet is a tool (just like your map argument), and that means anyone with half a brain can use that tool to figure out how easy SQL is understand.

 

So, you code C++. Are you good enough that code you wrote has been added to the core? Or is that why you're so upset with anyone that says "if you can't set up your own server, you don't need to submit code"? Personally, I find Option 1 to be more appropriate. You may not like to have that said (over and over), but the main developers have enough going on that they don't need to have tons of patches that need MAJOR work for them to be useful in the core.

 

A repack developer claims to be someone who is awesome in programming ability. They even claim to only do things the correct way, but I pointed out the incorrect operation of several things in their repack (most of which was something they added, too). The reason those same changes weren't added to Trinity is because they were so blatantly not correctly done. Community supported projects are not required to accept every submission. Those in control of the project have the right to reject anything they find undesirable. That contributor is free to fork the project and apply their own fixes, but not free to attack someone because they rejected your submission (for any reason).

Link to comment
Share on other sites

...and for sure someone who can't compile C++ and cannot understand SQL properly can point out that if you do that action in that place in that circumstance can cause a crash, that maybe is caused by a simple mistake made by someone who can compile C++ and understand SQL, but didn't check is job carefully.

I still think that if someone wants to play wow, would just register at one of those free private servers online and not spend time on making his private server and play with, let's say 4? 5? friends and meet the chance to get struck in a not working quest or bad/not scripted area.

Link to comment
Share on other sites

 Share

  • Recently Browsing   0 members

    No registered users viewing this page.


  • Similar Content

    • By xgamerninjax
      Hello all, first time posting here and it's really got me scratching my head.
      I've compiled everything on my own computer, and then transferred everything to a host computer so the server can stay live. The server was running fine for a month or so and then suddenly it just crashes when it hits "Loading C++ scripts", exiting saying "caught signal 22"
      I tried setting up the host computer from scratch and transferred everything over fresh and it's still happening for some reason. (Note, I can run the server perfectly on my personal pc where I compiled it.)
      Any help would be greatly appreciated, thanks!
      3d7e3a40e2b3+_worldserver.exe_[1-4_15-19-45].dmp 3d7e3a40e2b3+_worldserver.exe_[1-4_15-19-45].txt
    • By Rochet2
      A lot of people have asked how to debug so I made this short guide on how to set up debugging.
      This guide only tells you how to actually set up debugging in TrinityCore on Windows and Linux.
      This will not explain the basics of debugging. You can google those or play around with the debugger to learn.
      Here are a few videos that explain how to actually debug after setting debugging up on visual studio: https://youtu.be/0ebzPwixrJA and linux: https://www.youtube.com/watch?v=sCtY--xRUyI

      This guide contains multiple guides. Each list of bullet points is it's own guide.
      Make sure you can run the server normally before trying to debug.

      Windows:
      On Windows before anything you should check these
      - Before debugging or making crashlogs etc. with Visual Studio you must compile the core in "Debug" instead of "Release". You can select this in "Build>Configuration Manager" or at the top of Visual Studio window http://i.imgur.com/5oHd59j.png
      - You also need to move the new pdb files generate by compiling in debug mode on Visual Studio from the compile output folder (bin) to your server folder - these files contain information needed for debugging.
      - It is assumed that Solution Explorer is open. Open it by selecting "View>Solution Explorer" in Visual Studio http://i.imgur.com/hkW6Gk0.png
      -- You may want to click on the Home icon to reset the view on Solution Explorer http://i.imgur.com/N8UPwDh.png
      - You can place breakpoints in Visual Studio editor by right clicking a line of code and selecting "Breakpoint>Insert Breakpoint" http://i.imgur.com/L2TxBVG.png
      - At the top of the window you should see controls for stepping and continuing when you have started to debug.
      - Here is a video showing the basic Visual Studio functionality https://www.youtube.com/watch?v=Ijdk4z8-2OI
      Fastest way to debug on windows. This is the easiest way to start up debugging a script.
      - Start the authserver and worldserver normally
      - Open TrinityCore.sln in Visual Studio. This is what you usually open when you want to compile the core
      - In Visual Studio at the top select "Debug>Attach to process...>worldserver.exe" and click "Attach" http://i.imgur.com/jDEI2Hq.png
      - You are now debugging
       
      The second slower way of debugging on windows. This is useful for debugging something that occurs in the startup of the server.
      - Open TrinityCore.sln in Visual Studio. This is what you usually open when you want to compile the core
      - In solution explorer right click on worldserver and select "Set as StartUp Project" http://i.imgur.com/wvMzeRA.png
      - In solution explorer right click on worldserver and select "Properties" http://i.imgur.com/rTNEF9O.png
      -- In Properties you should go to "Configuration Properties>Debugging" and edit "Working Directory" to point to the server folder. For me this is the default compile folder so I use "$(OutDir)" http://i.imgur.com/aRI29fB.png
      - Start the authserver normally
      - Start the worldserver by selecting "Debug>Start Debugging". The server will start with debugging attached from the beginning http://i.imgur.com/cg1KJNw.png
      - You are now debugging
      Crashlogs on windows. Once you have a way to reproduce a crash you can get a crashlog that can help you resolve it.
      - After compiling the core in "Debug" instead of "Release" start up the worldserver and authserver
      - Reproduce the crash you have
      - In the server folder there is now a folder called Crashes that contains txt and dmp files. http://i.imgur.com/9eQIdql.png
      - You can open the txt files in text editors http://i.imgur.com/EH6R17E.png
      -- At the top of a txt file there is some information about your system and below it there is the Call Stack and below that there are Variables of each part of the call stack
      -- The Call Stack will tell you at the top what was the last function call before crashing and what function calls led to that function call.
      -- Next to the function names there is the file that the function is defined in and the line number the code was executing in that function.
      -- In the Variables section you can inspect variables that were present at each function call.
      -- Based on this information you are often able to see what crashed or get a better view of what you need to inspect more in your code.
      - The dmp file can be opened in Visual Studio
      -- Open TrinityCore.sln in Visual Studio. This is what you usually open when you want to compile the core
      -- Drag and drop the dmp file to Visual Studio
      -- In the window that opens click to "Debug with Native Only" http://i.imgur.com/OgyU2kM.png
      -- In the window popup click "Break" http://i.imgur.com/4jDzqRn.png
      -- You are now in a state like you would have hit a break point in the code or a crash while debugging. You can inspect the call stack and the variables.
      Edit and continue on windows. When debugging this allows you to change the code and without restarting the server apply those changes so they actually work ingame.
      - Open TrinityCore.sln in Visual Studio. This is what you usually open when you want to compile the core
      - In solution explorer right click on worldserver and select "Properties" http://i.imgur.com/rTNEF9O.png
      -- In Properties select "Configuration Properties>Linker>General" and set "Enable Incremental Linking" to "Yes". http://i.imgur.com/caQqwN5.png
      -- In Properties select "Configuration Properties>Linker>Advanced" and set "Image Has Safe Exception Handlers" to "No". http://i.imgur.com/FYzN8Ks.png
      -- In Properties select "Configuration Properties>C/C++>General" and set "Debug Information Format" to "Program Database for Edit And Continue". http://i.imgur.com/pxQ6I8N.png
      - At the top of the window select "Tools>Options". In the Options select "Debugging>General" and in there select "Enable Edit and Continue", "Enable Native Edit and Continue" and "Require source files to exactly match the original version".
      - Compile the server for the changes to take effect.
      - Set up "The second slower way of debugging" (I did not test edit and continue on other configurations)
      - Start the authserver normally
      - Start the worldserver by selecting "Debug>Start Debugging".
      - Try edit a cpp file a little and save it.
      - At top of Visual Studio window select "Debug>Apply Code Changes" and wait until the changes are applied. Warning: it can take considerable amount of time for the changes to be applied. http://i.imgur.com/77pb58E.png
      - If you have issues, be sure to check the error messages in Output. You can view it by selecting "View>Output" http://i.imgur.com/4cIznW9.png
      - This guide was written based on https://msdn.microsoft.com/en-us/library/esaeyddf.aspx and https://blogs.msdn.microsoft.com/vcblog/2015/07/22/c-edit-and-continue-in-visual-studio-2015/
      Linux:
      First we need to compile the server in debug mode.
      - Compile the server with the cmake flag -DCMAKE_BUILD_TYPE=Debug

      Debugging on linux. You can debug on linux by using GDB.
      - Here is a good video about it: https://www.youtube.com/watch?v=sCtY--xRUyI
      - Basically you
      -- Start the authserver
      -- Start the worldserver by using "gdb ./worldserver"
      -- Enter breakpoints by using break command on gdb
      -- Use the run command on gdb to start the server
      -- You are now debugging
      - You may also be interested in using VScode or some other more visual debuggers. https://www.youtube.com/watch?v=B0xTgyCwsAo
      Crashlogs on linux. Once you have a way to reproduce a crash you can get a crashlog that can help you resolve it.
      - Take crashreport.gdb from /contrib/debugger from source folder and place it to your server folder
      - Start the authserver
      - Start the worldserver by using "gdb -x crashreport.gdb ./worldserver"
      - Reproduce your crash
      - There should be a backtrace.log in your server folder that contains information about the crash like the callstack and variables in each function call in the call stack
      - This guide was written based on https://github.com/TrinityCore/TrinityCore/blob/master/contrib/debugger/README
      Running valgrind on linux. This helps you find memory errors like invalid reads and writes and memory leaks.
      - Here is a good video about it: https://www.youtube.com/watch?v=fvTsFjDuag8
      - Basically you
      -- Start the authserver
      -- Start the worldserver by using "valgrind ./worldserver"
      -- Run your code that you want to analyze and close the server
      -- The console or an output log should contain the valgrind log
    • By reyne
      Hey there!

      I've followed a few threads here about map extraction, and am still having issues. Originally, I was having the issue described here.
      After following the advice given in that thread (creating characters of both BC races and running around for a bit), I am no longer getting that error, however now I get the following error while trying to extract maps:

      `Error loading World\Maps\Expansion01\Expansion01_42_6.adt`

      This repeats for every line in Expansion01, and then the extractor crashes.

      I'm not sure where else to go from here.

      Thanks for your help

      Edit: I've created an 85 on an i85 server and flown all around Outland now, same issue.
    • By Uee
      I recently found the Trinity Cataclsym Preservation Project and thought I will try it out.
      I am already running 3.3.5a and Master - both server run great
      Pulled 4.3.4 down using Git and built it same way as others:
      boost_1_73_0 cmake 3.17.2 Mysql 5.7.30 VS Community 2019 Built fine - no issue. Used 'Extractor.bat' to run all the map extractors - worked great!
      Noticed there was extra file 'connection_patcher.exe`, ran that - worked great! Now have "wow_patched" and use this to launch client
      MySQL runs in standalone mode, -initialize, added base sql files, imported, auth and character sql files
      Configured both the .conf files and passwords, IPs etc are all in place.
      Note: When loading the exe and built conf file, bnetserver complain about these items missing, so I add them:
      Updates.AutoSetup = 1 Updates.EnableDatabases = 0 LoginDatabase.SynchThreads = 1 Load up Mysql - loads fine
      Load up bnetserver and appears to load ok - last few lines look like this:
      Connected to MySQL database at 127.0.0.1
      DatabasePool 'auth' opened successfully. 2 total connections running.
      Started auth database connection pool.
      Listening on connections from worldservers on port 1118...
      Load up worldserver and it adds the FULL world and hotfixes, then applied all updates (confirmed archived in SQL) - last few lines look like this:
      Calculate next monthly quest reset time...
      Calculate random battleground reset time...
      Calculate guild limitation(s) reset time...
      Calculate next currency reset time...
      World initialized in 0 minutes 13 seconds
      TrinityCore rev. d0c7bbab40bc 2020-05-06 00:01:21 +0200 (master branch) (Win64, RelWithDebInfo, Static) (worldserver-daemon) ready...
       
      There are no db errors in logs.
      Config.wtf contain portal, realmlist as remote server and patchlist as localhost.
      When I try to connecting using "user@local" and password I get immediately disconnected.
      What I did noticed different is that the bnetserver doesnt add "Added realm "Battle for Azeroth" at 192.168.10.213:8085." (From my Master log) 
      3.3.5a also have this line as last line in authserver - but 4.3.4 is not giving me this one.
      Realmlist table is accurate with right information.
      Anyone know why bnetserver is not starting me realm?
       
    • By Deer_Hunter
      Hello all,
      I just updated from the latest Git 
      Trinity Core REV. ac6baa547376 + 2020-02-21  3.3.5 Branch.
      I'm getting this error after crash.
      Problem signature:
        Problem Event Name:    APPCRASH
        Application Name:    worldserver.exe
        Application Version:    0.0.0.0
        Application Timestamp:    5e50a462
        Fault Module Name:    StackHash_f12f
        Fault Module Version:    6.3.9600.19629
        Fault Module Timestamp:    5e2fdc0d
        Exception Code:    c0000374
        Exception Offset:    PCH_9E_FROM_ntdll+0x0000000000090D0A
        OS Version:    6.3.9600.2.0.0.272.7
        Locale ID:    1033
        Additional Information 1:    f12f
        Additional Information 2:    f12f0934d3e965f73c68e60f20f2cd40
        Additional Information 3:    7595
        Additional Information 4:    7595e4d8d703db9dcd3d2f6ea540e357
      the exception code says its a Heap error,  I'm not sure how to troubleshoot this.
      Thanks
×
×
  • Create New...