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

Hello guys,: http://collab.kpsn.org/display/tc/Database_master is the website i'm using.

 

the problem i have is: I dont understand what to do, 

 

i'm using HeidiSQL.

 

can someone tell me Step by Step what to do, cus i cant put the 3 databases in HeidiSQL

 

Read the website that i linked, and please tell me step by step what to do, like this:

 

Step 1 open HeidiSQL, Step 2 Go to file. etc 

 

Thanks all :-)

Edited by 112958
Link to comment
Share on other sites

go to /sql/create in your source.

open create_mysql.sql in heidi and run it.

go to /sql/base in your source.

(Dummy note, you select a DB by clicking on it on the left so it has a green check mark on it)

open auth_database.sql and run it to auth DB

open characters_database.sql and run it to characters DB

Open heidi, select world database, close heidi.

Go to http://www.trinitycore.org/f/files/ and download the latest TDB.

Note that the latest is at the BOTTOM (this may change?) Be sure to look at the version numbers for what is latest.

Open the zip you downloaded and run the TDB_full_xxxxxxxxxx.sql

When attempting to run the file, its too large and you are prompted with a window to choose to load the file to the editor or run directly.

Since we earlier chose world DB, it should be open by default, so we can choose run directly. The file will be run to world DB.

go to /sql/updates/world in your source

create a new bat file (a text file with .bat file extension) and write this into it:

copy *.sql mrg.sql

Run the bat (double click it)

Run the newly created mrg.sql in the same folder to your world DB.

If prompted for too large file again, just click to run directly since we still have world DB as default as mentioned above.

Set up the configs and you are good to go .. I guess.

Correct me if I am wrong. I wrote this from memory, but I think it went right.

Link to comment
Share on other sites

Hey, thanks for answering but it still wont work :<

 

This is what i see after i open Create_mysql in heidi: http://i41.tinypic.com/2d8gmpu.png

 

or is it just me that is doing someting wrong :s

You need to connect to your database..

Make a new connection and insert your IP (if mysql is on the same computer, use 127.0.0.1 or localhost) and the acc and pass.

Should be pretty straight forward ..

I believe it is also instructed so in program window ..

Seems to me like you never even tried to make the DB in the first place, which would be a sad thing.

 

You dont need to keep the source up to date when you just made it ..

And you need the database to run the server, cant skip that.

Link to comment
Share on other sites

Well i tryed that, and got this error: SQL fout (2003) in statement #0: Can't connect to MySQL server on '127.0.01' (10061)

 

and Ye its my first time doing this ever, so i dont rly know how to use everyting didnt know about the DB etc :<

 

i hope you know whats wrong this time :)

Link to comment
Share on other sites

Wait ok i got everyting exept this: create a new bat file (a text file with .bat file extension) and write this into it:

copy *.sql mrg.sql
Run the bat (double click it)
Run the newly created mrg.sql in the same folder to your world DB.
If prompted for too large file again, just click to run directly since we still have world DB as default as mentioned above.

 

Can you explain that a little detailed in dummy steps? 

Link to comment
Share on other sites

Got that, but now the next step :

 

SETTING UP THE SERVER

Now that you have the source compiled you need to extract some necessary files.

Extractors

Trinity requires dbc and map files. It is optional but highly recommended to also extract vmaps, which enable Line-of-Sight rules (casting through walls, etc) and Sanctuary areas (like Dalaran). Another option, which is still experimental and in progress, are mmaps, which enable correct npc pathings (through walkways instead of walls).

WARNING: Use ONLY Trinity's extractors. Others are NOT supported.

If you use extractors from other projects it is almost certain that your TrinityCore will not recognize the extracted data! There is one way in which you can obtain the extractors. If you compiled them while installing CMake, you already have them in your D:BuildbinRelease folder.

Extracting DBC/Maps/VMaps/MMaps

1. Browse into your D:BuildbinRelease folder and copy these files into your root World of Warcraft folder (where the Wow.exe is located):

mapextractor.exe
mmaps_generator.exe
vmap4extractor.exe
vmap4assembler.exe
makevmaps_simple.bat

 

