Worldserver.exe Crashing (with logs)

[Vatallus]

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

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

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

 

[Mr. Satan]

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

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

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

What all did you change to set up the server? OR did you change nothing and just download and play?
Seems like something was changed incorrectly in either the worldserver.conf or the DB.

 

[Vatallus]

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.

 

[ExO]

Try to re download the _Server folder from the repack thread and see if it helps it, first of all.