[Archive] Worldserver.exe Crashing (with logs)
[Archive] Worldserver.exe Crashing (with logs)
Original source
i have pretty much everything set up. the authserver.exe will launch and stay running, but when i start the worldserver.exe it launches and then crashes. i have looked through most of the support forum and haven't found a fix for my issue. here's the log from the worldserver.exe
Code:
Using configuration file worldserver.conf.
Using SSL version: OpenSSL 1.0.1u 22 Sep 2016 (library: OpenSSL 1.0.1h 5 Jun 2014)
Using ACE version: 6.1.4
EmuZealotNW ver. 0000-00-00 00:00:00 +0000 (Archived) (Win32, RelWithDebInfo) (worldserver-daemon)
<Ctrl-C> to stop.
Starting up EmuCoach Repack - v7 - VIP, powered by Trinity & Zealot
Support, Updates & Information can get found at - www.emucoach.com
EmuCoach Repack V.7 - PAID VERSION - Deathwings Madness
EmuCoach - World of Warcraft Emulation Forum
DatabasePool emucoach-world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
Cannot connect to world database 127.0.0.1;3306;root;Weeman12;emucoach-world
and heres the DBError logs
Code:
ERROR In mysql_stmt_prepare() id: 56, sql: "SELECT difficulty_entry_1, difficulty_entry_2, difficulty_entry_3, KillCredit1, KillCredit2, modelid1, modelid2, modelid3, modelid4, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, exp, faction_A, faction_H, npcflag, speed_walk, speed_run, speed_swim, speed_fly, scale, rank, mindmg, maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime, rangeattacktime, unit_class, unit_flags, unit_flags2, dynamicflags, family, trainer_type, trainer_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, type, type_flags, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, spell5, spell6, spell7, spell8, PetSpellDataId, VehicleId, mingold, maxgold, AIName, MovementType, InhabitType, HoverHeight, Health_mod, Mana_mod, Mana_mod_extra, Armor_mod, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, equipment_id, mechanic_immune_mask, flags_extra, ScriptName FROM creature_template WHERE entry = ?"
ERROR You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', mindmg, maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime, rangea' at line 1
rektbyfaith
11-04-2025, 05:13 PM #1Archived author: Vatallus • Posted: 2025-11-04T18:13:31.087788
Original source
i have pretty much everything set up. the authserver.exe will launch and stay running, but when i start the worldserver.exe it launches and then crashes. i have looked through most of the support forum and haven't found a fix for my issue. here's the log from the worldserver.exe
Code:
Using configuration file worldserver.conf.
Using SSL version: OpenSSL 1.0.1u 22 Sep 2016 (library: OpenSSL 1.0.1h 5 Jun 2014)
Using ACE version: 6.1.4
EmuZealotNW ver. 0000-00-00 00:00:00 +0000 (Archived) (Win32, RelWithDebInfo) (worldserver-daemon)
<Ctrl-C> to stop.
Starting up EmuCoach Repack - v7 - VIP, powered by Trinity & Zealot
Support, Updates & Information can get found at - www.emucoach.com
EmuCoach Repack V.7 - PAID VERSION - Deathwings Madness
EmuCoach - World of Warcraft Emulation Forum
DatabasePool emucoach-world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
Cannot connect to world database 127.0.0.1;3306;root;Weeman12;emucoach-world
and heres the DBError logs
Code:
ERROR In mysql_stmt_prepare() id: 56, sql: "SELECT difficulty_entry_1, difficulty_entry_2, difficulty_entry_3, KillCredit1, KillCredit2, modelid1, modelid2, modelid3, modelid4, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, exp, faction_A, faction_H, npcflag, speed_walk, speed_run, speed_swim, speed_fly, scale, rank, mindmg, maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime, rangeattacktime, unit_class, unit_flags, unit_flags2, dynamicflags, family, trainer_type, trainer_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, type, type_flags, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, spell5, spell6, spell7, spell8, PetSpellDataId, VehicleId, mingold, maxgold, AIName, MovementType, InhabitType, HoverHeight, Health_mod, Mana_mod, Mana_mod_extra, Armor_mod, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, equipment_id, mechanic_immune_mask, flags_extra, ScriptName FROM creature_template WHERE entry = ?"
ERROR You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', mindmg, maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime, rangea' at line 1
Original source
Quote:Vatallus said:What all did you change to set up the server? OR did you change nothing and just download and play?
i have pretty much everything set up. the authserver.exe will launch and stay running, but when i start the worldserver.exe it launches and then crashes. i have looked through most of the support forum and haven't found a fix for my issue. here's the log from the worldserver.exe
Code:
Using configuration file worldserver.conf.
Using SSL version: OpenSSL 1.0.1u 22 Sep 2016 (library: OpenSSL 1.0.1h 5 Jun 2014)
Using ACE version: 6.1.4
EmuZealotNW ver. 0000-00-00 00:00:00 +0000 (Archived) (Win32, RelWithDebInfo) (worldserver-daemon)
<Ctrl-C> to stop.
Starting up EmuCoach Repack - v7 - VIP, powered by Trinity & Zealot
Support, Updates & Information can get found at - www.emucoach.com
EmuCoach Repack V.7 - PAID VERSION - Deathwings Madness
EmuCoach - World of Warcraft Emulation Forum
DatabasePool emucoach-world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
Cannot connect to world database 127.0.0.1;3306;root;Weeman12;emucoach-world
and heres the DBError logs
Code:
ERROR In mysql_stmt_prepare() id: 56, sql: "SELECT difficulty_entry_1, difficulty_entry_2, difficulty_entry_3, KillCredit1, KillCredit2, modelid1, modelid2, modelid3, modelid4, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, exp, faction_A, faction_H, npcflag, speed_walk, speed_run, speed_swim, speed_fly, scale, rank, mindmg, maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime, rangeattacktime, unit_class, unit_flags, unit_flags2, dynamicflags, family, trainer_type, trainer_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, type, type_flags, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, spell5, spell6, spell7, spell8, PetSpellDataId, VehicleId, mingold, maxgold, AIName, MovementType, InhabitType, HoverHeight, Health_mod, Mana_mod, Mana_mod_extra, Armor_mod, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, equipment_id, mechanic_immune_mask, flags_extra, ScriptName FROM creature_template WHERE entry = ?"
ERROR You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', mindmg, maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime, rangea' at line 1
Click to expand...
Seems like something was changed incorrectly in either the worldserver.conf or the DB.
rektbyfaith
11-04-2025, 05:13 PM #2Archived author: Vatallus • Posted: 2025-11-04T18:13:31.087788
Original source
Quote:Vatallus said:What all did you change to set up the server? OR did you change nothing and just download and play?
i have pretty much everything set up. the authserver.exe will launch and stay running, but when i start the worldserver.exe it launches and then crashes. i have looked through most of the support forum and haven't found a fix for my issue. here's the log from the worldserver.exe
Code:
Using configuration file worldserver.conf.
Using SSL version: OpenSSL 1.0.1u 22 Sep 2016 (library: OpenSSL 1.0.1h 5 Jun 2014)
Using ACE version: 6.1.4
EmuZealotNW ver. 0000-00-00 00:00:00 +0000 (Archived) (Win32, RelWithDebInfo) (worldserver-daemon)
<Ctrl-C> to stop.
Starting up EmuCoach Repack - v7 - VIP, powered by Trinity & Zealot
Support, Updates & Information can get found at - www.emucoach.com
EmuCoach Repack V.7 - PAID VERSION - Deathwings Madness
EmuCoach - World of Warcraft Emulation Forum
DatabasePool emucoach-world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
Cannot connect to world database 127.0.0.1;3306;root;Weeman12;emucoach-world
and heres the DBError logs
Code:
ERROR In mysql_stmt_prepare() id: 56, sql: "SELECT difficulty_entry_1, difficulty_entry_2, difficulty_entry_3, KillCredit1, KillCredit2, modelid1, modelid2, modelid3, modelid4, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, exp, faction_A, faction_H, npcflag, speed_walk, speed_run, speed_swim, speed_fly, scale, rank, mindmg, maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime, rangeattacktime, unit_class, unit_flags, unit_flags2, dynamicflags, family, trainer_type, trainer_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, type, type_flags, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, spell5, spell6, spell7, spell8, PetSpellDataId, VehicleId, mingold, maxgold, AIName, MovementType, InhabitType, HoverHeight, Health_mod, Mana_mod, Mana_mod_extra, Armor_mod, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, equipment_id, mechanic_immune_mask, flags_extra, ScriptName FROM creature_template WHERE entry = ?"
ERROR You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', mindmg, maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime, rangea' at line 1
Click to expand...
Seems like something was changed incorrectly in either the worldserver.conf or the DB.
Original source
i didnt change anything but the password in the config, the database is a MySQL 8.0 server due to me running anything server off of it, havnt had this issue with any other game server i have been hosting.
rektbyfaith
11-04-2025, 05:13 PM #3Archived author: Vatallus • Posted: 2025-11-04T18:13:31.087788
Original source
i didnt change anything but the password in the config, the database is a MySQL 8.0 server due to me running anything server off of it, havnt had this issue with any other game server i have been hosting.
Original source
Try to re download the _Server folder from the repack thread and see if it helps it, first of all.
![[Image: 1f642.png]](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
rektbyfaith
11-04-2025, 05:13 PM #4Archived author: Vatallus • Posted: 2025-11-04T18:13:31.087788
Original source
Try to re download the _Server folder from the repack thread and see if it helps it, first of all.
1 Guest(s)
1 Guest(s)