I miss those Mapextractor.exe mmaps_generator.exe etc 

 

The only thing in my map is :

 

Ace.dll

authserver.conf.dist

authserver

libeay33.dl

libmysql.dll

ssleay32.dll

worldserver.conf.dist

worldserver

 

Where do i get those progams cus i didnt get them when i installed the Cmake

Edited by 112958
Link to comment
Share on other sites

You need to start up cmake

Then when you originally set the paths and clicked configure you got the check list.

It should be visible by default now if you configured once already. Check the box for tools.

Configure, Generate, Compile the core and the tools will be in your compilation directory.

Link to comment
Share on other sites

Ah i found them now but they areint in the bin/release map, but they are in the built map. Thanks :)


3. Move the dbc and maps folders to the D:BuildbinRelease folder.

 

What Dbc and maps folders does 'he' mean by this? cus ive Dbc file's in map_extractor map4_extractor etc. or do i need to get a Dbc an maps folders in my World of warcraft map where the Wow.exe is?

 

Dummy steps if possible please :)

 

 

Thanks for all your help so far !

Edited by 112958
Link to comment
Share on other sites

Hmm, what you do is you move the extractors, for example mapextractor.exe to your wow folder, where the wow.exe is and then start the extractor.

Let it do it's job and after it is finished, you should have folders named maps and dbc in the same folder. Then move those to the server folder where trinitycore.exe is.

 

The other extractors you should also move to the wow directory like the mapextractor. But instead of running them, you should create a bat, like you did before, with the instructed contents:

vmap4extractor.exe
md vmaps
vmap4assembler.exe Buildings vmaps 
pause

And then run it. The bat should be saved to the wow installation directory where the extactors and wow.exe is.

 

NOTE that it is said that you should run wow at least once before extracting anything.

~Said someone somewhere at some time. Very very trusted source :3

Link to comment
Share on other sites

Those are not exes. As you should clearly see from the program type.

I suggest you set windows to show known file extensions.

 

Btw .. what folder do you refer to with built map?

The extractors should all be in binDebug or binRelease (depending on which you chose to compile as)

as long as you chose to compile the tools in cmake like I instructed and (re) compiled your core.

Link to comment
Share on other sites

Found everyting after i reinstalled the whole thing=p

 

last question atleast i hope:

 

5. Move the vmaps folder to the same directory as dbcmaps and the TrinityCore binaries. so do i need to put them in : /build/bin/release And in (C:) / Trinity ??

Link to comment
Share on other sites

You won't need 2 copies of those folders unless you simply want to have the extra space wasted. If C:Trinity is where you intend to have the servers executed from, just move those folders over as subfolders (i.e. C:Trinitydbc). Assuming that you simply renamed the .conf.dist files to just .conf, you should be set to go.

Link to comment
Share on other sites

Aww got it :)   worldserver.conf

Scroll down to the LoginDatabaseInfo, WorldDatabaseInfo, and CharacterDatabaseInfo config options and enter MySQL Server login information for the server to be able to connect to your database.

On a newly compiled config, you should have the following values:

LoginDatabaseInfo = "127.0.0.1;3306;trinity;trinity;auth"

WorldDatabaseInfo = "127.0.0.1;3306;trinity;trinity;world"

CharacterDatabaseInfo = "127.0.0.1;3306;trinity;trinity;characters"

It follows this structure:

Variablename = "MySQLIP;Port;Loginname;Password;database"

 

The following settings must be verified:

  • The hostname (127.0.0.1) can stay the same if Trinity is being installed on the same computer that you run WoW on.

    Otherwise, follow the instruction in Realmlist Table if this is not the case. 

  • The port (3306) is the standard configured value. Depending on your settings, you must change it accordingly.
  • The username and password can be variable. You can choose to either:
    • Run on your root password you used when you installed MySQL Server Community Edition(e.g. 'root':'password'), which is strongly not recommend if the server is somehow public.
    • create an unique login within a User Manager within your prefered database management tool (commonly identified by an icon that looks like a person or people) and give it necessary permissions (SELECT, INSERT, UPDATE, DELETE permissions are sufficient, and is much safer).
  • All other default options should be sufficient, but it is recommended that you take some time after your server is finished to read through the configs and see all the ways to customize your server.

 

