Gib_adm Posted January 1, 2023 Report Share Posted January 1, 2023 Hello, I have a server that runs on TDB 335.64, I have updated the engine to the current version of TDB 335.22101. How do I update the database correctly from TDB version 335.64 to TDB 335.22101 so that there are no problems? Updates were not installed automatically, although in the settings of the world server : Updates.Enable databases = 7 Thank You Link to comment Share on other sites More sharing options...
Aokromes Posted January 1, 2023 Report Share Posted January 1, 2023 if you don't have any custom thing i sugest you to drop world database, if you have custom things i recomend you to pull to tdb 335.19031, then 335.19041.... there are to much commits betweeen your db and head. 2 Link to comment Share on other sites More sharing options...
Gib_adm Posted January 2, 2023 Author Report Share Posted January 2, 2023 (edited) 13 hours ago, Aokromes said: if you don't have any custom thing i sugest you to drop world database, if you have custom things i recomend you to pull to tdb 335.19031, then 335.19041.... there are to much commits betweeen your db and head. Please tell me how to pull up the database 335.19031, then 335.19041 correctly ? I tried clean upload TDB_full_world_335.22101_2022_10_17.sql database but I get errors: >> The file '2018_02_28_02_world_335.sql' was applied to the database, but is missing in your update directory now! >> The file '2018_03_03_02_world_335.sql' was applied to the database, but is missing in your update directory now! >> The file '2021_04_02_02_world_335.sql' was applied to the database, but is missing in your update directory now! >> The file '2018_08_02_00_world_335.sql' was applied to the database, but is missing in your update directory now! >> The file '2018_03_03_03_world_335.sql' was applied to the database, but is missing in your update directory now! >> The file '2018_03_03_04_world_335.sql' was applied to the database, but is missing in your update directory now! >> The file '2018_03_03_05_world_335.sql' was applied to the database, but is missing in your update directory now! Cleanup is disabled! There were 3104 dirty files applied to your database, but they are now missing in your source directory! >> Applied 1 query. Containing 0 new and 6287 archived updates. In mysql_stmt_prepare() id: 20, sql: "UPDATE creature SET spawndist = ?, MovementType = ? WHERE guid = ?" Unknown column 'spawndist' in 'field list' In mysql_stmt_prepare() id: 62, sql: "INSERT INTO creature (guid, id , map, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, MovementType, npcflag, unit_flags, dynamicflags) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" Unknown column 'spawndist' in 'field list' Could not prepare statements of the World database, see log for details. Edited January 2, 2023 by Gib_adm Link to comment Share on other sites More sharing options...
Gib_adm Posted January 4, 2023 Author Report Share Posted January 4, 2023 I understood how the problem is solved. In order not to breed topics, I wanted to ask about Wintergrasp: are there working assemblies or links to materials how to configure it to work correctly? Thank You Link to comment Share on other sites More sharing options...
Recommended Posts