Jump to content
TrinityCore

Elvis

Plebs
  • Posts

    1
  • Joined

  • Last visited

Posts posted by Elvis

  1. when i excute worldserver.exe after config and import the database, the app crash and print the error log: ERROR 1054 (42S22) at line 21: Unknown column 'OptionID' in 'field list'.

    my configuration is like this:

    when i create the database, "my create_mysql.sql" is as follows:

     

    GRANT USAGE ON * . * TO 'root'@'localhost' IDENTIFIED BY '123456' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ;

    CREATE DATABASE `world` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

    CREATE DATABASE `characters` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

    CREATE DATABASE `auth` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

    GRANT ALL PRIVILEGES ON `world` . * TO 'root'@'localhost' WITH GRANT OPTION;

    GRANT ALL PRIVILEGES ON `characters` . * TO 'root'@'localhost' WITH GRANT OPTION;

    GRANT ALL PRIVILEGES ON `auth` . * TO 'root'@'localhost' WITH GRANT OPTION;

     

    the authserver.conf is as follows:

    LoginDatabaseInfo = "127.0.0.1;3306;root;123456;auth"

     

    the worldserver.conf is as follows:

    LoginDatabaseInfo     = "127.0.0.1;3306;root;123456;auth"
    WorldDatabaseInfo     = "127.0.0.1;3306;root;123456;world"
    CharacterDatabaseInfo = "127.0.0.1;3306;root;123456;characters"

     

    in the code, the red word 'root' is 'trinity' originally, the red word '123456' is also 'trinity' originally.

    and  after i excute the worldserver.exe,  the app print error log ang crash.

    the results of worldserver.exe and authserver.exe is shown in the picture.
     

    world.jpg

    auth.jpg

×
×
  • Create New...