search

wormogo / Fixes_for_SPP_Project

SPP project wow fixes
7 stars 6 forks source link

2018_01_20_02_darkheart_thicket.sql & 2018_08_05_04_world_quest.sql #62

Closed yymmaa closed 6 years ago

yymmaa commented 6 years ago

Describe the bug world server not launching because error in both sql script

To Reproduce Steps to reproduce the behavior:

  1. Launcher_server.bat and chose 1 or 2

Expected behavior server setup and showing me "now you ready to play"

Screenshots non

Additional context _2018_01_20_02_darkheartthicket.sql : line 1282 

INSERT INTO `creature_template_scaling` (`Entry`, `LevelScalingDelta`, `VerifiedBuild`) VALUES ...

probleme : column LevelScalingDelta do not exists

_2018_08_05_04_worldquest.sql : line 1

INSERT INTO creature (id, map, zoneId, areaId, position_x, position_y, position_z, orientation, spawntimesecs, curhealth) VALUES (11980, 530, 3520, 3939, -4206, 333, 119, 1.44, 600, 95000);

probleme : insert passed but guid should not be 0, primary key violation

wormogo commented 6 years ago

Thank you for reporting this. It is server structure related issue not content. Please report this issue on SPP Discord to Conan.

Possible solution : In Launcher -> Service menu -> World and hotfix db reset. It resolves the issue.

Thank you!