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

Okay, that clears the air of what DB to update. But that still leaves the 2 (TWO) directories. There are two sql update directories after a core compile and DB structuring. Should I update the ones in TrinitySource first then the ones in the TrinityDB? Another thing, why do I keep getting database errors whilst trying to update with these files? I swear we should either make a video tutorial, or have all required updates current with a fresh core compile. It would surely make this job a hell of a lot easier. I mean when you download a program, does it need updates? Not normally...

 

That clears the items as well and thanks for your quick response. I am using the merge updates file included within the folder only i copy it to the database fiolders I need and use it there too. Am I doing this wrong? Maybe the .bat file is not concatenating them in order, so objects in the database aren't getting put in at the right place and failing since there seems to be a lack of the index name it specifies in the next query?

Link to comment
Share on other sites

It would be nice to have the full world DB always updated, but you have to realize that we aren't dealing with a release quality or a commercial application. The developers aren't being paid to work on this, so things can and will be handled in a less than optimal way.

 

As for which world updates to run first, that's a tricky one to answer. Chances are, you would be better off to merge the 2 folders and then run all the updates. That way, you shouldn't have EventAI or creature AI changes being applied when those aspects were removed by an update. If I didn't have custom things in my world DB, I'd offer you an sql of what I'm running on. For the most part, the only "custom" things are some weapons that I made (items 133475-133480).

Link to comment
Share on other sites

So using merge_windows.bat will merge all files in time sequence order and will not throw errors? As a matter of fact after this I think maybe I will take that custom sql so I can edit items like the ones you have that are custom. Besides I just finished copying all world updates from both folders to one folder. And used the merge_windows.bat on them and it yielded a 11.5 MB file lol. I'm using Windows 7 Ultimate x64 SP1.

 

Edit: So I updated my DB after dropping world, and I created a new world DB. Used the trinity full file called, "TDB_full_434.05_2013_07_17" then I merged all updates in both updates folder using the merge_windows.bat file that came with it. Ran that sql file as a result of the bat and came up with this error. Where did my picture i pasted here go? WTF?!?!?!?!??!!?!?

Link to comment
Share on other sites

Yeah, it's not a small amount of data. The world DB I have, exported to sql and turned into a ZIP file, is 18MB in size. If you mainly wanted it to see about making custom items, you can get the sql files I posted on my pastebin. In that form, it might be easier to play with your own item ideas.

 

Assuming that you used the TDB 434.05 full release as your base, then you should be able to execute that 11.5MB file. You may find other sql files of interest on my pastebin, too.

Link to comment
Share on other sites

Unfortunately, I STILL cannot seem to get it to work without throwing an error doing JUST LIKE it said on the wiki. As confusing as it is anyhow. I have never tried following a tutorial and lost this much hair over this much static.I have gotten many different errors. Only ONCE was I able to make the server playable and it was mostly just a sandbox with nothing working properly. I would just like a working ENTIRE DB please. This shit is just way too complicated for my taste because of confusion with wording. If only I could do it myself, but since the instructions are as clear as need be I will never seem to get this.

Link to comment
Share on other sites

