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

calebalex999

Members
 View Profile  See their activity

  • Posts

    37

  • Joined

  • Last visited

  • Days Won

    2

 Content Type 

Posts posted by calebalex999

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

    in Help and Support

    Posted

    It's that hard to see 75 pages thread called " "unknown column" "missing table" error / sql problems / SQLDriverLogFile "?

    Hello there, you must be a moderator right?, i not know why my 4.3.4 server not detects the 4.3.4 world database, one week before now, i was do a 4.3.4 server, and works, now i tried to made a new one and worldserver.exe not read world database, the old one 4.3.4 server who i did authserver.exe and worldserver.exe works fine, i need your help with this, grettings.

     

    sorry my english.

  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 calebalex999

    You are obviously doing something wrong with the updates.

     

    And you are comparing apples to oranges. A 335a repack and 434 source is no where near the same thing. So actually.. that's like comparing apples to rocks.

     

    My advice to you is, just play on a friends 434 server and ask for GM access. But I do agree on your topic title which states "noob".

     

    You not understands me, sorry for the word, I have compiled a 4.3.4 server, from the beginning, with git extensions, then with cmake, for later use visual studio 2012, create a release of 4.3.4, create dbc, maps and vmaps files for make the server works, do not use the branch "master" i use the branch " 4.3.4 ".

     

    I have problems with make work a 4.3.4 server, i do all steps and worldserver.exe crashes that is my problem with the emulator, is with the world database updates, I want to know what and how to obtain them.

     

    I made the dumb mistake of removing my 4.3.4 server.

     

    Grettings!

     

    Sorry for my english.

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

    in Help and Support

    Posted · Edited by calebalex999

    "You say", Authserver connects and that you connected before to a 4.3.4 worldserver?

    It looks like you didn't run updates which makes me think you haven't ran worldserver, not to mention the wrong password in your DB or your .conf setting, but still..

    Trying to run TC without updates gives you "cannot connect", because your DB is outdated so it's trying to find tables or DBs that don't exist.

    So... my conclusion is

    1.) You have never ran a True TC 4.3.4 worldserver, or

    2.) you really really busted your TDB (again).

     

    Yes i made a 4.3.4 server, the first point is configure authserver.conf with user and password of your mysql server, second is configure worldserver.conf with the same data for auth world and characters, next and first run authserver.exe, next worldserver, but it crash because not finds world database, i follow the guide:

     

    http://collab.kpsn.org/pages/viewpage.action?pageId=1704351

     

    Do all steps, like download the latest TDB_full_434.05_2013_07_17.sql and create the world_updates.sql, in the world dababase loads the TDB_full_434.05_2013_07_17.sql and next by the world_updates.sql and runs again the authserver.exe and works, next runs the worldserver, white paper of death!

     

     

    Using configuration file worldserver.conf.

    Using SSL version: OpenSSL 1.0.1f 6 Jan 2014 (library: OpenSSL 1.0.1f 6 Jan 2014)

    Using ACE version: 6.1.4

    TrinityCore rev. 5454e10b52c6 2014-04-11 23:12:12 +0200 (4.3.4 branch) (Win32, Release) (worldserver-daemon)

    <Ctrl-C> to stop.

     ______                       __

    /__  _       __          __/ __

    /_/ / _ __ /_    ___ /_ , _  __  __

       /`'__/ /' _ `/ / / /

        / / / _ _

         _ _  _ _ _ _ __/`____

          /_//_/   /_//_//_//_//__/ `/___/>

                                     C O R E  /___/

    DatabasePool world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.

    Cannot connect to world database 127.0.0.1;3306;root;root;world

     

    In this time, im playing my 3.3.5a repack, compiled with visual c++ 2012.

     

    this is a image of my full working 3.3.5a repack

    post-18035-0-85870500-1397267565_thumb.j

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

    in Help and Support

    Posted

    Hello, i have a very big problem with worldserver.exe from the 4.3.4 version, in another day i made a working 4.3.4 server, but yesterday i tried to make it again but the worldserver.exe chased, whit this message:

     

    Using configuration file worldserver.conf.
    Using SSL version: OpenSSL 1.0.1f 6 Jan 2014 (library: OpenSSL 1.0.1f 6 Jan 2014)
    Using ACE version: 6.1.4
    TrinityCore rev. 5454e10b52c6 2014-04-11 23:12:12 +0200 (4.3.4 branch) (Win32, Release) (worldserver-daemon)
    <Ctrl-C> to stop.

     ______                       __
    /__  _       __          __/ __
    /_/ / _ __ /_    ___ /_ , _  __  __
       /`'__/ /' _ `/ / / /
        / / / _ _
         _ _  _ _ _ _ __/`____
          /_//_/   /_//_//_//_//__/ `/___/>
                                     C O R E  /___/


    DatabasePool world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
    Cannot connect to world database 127.0.0.1;3306;root;root;world

     

    Authserver works fine, detects the auth database, its means there is not firewall blocking on the mysql server.

     

    With my 3.3.5 repack the 3 databases works fine, what i need to do, grettings!

     

     

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

    in Help and Support

    Posted

    I tried to compile a new 4.3.4 server, and authserver,exe works fine but.

     

    worldserver.exe crashed with this message:

     

    Using configuration file worldserver.conf.
    Using SSL version: OpenSSL 1.0.1f 6 Jan 2014 (library: OpenSSL 1.0.1f 6 Jan 2014)
    Using ACE version: 6.1.4
    TrinityCore rev. 4e59d0b92287 2014-04-09 22:03:28 +0200 (4.3.4 branch) (Win32, Release) (worldserver-daemon)
    <Ctrl-C> to stop.

     ______                       __
    /__  _       __          __/ __
    /_/ / _ __ /_    ___ /_ , _  __  __
       /`'__/ /' _ `/ / / /
        / / / _ _
         _ _  _ _ _ _ __/`____
          /_//_/   /_//_//_//_//__/ `/___/>
                                     C O R E  /___/


    DatabasePool world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
    Cannot connect to world database 127.0.0.1;3306;trinity;trinity;world

     

    Thie guide says this:

     

     

    What is this code, who i can use it:

     

    git pull --rebase origin

     

    This a sql code, i dont understand?

    Updating

    1. Update DB repository.

      git pull --rebase origin
    2. Import the SQL update files from updates directory that are new since last update.
      • That means you should take note of the last SQL you imported each batch of updates
    3. If a new full DB has been released, you got two options:
      • Drop world database and import full new DB
      • Import the new SQL files in updates and old/updates_xx.

     

    I put auth, characters and world in the SQL server, with 3.3.5a, works fine, no errors.

     

    I put auth, characters and world in the SQL server, with 4.3.4, and white script of death, dont detects world database.

     

     

    World database i was used are:

     

    TDB_full_434.05_2013_07_17.sql

    world_updates.sql.

     

    Please, help, why i do wrong?

     

     

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

    in Help and Support

    Posted

    Hello friends, today i tried to make work the worldserver.exe but, happen this:

     

    Using configuration file worldserver.conf.
    Using SSL version: OpenSSL 1.0.1e 11 Feb 2013 (library: OpenSSL 1.0.1e 11 Feb 2013)
    Using ACE version: 6.1.4
    TrinityCore rev. 3611d82e628c 2013-09-23 22:58:29 +0200 (4.3.4 branch) (Win32, Release) (worldserver-daemon)
    <Ctrl-C> to stop.

     ______                       __
    /__  _       __          __/ __
    /_/ / _ __ /_    ___ /_ , _  __  __
       /`'__/ /' _ `/ / / /
        / / / _ _
         _ _  _ _ _ _ __/`____
          /_//_/   /_//_//_//_//__/ `/___/>
                                     C O R E  /___/


    In mysql_stmt_prepare() id: 55, sql: "SELECT name, permission, help FROM command"
    Unknown column 'permission' in 'field list'
    DatabasePool world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
    Cannot connect to world database 127.0.0.1;3306;root;ascend;world

     

     

    Is strange, all database are correct but the worldserver.exe don´t open the world table of sql, what is the problem with it.

     

    I use MySQL 5.5.34

     

    In older compilations who i made everything works fine, please help with this problem, Excuse my English, I speak Spanish, but I can read English very well. so I hope your answers, greetings friends.

     

×
×
  • Create New...