I'm having difficulties running worldserver.exe but I can run authserver.exe just fine. Worldserver will run but after it displays its logo in the command console I receive the following error and then it shuts down:
In mysql_stmt_prepare() id: 3, sql: "SELECT entry, groupid, id, text, type, language, probability, emote, duration, sound, BroadcastTextID FROM creature_text"
Unknown column 'BroadcastTextID' in 'field list'
DatabasePool world NOT opened. There were errors opening the MySQL connections.
The error appears to relate to a SQL statement that worldserver.exe is trying to execute at startup. When I access the 'world' database and view the data in the creature_text table I don't see the 'BroadcastTextID' field. I did a fresh install of the database and received this error. So I deleted the auth, character, and world databases and attempted a second fresh install of the database using the script files provided with TrinityCore to create and populate the auth, character, and world databases. TDB_335.53_2014_03_29 was used to populate the world database.
I'm attempting to run this on a Windows based platform. All software necessary to run and compile TrinityCore was obtained according to the installation guidelines. I cleaned the solution files before compiling under Visual C++ 2013 Express and CMake 2.8 was used to prepare the solution files. I'm running MySQL 5.5.X and authserver has no issues connecting to the MySQL database.
Everything, including map extractions have worked flawlessly up to this point. Is there something I missed when compiling TrinityCore or is there a database update script that I need to run after I run the new install database files? I'm excited to get the server up and running so any help on how to resolve this is appreciated. Thank you!
TrinityCore rev. 762e10f76ba7 2014-04-22 19:54:58 -0400 (master branch) (Win32) (worldserver-daemon)