In mysql_stmt_prepare() id: 1, sql: "DELETE FROM linked_respawn WHERE guid = ?"
No database selected
In mysql_stmt_prepare() id: 2, sql: "REPLACE INTO linked_respawn (guid, linkedGuid) VALUES (?, ?)"
No database selected
In mysql_stmt_prepare() id: 6, sql: "DELETE FROM gameobject WHERE guid = ?"
No database selected
In mysql_stmt_prepare() id: 7, sql: "DELETE FROM game_event_gameobject WHERE guid = ?"
No database selected
In mysql_stmt_prepare() id: 8, sql: "INSERT INTO game_graveyard_zone (id, ghost_zone, faction) VALUES (?, ?, ?)"
No database selected
In mysql_stmt_prepare() id: 9, sql: "DELETE FROM game_graveyard_zone WHERE id = ? AND ghost_zone = ? AND faction = ?"
No database selected
In mysql_stmt_prepare() id: 10, sql: "INSERT INTO game_tele (id, position_x, position_y, position_z, orientation, map, name) VALUES (?, ?, ?, ?, ?, ?, ?)"
No database selected
In mysql_stmt_prepare() id: 11, sql: "DELETE FROM game_tele WHERE name = ?"
No database selected
In mysql_stmt_prepare() id: 12, sql: "INSERT INTO npc_vendor (entry, item, maxcount, incrtime, extendedcost) VALUES(?, ?, ?, ?, ?)"
No database selected
In mysql_stmt_prepare() id: 13, sql: "DELETE FROM npc_vendor WHERE entry = ? AND item = ?"
No database selected
In mysql_stmt_prepare() id: 15, sql: "UPDATE creature SET MovementType = ? WHERE guid = ?"
No database selected
In mysql_stmt_prepare() id: 16, sql: "UPDATE creature_template SET faction_A = ?, faction_H = ? WHERE entry = ?"
No database selected
In mysql_stmt_prepare() id: 17, sql: "UPDATE creature_template SET npcflag = ? WHERE entry = ?"
No database selected
In mysql_stmt_prepare() id: 18, sql: "UPDATE creature SET position_x = ?, position_y = ?, position_z = ?, orientation = ? WHERE guid = ?"
No database selected
In mysql_stmt_prepare() id: 19, sql: "UPDATE creature SET spawndist = ?, MovementType = ? WHERE guid = ?"
No database selected
In mysql_stmt_prepare() id: 20, sql: "UPDATE creature SET spawntimesecs = ? WHERE guid = ?"
No database selected
In mysql_stmt_prepare() id: 21, sql: "INSERT INTO creature_formations (leaderGUID, memberGUID, dist, angle, groupAI) VALUES (?, ?, ?, ?, ?)"
No database selected
In mysql_stmt_prepare() id: 22, sql: "INSERT INTO waypoint_data (id, point, position_x, position_y, position_z) VALUES (?, ?, ?, ?, ?)"
No database selected
In mysql_stmt_prepare() id: 23, sql: "DELETE FROM waypoint_data WHERE id = ? AND point = ?"
No database selected
In mysql_stmt_prepare() id: 24, sql: "UPDATE waypoint_data SET point = point - 1 WHERE id = ? AND point > ?"
No database selected
In mysql_stmt_prepare() id: 25, sql: "UPDATE waypoint_data SET position_x = ?, position_y = ?, position_z = ? where id = ? AND point = ?"
No database selected
In mysql_stmt_prepare() id: 26, sql: "UPDATE waypoint_data SET wpguid = ? WHERE id = ? and point = ?"
No database selected
In mysql_stmt_prepare() id: 27, sql: "UPDATE waypoint_data SET wpguid = 0"
No database selected
In mysql_stmt_prepare() id: 41, sql: "INSERT INTO creature_addon(guid, path_id) VALUES (?, ?)"
No database selected
In mysql_stmt_prepare() id: 40, sql: "UPDATE creature_addon SET path_id = ? WHERE guid = ?"
No database selected
In mysql_stmt_prepare() id: 42, sql: "DELETE FROM creature_addon WHERE guid = ?"
No database selected
In mysql_stmt_prepare() id: 44, sql: "INSERT INTO waypoint_scripts (guid) VALUES (?)"
No database selected
In mysql_stmt_prepare() id: 45, sql: "DELETE FROM waypoint_scripts WHERE guid = ?"
No database selected
In mysql_stmt_prepare() id: 46, sql: "UPDATE waypoint_scripts SET id = ? WHERE guid = ?"
No database selected
In mysql_stmt_prepare() id: 47, sql: "UPDATE waypoint_scripts SET x = ? WHERE guid = ?"
No database selected
In mysql_stmt_prepare() id: 48, sql: "UPDATE waypoint_scripts SET y = ? WHERE guid = ?"
No database selected
In mysql_stmt_prepare() id: 49, sql: "UPDATE waypoint_scripts SET z = ? WHERE guid = ?"
No database selected
In mysql_stmt_prepare() id: 50, sql: "UPDATE waypoint_scripts SET o = ? WHERE guid = ?"
No database selected
In mysql_stmt_prepare() id: 52, sql: "DELETE FROM creature WHERE guid = ?"
No database selected
In mysql_stmt_prepare() id: 61, sql: "INSERT INTO creature (guid, id , map, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, MovementType, npcflag, unit_flags, dynamicflags) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
No database selected
In mysql_stmt_prepare() id: 62, sql: "DELETE FROM game_event_creature WHERE guid = ?"
No database selected
In mysql_stmt_prepare() id: 63, sql: "DELETE FROM game_event_model_equip WHERE guid = ?"
No database selected
In mysql_stmt_prepare() id: 64, sql: "INSERT INTO gameobject (guid, id, map, spawnMask, phaseMask, position_x, position_y, position_z, orientation, rotation0, rotation1, rotation2, rotation3, spawntimesecs, animprogress, state) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
No database selected
In mysql_stmt_prepare() id: 66, sql: "INSERT INTO disables (entry, sourceType, flags, comment) VALUES (?, ?, ?, ?)"
No database selected
In mysql_stmt_prepare() id: 67, sql: "DELETE FROM disables WHERE entry = ? AND sourceType = ?"
No database selected
In mysql_stmt_prepare() id: 0, sql: "SELECT entry, pool_entry FROM pool_quest"
No database selected
In mysql_stmt_prepare() id: 3, sql: "SELECT entry, groupid, id, text, type, language, probability, emote, duration, sound FROM creature_text"
No database selected
In mysql_stmt_prepare() id: 4, sql: "SELECT entryorguid, source_type, id, link, event_type, event_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_x, target_y, target_z, target_o FROM smart_scripts ORDER BY entryorguid, source_type, id, link"
No database selected
In mysql_stmt_prepare() id: 5, sql: "SELECT entry, pointid, position_x, position_y, position_z FROM waypoints ORDER BY entry, pointid"
No database selected
In mysql_stmt_prepare() id: 14, sql: "SELECT item, maxcount, incrtime, ExtendedCost FROM npc_vendor WHERE entry = ? ORDER BY slot ASC"
No database selected
In mysql_stmt_prepare() id: 28, sql: "SELECT MAX(id) FROM waypoint_data"
No database selected
In mysql_stmt_prepare() id: 35, sql: "SELECT MAX(point) FROM waypoint_data WHERE id = ?"
No database selected
In mysql_stmt_prepare() id: 29, sql: "SELECT point, position_x, position_y, position_z, orientation, move_flag, delay, action, action_chance FROM waypoint_data WHERE id = ? ORDER BY point"
No database selected
In mysql_stmt_prepare() id: 30, sql: "SELECT point, position_x, position_y, position_z FROM waypoint_data WHERE id = ?"
No database selected
In mysql_stmt_prepare() id: 31, sql: "SELECT position_x, position_y, position_z FROM waypoint_data WHERE point = 1 AND id = ?"
No database selected
In mysql_stmt_prepare() id: 32, sql: "SELECT position_x, position_y, position_z, orientation FROM waypoint_data WHERE id = ? ORDER BY point DESC LIMIT 1"
No database selected
In mysql_stmt_prepare() id: 33, sql: "SELECT id, point FROM waypoint_data WHERE wpguid = ?"
No database selected
In mysql_stmt_prepare() id: 34, sql: "SELECT id, point, delay, move_flag, action, action_chance FROM waypoint_data WHERE wpguid = ?"
No database selected
In mysql_stmt_prepare() id: 36, sql: "SELECT id, point FROM waypoint_data WHERE (abs(position_x - ?) <= ?) and (abs(position_y - ?) <= ?) and (abs(position_z - ?) <= ?)"
No database selected
In mysql_stmt_prepare() id: 37, sql: "SELECT wpguid FROM waypoint_data WHERE id = ? and wpguid <> 0"
No database selected
In mysql_stmt_prepare() id: 38, sql: "SELECT DISTINCT action FROM waypoint_data"
No database selected
In mysql_stmt_prepare() id: 39, sql: "SELECT MAX(guid) FROM waypoint_scripts"
No database selected
In mysql_stmt_prepare() id: 43, sql: "SELECT guid FROM creature_addon WHERE guid = ?"
No database selected
In mysql_stmt_prepare() id: 51, sql: "SELECT id FROM waypoint_scripts WHERE guid = ?"
No database selected
In mysql_stmt_prepare() id: 53, sql: "SELECT name, permission, help FROM command"
No database selected
In mysql_stmt_prepare() id: 54, sql: "SELECT 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_A, faction_H, npcflag, speed_walk, speed_run, scale, rank, mindmg, maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime, rangeattacktime, unit_class, unit_flags, unit_flags2, dynamicflags, family, trainer_type, trainer_spell, trainer_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, 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, InhabitType, HoverHeight, Health_mod, Mana_mod, Armor_mod, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, mechanic_immune_mask, flags_extra, ScriptName FROM creature_template WHERE entry = ?"
No database selected
In mysql_stmt_prepare() id: 55, sql: "SELECT guid, delay, command, datalong, datalong2, dataint, x, y, z, o FROM waypoint_scripts WHERE id = ?"
No database selected
In mysql_stmt_prepare() id: 56, sql: "SELECT entry FROM item_template WHERE name = ?"
No database selected
In mysql_stmt_prepare() id: 57, sql: "SELECT guid FROM creature WHERE id = ?"
No database selected
In mysql_stmt_prepare() id: 58, sql: "SELECT guid, id, position_x, position_y, position_z, map, (POW(position_x - ?, 2) + POW(position_y - ?, 2) + POW(position_z - ?, 2)) AS order_ FROM gameobject WHERE map = ? AND (POW(position_x - ?, 2) + POW(position_y - ?, 2) + POW(position_z - ?, 2)) <= ? ORDER BY order_"
No database selected
In mysql_stmt_prepare() id: 59, sql: "SELECT guid, id, position_x, position_y, position_z, map, (POW(position_x - ?, 2) + POW(position_y - ?, 2) + POW(position_z - ?, 2)) AS order_ FROM creature WHERE map = ? AND (POW(position_x - ?, 2) + POW(position_y - ?, 2) + POW(position_z - ?, 2)) <= ? ORDER BY order_"
No database selected
In mysql_stmt_prepare() id: 65, sql: "SELECT entry FROM disables WHERE entry = ? AND sourceType = ?"
No database selected
In mysql_stmt_prepare() id: 68, sql: "SELECT xp_for_next_level FROM player_xp_for_level WHERE lvl = ?"
No database selected
Link to comment
Share on other sites

