How do I apply the SQL update files located in SQL\updates to bring my server up from 7.3.5 to 8.1.5?
I have downloaded the current master branch(126.96.36.199706), compiled it using vmaps, mmaps, gt, dbc and cameras files extracted from the latest retail client (8.1.5 30706). When I launch worldserver.exe I see it populating the databases from the included SQL files (TDB_world_735.00_2018_02_19.sql and TDB_hotfixes_735.00_2018_02_19.sql).
The problem is that when I then exit and restart worldserver.exe I get about 80,000 errors like the following:
SmartAIMgr::LoadSmartAIFromDB: Entry 18931 SourceType 0, Event 3, Link Source Event not found or invalid. Event will never trigger.
TSCR: DB table script_waypoint has waypoint for creature entry 17238, but creature does not have ScriptName defined and then useless.
Table waypoint_scripts uses deprecated direct updatefield modify command SCRIPT_COMMAND_FIELD_SET_DEPRECATED for script id 463
Scriptname: spell_hun_improved_mend_pet spell (Id: -19572) does not exist.
I can log in to the server and create a new character, but the game is broken (no exclamation points showing for quests, can’t cast spells, etc). When I run SELECT * FROM ‘VERSION’ my database version is still 7.3.5 even though I see in the SQL\updates folders there are .sql files that look like they’ll update the version of my databases to 8.1.5. But when I attempt to execute them I get SQL errors so I don’t think I am applying these update files correctly.
If you can not apply the updates .sql is because you are using mysql 5.5, you need to update to mysql 5.6 and re-create the database.
But a lot of work is still missing for a DB 8.1.5.
From what I have tried, the “Pandaren” have npcs but do not have quests, and the “Demon Hunter” do not have npcs (the classic races seem to work a little better).
Can you tell me more about how to apply the updates? In the four folders (auth, world, characters and hotfixes) there are over three hundred files. I can’t imagine that I’m supposed to execute each file one at a time in MySQL Workbench. How am I supposed to apply these?