Azerothcore-wotlk: Worldserver.exe world database issues

[docxkillborn]

SMALL DESCRIPTION:

Fresh compile, no problems with auth only worldserver world database issue

CURRENT BEHAVIOUR:

F:\azerothcore-server>worldserver.exe
Using configuration file worldserver.conf.
Using SSL version: OpenSSL 1.1.1a 20 Nov 2018 (library: OpenSSL 1.1.1a 20 Nov 2018)
Using ACE version: 6.3.2
AzerothCore rev. 37d9ef012608 2019-02-05 19:55:00 +0100 (master branch) (Win64, Release) (worldserver-daemon)
to stop.

Opening DatabasePool 'acore_world'. Asynchronous connections: 1, synchronous connections: 1.
MySQL client library: 5.7.24
MySQL server ver: 5.5.5-10.1.37-MariaDB
MySQL client library: 5.7.24
MySQL server ver: 5.5.5-10.1.37-MariaDB
DatabasePool acore_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;azerothcorered;Galaxys308654782;acore_world

STEPS TO REPRODUCE THE PROBLEM:

1. Fresh compile
2. Used DB-assembler.sh, press two for base only
3. Upload to xampp ver. 7.3.0 via heidisql

EXTRA NOTES:

I wanted to see if If it was this version of xampp but on a fresh compile of trinitycore, everything works perfectly

Cmake Compiler is VS 15 2017 Win64
Boost - 1.66
MYSQL 5.6
OpenSSL 1.1.1a

BRANCH(ES):

master

AC HASH/COMMIT:

37d9ef012608a1ddaa839f7e6b63e22fcd821d90

OPERATING SYSTEM:

Windows 10.

MODULES:

Account Achievements
Anticheat
Boss Announcer
Character tools
Chat login
Congrats on level
Eluna lua
Fireworks on level
Gm security
Multi client check
New character perks
Reward player time
Solocraft
VAS
Transmog
Rewardshop
XP Weekend

OTHER CUSTOMIZATIONS:

No customization's.
-->

[FrancescoBorzi]

It looks like your world DB is not up to date. So you need to update it properly. Probably something went wrong while using the DB assembler.

To make sure your DB is up to date, check the name of the last column of the table version_db_world of your world database. It should match with the most recent sql file name of the direcotry data/sql/updates/db_world.

[itwyceo]

2019-02-07 13:10:21 Opening DatabasePool 'world'. Asynchronous connections: 1, synchronous connections: 1.
2019-02-07 13:10:21 MySQL client library: 5.6.25
2019-02-07 13:10:21 MySQL server ver: 5.6.25-log
2019-02-07 13:10:21 MySQL client library: 5.6.25
2019-02-07 13:10:21 MySQL server ver: 5.6.25-log
2019-02-07 13:10:21 [ERROR]: In mysql_stmt_prepare() id: 4, sql: "SELECT entryorguid, source_type, id, link, event_type, event_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, event_param5, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_param4, target_x, target_y, target_z, target_o FROM smart_scripts ORDER BY entryorguid, source_type, id, link"
2019-02-07 13:10:21 [ERROR]: Unknown column 'event_param5' in 'field list'
2019-02-07 13:10:21 [ERROR]: In mysql_stmt_prepare() id: 54, 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, npcflag, speed_walk, speed_run, scale, rank, mindmg, maxdmg, dmgschool, attackpower, DamageModifier, BaseAttackTime, RangeAttackTime, unit_class, unit_flags, unit_flags2, dynamicflags, family, trainer_type, trainer_spell, 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, HealthModifier, ManaModifier, ArmorModifier, RacialLeader, movementId, RegenHealth, mechanic_immune_mask, flags_extra, ScriptName FROM creature_template WHERE entry = ?"
2019-02-07 13:10:21 [ERROR]: Unknown column 'DamageModifier' in 'field list'

[poszer]

You need to update your database

[docxkillborn]

I have updated the database with the single Corresponding ver. and a entire db. Assembler World_sql update and still nothing works always throwing the same error.

[FrancescoBorzi]

@docxkillborn what's the name of the last column of the table version_db_world of your world database?

[docxkillborn]

Not currently at home I last remember it being 2015_06_01

When applying the update via Heidi ask you well I would get over 5000 errors

[docxkillborn]

When I get off work I will post screenshots

[itwyceo]

2019_01_12_06

[FrancescoBorzi]

Then your DB is not installed properly, you need to have the latest sql version:

https://github.com/azerothcore/azerothcore-wotlk/tree/master/data/sql/updates/db_world

for example currently the latest is 2019_02_07_00.sql

[DJBoxer]

Look at his issue he clearly claims to only done.

2. Used DB-assembler.sh, press two for base only

so no updates have been applied, he referes to TC which last i used it had a auto updater when your run worldserver so guessing he believes AC has one also.

@docxkillborn you need to do this part https://github.com/azerothcore/azerothcore-wotlk/wiki/Database-Setup then it will do the updates your missing.