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.
[ATTACH]2444._xfImport[/ATTACH]
[ATTACH]2445._xfImport[/ATTACH]