Jump to content
TrinityCore
Sign in to follow this  
Elvis

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

Recommended Posts

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

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • By blkht
      The worldserver crashes whenever I create a character. Seems like there is an issue with mysql, but I have no idea what the issue is. Anybody knows what`s happening here?
       

    • By Link88
      I am developing on a Trinitycore based 5.4.8 core.
      We are exeperiencing multiple crash from different points.
      I have tried to found the point of failure of this crashes...
      I suspect that these crashes can be handled from a single point that corrects every GetGUID crashes.
      Here is the pastebin of the crashlogs.
      Thank you in advance
    • By lyrl
      Can't compress update packet (zlib: deflateInit) Error code: -4
    • By sebastianv3
      Hi!
      I have an up-to-date 6.x build that was working fine until I tried opening wow_64_patched.exe today, I got error #134:
      "Unable to open DBFilesClient\MovieOverlays.dbc: Can't find file in build manifest"
      Could this be related to the update to 6.2.2 that happened earlier today?
      I wanted to post this here in case it was some silly mistake I made before I put it on the issue tracker.
      Thanks!
×
×
  • Create New...