Jump to content
Why are these forums read only? ×
TrinityCore
Why are these forums read only?

112958

Members
 View Profile  See their activity

  • Posts

    19

  • Joined

  • Last visited

 Content Type 

Posts posted by 112958

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

    in Help and Support

    Posted · Edited by 112958

    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!

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

    in Help and Support

    Posted · Edited by 112958

    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 :(

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

    in Help and Support

    Posted · Edited by 112958

    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 !

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

    in Help and Support

    Posted · Edited by 112958

    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

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

    in Help and Support

    Posted

    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? 

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

    in Help and Support

    Posted · Edited by 112958

    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 :-)

×
×
  • Create New...