search

celguar / spp-classics-cmangos

SPP Classics repack with ike3 playerbots. Based on cmangos. Supports 1.12, 2.4.3, 3.3.5. Check "Releases" for installer
210 stars 57 forks source link

Fix "Unknown column 'required_14071_01_mangos_spawn_data_equip' in 'field list'" Error | WotLK #143

Closed qskateboard closed 1 year ago

qskateboard commented 1 year ago

When running a WoW server (Beta build), the following error occurs:

SQL: SELECT required_14071_01_mangos_spawn_data_equip FROM db_version LIMIT 1
query ERROR: Unknown column 'required_14071_01_mangos_spawn_data_equip' in 'field list'
The table `db_version` in your [WORLD] database indicates that this database is out of date!

  [A] You have: --> `14065_01_mangos_aggro_range.sql`

  [B] You need: --> `14071_01_mangos_spawn_data_equip.sql`

You must apply all updates after [A] to [B] to use mangos with this database.
These updates are included in the sql/updates folder.
Please read the included [README] in sql/updates for instructions on updating.

I can't reset the database, how do I do the migration? I want to upgrade to the beta branch, because stable has a lot of bugs with bots and crashes the arena/BG

qskateboard commented 1 year ago

In general, I fixed this problem by running Server_Update. I would recommend that when the server starts, you send a request to check for updates and offer to automatically install the update by running the Server_Update file. I didn't find this in the README, but I successfully updated by the method of scientific poke.