search

ProjectSkyfire / SkyFire_548

SkyFireEMU is a full featured World of Warcraft: Mists of Pandaria emulator written in C++. || Compatible with World of Warcraft client 5.4.8 (Build: 18414) Project Established in 2011 || Support on Discord https://discord.gg/DnKZycD
http://www.projectskyfire.org
GNU General Public License v3.0
498 stars 421 forks source link

The worldserver does not start #1195

Closed sundeopanda111 closed 9 months ago

sundeopanda111 commented 9 months ago

hello, I'm new to technical things, I just wanted to try to start the Pandaria server, I'm trying to run the worldserver file, but it immediately turns off and such an error arrives in the log (I understand it's possible because of a recently added file on transmog) In mysql_stmt_prepare() id: 109, sql: "DELETE it FROM item_instance_transmog, set JOIN item_instance ii ON THE LEFT TO init.itemGuid = ii.guid, WHERE ii.owner_guid = ?" The table 'characters.item_instance_transmog' does not exist The database pool symbols are NOT open. There were errors when opening connection to MySQL. Check your SQLDriverLogFile for specific errors. Unable to connect to the symbol database 127.0.0.1;3306;skyfire;skyfire;characters

Nightprince commented 9 months ago

Import this sql in character DB:

https://github.com/ProjectSkyfire/SkyFire_548/blob/095121ecf334bcd40c854a8b4a32c225931723c0/sql/updates/characters/2024_02_12_23_12_characters.sql

sundeopanda111 commented 9 months ago

Thanks!!!!