Thanks so much Kylroi. +rep if we do that here... Besides the custom weapons you added what other stuff has been added?

 

I seem to recall that I added someone's sql which populated a few empty zones. There's a bunch of mining nodes in Hyjal and Twilight Highlands that really shouldn't be there, but I forget what sql added them. I've added a couple vendor lists that were missing, some conditions for things that weren't added by anyone else, and even fixed up some of the fishing loot (defining some pools/areas that weren't already defined). For the most part, I tried to keep it blizzlike, but I don't have sniffs or an active retail account to compare everything. Also, most of the fixes that I've applied have been oriented for the Horde.

 

Most of the sql patches I used are also on my pastebin (except the one that populated the empty zones), if you want to see the stuff I personally added (from memory or research).

Link to comment
Share on other sites

One more thing. If you could do me a HUGE favor and go into BH 10 man or 25 man, kill all bosses and see if it gives you the achievement for BH not only bosses but BH raid. Because I got the achievements for Bosses killed, but once all 3 bosses are dead no achievement to be found for the raid itself. I am wondering not only why this is happening but how to fix it and implement it into the scripts or DB whichever is the reason for it not being finished.

Link to comment
Share on other sites

I could try it. I'm likely to get the same result, though. It will probably be a while (a day or so) before I can check, though. I recently noticed I needed to rerun the extractors. Everything seemed to be working fine, but the log was filling up with messages telling me to pay attention.

