error 1054 Excute worldserver.exe in windows pring the error log:"ERROR 1054 (42S22) at line 21: Unknown column 'OptionID' in 'field list'" and then crash

[Elvis]

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.
 

[Aokromes]

On 3/18/2019 at 6:25 PM, Elvis said:

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.
 

 

 

enable autoupdater and leave core to do the job, if you don't want download latest TDB for master branch and apply every sql on updates directories.