Jump to content
TrinityCore

How to update TDB 335.64 to TDB 335.22101 database?


Gib_adm
 Share

Recommended Posts

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

Posted (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 by Gib_adm
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...