[SOLVED][Zero] Startup Errors / Update database

[prechy]

Hello

I recently set up a server. Now I cant get my head around this issue. I am getting the following error messages when I start the server:

The table `db_version` in your [WORLD] database indicates that this database is out of date!

[A] You have: --> `r2434_01_mangos_scripted_event.sql`

You need: --> `r2441_01_mangos_db_version.sql`

When I try to update the database I get this:

mangos@debian:~/server/server/sql/updates$ mysql -u root -p mangos < z2441_sxxxx_xxxxx_01_mangos_db_version.sql

Enter password:

ERROR 1054 (42S22) at line 1: Unknown column 'required_r2439_01_mangos_command' in 'db_version'

mangos@debian:~/server/server/sql/updates$

What am I doing wrong??

[madmax]

Marking topic as solved. Please let us know if you need further help by creating a new topic and linking back to this one.

[TheLuda]

Pretty simple: you have not read the error message properly.

• 
  [li]your database is r2434_01_mangos_scripted_event, which means

this update has been applied.[/li]
[li]if you look at the update list, there is https://github.com/mangoszero/server/blob/master/sql/updates/z2439_sxxxx_xxxxx_01_mangos_command.sql and https://github.com/mangoszero/server/blob/master/sql/updates/z2441_sxxxx_xxxxx_01_mangos_db_version.sql following[/li]

This means; you tried to apply version 2441 before 2439, which is bound to fail and result in the exact error you got. The unknown column error is what hints at this.

The principle behind this is explained in the README at https://github.com/mangoszero/server/blob/master/sql/updates/README.

[prechy]

Pretty simple: you have not read the error message properly.

• 
  [li]your database is r2434_01_mangos_scripted_event, which means

this update has been applied.[/li]
[li]if you look at the update list, there is https://github.com/mangoszero/server/blob/master/sql/updates/z2439_sxxxx_xxxxx_01_mangos_command.sql and https://github.com/mangoszero/server/blob/master/sql/updates/z2441_sxxxx_xxxxx_01_mangos_db_version.sql following[/li]

This means; you tried to apply version 2441 before 2439, which is bound to fail and result in the exact error you got. The unknown column error is what hints at this.

The principle behind this is explained in the README at https://github.com/mangoszero/server/blob/master/sql/updates/README.

Many thanks its working now ;D . I just couldnt see what went wrong, but now I understand the structure.

/bow

[TheLuda]

Np, just ask if you run into other issues