💬 [Support Request] Database install issue - Classic

[Daedalus-code]

Core Version

mangos-classic

Support Request Details

Updating database with 'Install' command I end up with this:

  - Applying 429_dire_maul.sql ... SUCCESS
  - Applying 449_450_Alliance_Horde_PVP_Barracks.sql ... SUCCESS
  - Applying 469_blackwing_lair.sql ... SUCCESS
  - Applying 509_ruins_of_ahnqiraj.sql ... SUCCESS
  - Applying 529_arathi_basin.sql ... SUCCESS
  - Applying 531_temple_of_ahnqiraj.sql ... SUCCESS
  - Applying 533_naxxramas.sql ... SUCCESS
  29 Instance files applied successfully

> Trying to process last world (mangos) CORE updates
  - Applying z2823_01_mangos_displayid_probability.sql ... FAILED!
>>> ERROR 1054 (42S22) at line 15: Unknown column 'modelid_alternative' in 'where clause'````

### Steps to Reproduce

1. git pull
2. InstallFullDB.sh 
3. > 2) Install fresh Classic-DB only to 'classic_mangos'
4. ERROR 1054

### Crash Log

_No response_

### Core SHA1 Commit Hash

f928d608e104682d750b202ee9864744da2eec5a

### Database SHA1 Commit Hash

bd3e35935939458742db485b03e1aeb4133f22ac

### Server Operating System

Ubuntu server aarch64

### Client Version

1.1.12 (Classic)

### Client Operating System

Windows

[Daedalus-code]

Thanks! but Im getting this now

  - Applying 509_ruins_of_ahnqiraj.sql ... SUCCESS
  - Applying 529_arathi_basin.sql ... SUCCESS
  - Applying 531_temple_of_ahnqiraj.sql ... SUCCESS
  - Applying 533_naxxramas.sql ... SUCCESS
  29 Instance files applied successfully

> Trying to process last world (mangos) CORE updates
  - Applying z2823_01_mangos_displayid_probability.sql ... SUCCESS
  - Applying z2824_01_mangos_model_unification.sql ... FAILED!
>>> ERROR 1064 (42000) at line 3: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'COLUMN `modelid_other_team` TO `modelid_alternative`' at line 1
Press space to continue...````

[insunaa]

What version of MySQL are you using?

[insunaa]

Probably 5.7 if it doesn't work, seems like this syntax is new with 8.0, tho it's been in use in PostgreSQL and SQLite for ages... I'm gonna submit a PR to use the old syntax

[Daedalus-code]

mysql Ver 15.1 Distrib 10.3.39-MariaDB, for debian-linux-gnueabihf (armv7l) using readline 5.2 edit: doing updates now.. edit: meh..

  - Applying z2823_01_mangos_displayid_probability.sql ... SUCCESS
  - Applying z2824_01_mangos_model_unification.sql ... FAILED!
>>> ERROR 1064 (42000) at line 3: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'COLUMN `modelid_other_team` TO `modelid_alternative`' at line 1````

[insunaa]

Created a PR that should solve the issue for old database servers. Please consider updating to a DB that is not EOL https://mariadb.org/about/#maintenance-policy

[Daedalus-code]

manually fixing this makes me go further to this:

  - Applying scriptdev2.sql ... SUCCESS
  - Applying spell.sql ... SUCCESS

> Trying to apply ACID file ... SUCCESS

> Trying to apply cmangos_custom.sql ... FAILED!
>>> ERROR 1054 (42S22) at line 128: Unknown column 'ModelId2' in 'field list'

[insunaa]

There have been updates in the meantime. You need to update your core, merge my latest core PR locally and merge my db PR locally, then it should work

[Daedalus-code]

Core updates only after failed new install and it started.. :P

[insunaa]

@Daedalus-code can this be closed?

[insunaa]

@Daedalus-code Closing tentatively. If you still have issues please reopen.