Jump to content
TrinityCore

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
 Share

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

Link to comment
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.

Link to comment
Share on other sites

 Share

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • By Lenzork
      Hey everyone!
      I've starting with scripting on a Trinitycore Server and now i'm facing a little bit of a Problem. I've created a custom boss and sometimes when you attack the boss, the whole server crashes and sometimes it doesn't - other than that he works completely fine. So it's just the Problem, that sometimes the Server crashes on pulling him. So i think it has something to do with the Initialize i believe?
      The Boss is on a custom instance map.
      This is my first Boss script so i'm sorry when it's a bit messy.
      Open the Spoiler for more Informations and the Script of the Boss:

    • By xgamerninjax
      Hello all, first time posting here and it's really got me scratching my head.
      I've compiled everything on my own computer, and then transferred everything to a host computer so the server can stay live. The server was running fine for a month or so and then suddenly it just crashes when it hits "Loading C++ scripts", exiting saying "caught signal 22"
      I tried setting up the host computer from scratch and transferred everything over fresh and it's still happening for some reason. (Note, I can run the server perfectly on my personal pc where I compiled it.)
      Any help would be greatly appreciated, thanks!
      3d7e3a40e2b3+_worldserver.exe_[1-4_15-19-45].dmp 3d7e3a40e2b3+_worldserver.exe_[1-4_15-19-45].txt
    • By Deer_Hunter
      Hello all,
      I just updated from the latest Git 
      Trinity Core REV. ac6baa547376 + 2020-02-21  3.3.5 Branch.
      I'm getting this error after crash.
      Problem signature:
        Problem Event Name:    APPCRASH
        Application Name:    worldserver.exe
        Application Version:    0.0.0.0
        Application Timestamp:    5e50a462
        Fault Module Name:    StackHash_f12f
        Fault Module Version:    6.3.9600.19629
        Fault Module Timestamp:    5e2fdc0d
        Exception Code:    c0000374
        Exception Offset:    PCH_9E_FROM_ntdll+0x0000000000090D0A
        OS Version:    6.3.9600.2.0.0.272.7
        Locale ID:    1033
        Additional Information 1:    f12f
        Additional Information 2:    f12f0934d3e965f73c68e60f20f2cd40
        Additional Information 3:    7595
        Additional Information 4:    7595e4d8d703db9dcd3d2f6ea540e357
      the exception code says its a Heap error,  I'm not sure how to troubleshoot this.
      Thanks
    • 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
×
×
  • Create New...