Jump to content
TrinityCore

Search the Community

Showing results for tags 'unkown column'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • General
    • Releases and Announcements
  • Help and Support
    • Help and Support
  • Offtopic
    • Trinitycore.org Website issues
    • Chillout Room

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


AIM


MSN


Website URL


ICQ


Yahoo


Jabber


Skype


Location


Interests

Found 1 result

  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.
×
×
  • Create New...