Link to comment
Share on other sites

Yeah, that is fine I noticed there is quite a few lengthy warnings in world server when it loads claiming things aren't where they need to be or not listed as functional. Not going to go into details or submit a log as it is the same info you get since we are using the same world DB. I just got me a DB editor and was going to go into Achievement ceriteria and Achievement Category and see if I can even see it listed there. Then work from there. If I get anywhere I'll give ya a copy of my work or tell you what I did to help you for a change.

Link to comment
Share on other sites

There's a huge amount of DB work to be done for both branches of Trinity. I believe there's more needed for 4.3.4, though. That's why there were some extras added for my world DB. In a private server for myself and my brother, I just haven't been motivated to get every minute detail ironed out.

 

As for the loads of errors during worldserver startup, that seems to be normal for everyone. I was getting a lot of them before I started doing anything of my own. One of the fixes I did was correct spawns that had "spawndist" set to 0 while the "MoveType" was set to 1. Essentially, that's a conflict and resulted in a stationary NPC. So, I used UPDATE to give them a radius ("spawndist" > 0) to move within. What I don't know is if those creature templates were from Trinity or the one sql that spawned some empty zones.

 

Of course, I'm of the opinion that we will never have a truly blizzlike server unless we obtain the genuine data from Blizzard. Same goes for the core. We'll get close, but it will never be perfect without having access to the real thing.

Link to comment
Share on other sites

Greetings fellow Azertohians,

 

so I took a 3 year break from server emulation and decided its time to get back into it. A lot has changed since I came back -- now we're using GIT instead of Googlecode or tortoiseSVN. The main issue I'm having is with the Trinitycore revision, I was reading on the Wiki that you must "revision match" the Trinitycore with the ALPHA DB 4.3.4. (Sync with TrinityCore/ff3524f). This is where I get confused, If I'm syncing the latest compile with revision ff3524f wont it be equivalent to using Trinitycore's sourcecode from 6 months ago? I've tried using the latest source code directly from Trinitycores 4.3.4 branch and I just get an error when trying to connect to the world using the latest TDB. I'm confused with the whole revision & database matching, if anyone could clear up the revision ff3524f and latest revision I'd really appreciate it, I thought the latest revision contained more up-to-date changes.

 

Thanks!

 

 

-Reppz

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...