i dont understand what to do here can someone explain it to me in dummy steps :(

Edited by 112958
Link to comment
Share on other sites

The config files are for example:

worldserver.conf.dist

You need to remove the .dist extension before you can use the config with your server.

Then you should add the DB connection info:

 

Basically you insert the same login info you did to heidisql.

And also provide the database names, which should be correct already if you used the SQL file to create the databases and did not make your own or rename the base databases created by the SQL.

Atm you can ignore all the complicated guidance since its your first time and you wont be going live likely, and hopefully..

 

But anyways, the guide tells you that you should not use the main SQL account for the server to DB connections.

The main SQL account has access to everything, which is why if someone finds an exploit etc, he may be able to modify permissions etc in DB.

So you should, if the server shows on the net, create a new SQL user that has less permissions and set it to the configs.

 

 

Try finding a text block in the config file that looks like:

LoginDatabaseInfo = "127.0.0.1;3306;trinity;trinity;auth"
WorldDatabaseInfo = "127.0.0.1;3306;trinity;trinity;world"
CharacterDatabaseInfo = "127.0.0.1;3306;trinity;trinity;characters"
Link to comment
Share on other sites

Oki i did all this. but now when i want to open my Authserver + Worldserver they close in 0.1 sec i cant read what is wrong D: someone of you guys know this problem? did i do someting wrong in my DB ?

 

Nvm found the problem


Everyting works, Thanks for all your help guys! 

 

if i find another problem i hope i can count on u guys :>

 

Thx and have a great day!

Edited by 112958
Link to comment
Share on other sites

First of all I want to say I thank you all at Trinitycore for your time and investments in knowledge to help some of us newbies out and create and implement a structure we all can try our best to cope with.

 

Now on to my questions.

 

Yesterday, I installed and ran my first 4.3.4 Compile about four times, all without constant success. The fourth and final time following a video I found on youtube was able to get the worldserver to not crash upon open. All by database updates. and NONE of the folders I updated from didn't throw an error and stop my DB SQL from running. Now, one question I have is the order in which and what updates should be applied to the DB for a fresh compile current core and all.

 

I know I have done 3.3.5a in the past several times and was successful getting even transmog, playerbots, custom items and custom objects working by myself using google and researching wowhead and things.

But 4.3.4 Cataclysm seems to be a little trickier. None of the items I see in vendors are in my DB (At least where they used to be at.) but show up in vendor list as items available...

 

When making a new server with current and latest core is it too much to ask after you fellas did all this extra work to make the server functional and this far into the project to not have ANY updates on a fresh compile? Or to make it just a little more descriptive on what to update and how and what DB also for a fresh compile?

 

I am pulling my hair out here and all I wanted to do is help and accomplish things so that I too can contribute what I already know about the game and maybe even do somesort of sniffing for you devs. Funny thing about that is even using a sniffing tool has a vague description on how to use it for yourself even. So to be honest I think maybe it is time for one of you advanced members to make some sort of tutorials on how to accomplish some if not all of these tasks to help this community. Lack of motivation/support is why projects end up dead.

 

But once again, I thank whoever is responsible for making this project what it is already and it is awesome! I just think it can be improved more and if I knew my stuff I would be the first person to stand up and make a guide to help others make this a strong and productive project/community.

Link to comment
Share on other sites

With 4.3.4, item_template is used only as a supplementary source. The core will use the dbc/db2 files to define items. There is also a worldserver.conf setting to enforce the data file definitions or allow the DB to override them ('DBC.EnforceItemAttributes = 1' is in the worldserver.conf.dist).

 

As for the SQL updates, ignore auth and characters updates, but apply all of the world updates (in order).

Link to comment
Share on other sites

Hello,

I am on the most current version of trinity TrinityCore-a60ba24

with OS win 8.1. and on server 2008 r2

 

When starting the world server i get this error

 

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

 

Now i figured what is said is the issue, but i ran literally everysingle one in order the issue continues.

 

Any idea?

Thanks!

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