Jump to content
  • 0

[Zero] Database update issue


Terrs

Question

Posted

I still could not fix this error, someone can help me?

DBErrors.log file:

2013-10-12 22:10:12 SQL: SELECT required_z2381_s2034_12522_01_mangos_db_script_string FROM db_version LIMIT 1

2013-10-12 22:10:12 query ERROR: Unknown column 'required_z2381_s2034_12522_01_mangos_db_script_string' in 'field list'

2013-10-12 22:10:12 The table `db_version` in your [WORLD] database indicates that this database is out of date!

2013-10-12 22:10:12

2013-10-12 22:10:12 [A ] You have: --> `r2441_01_mangos_db_version.sql`

2013-10-12 22:10:12

2013-10-12 22:10:12 [b ] You need: --> `z2381_s2034_12522_01_mangos_db_script_string.sql`

2013-10-12 22:10:12

2013-10-12 22:10:12 You must apply all updates after [A ] to [b ] to use mangos with this database.

2013-10-12 22:10:12 These updates are included in the sql/updates folder.

2013-10-12 22:10:12 Please read the included [README] in sql/updates for instructions on updating

I read this topic but still could not fix the error - http://community.getmangos.eu/index.php?topic=20007.0

5 answers to this question

Recommended Posts

Posted

from the sound of this.... in a nutshell:

You have db version 2441_01

your mangos server is looking for 2381_01

You need to pull the latest version of mangos and recompile it

Posted

i used 'git pull' in mangos, database, script folder. so now appears this error:

2013-10-13 16:15:41 MaNGOS Zero/ (2013-10-13 14:41:59 Revision 2459 - d74c0224c74d346a021ad68531888625c5ed27cd) for Linux_x32 (little-endian) [world-daemon]
2013-10-13 16:15:41 <Ctrl-C> to stop.
2013-10-13 16:15:41 


####    ####      ###   ###  ########  #######   ######## 
#####   #####      ####  ### ########## #########  ##########
#####   #####      #####  ### ########## #########  ##########
######  ######      #####  ### ###    ####  #### ###    
######  ######  ####  ###### ### ###    ###   ### ###    
####### #######  ######  ###### ### ### ##### ###   ### ######## 
### ### ### ###  ######  ####### ### ### ##### ###   ### ######### 
### ### ### ### ### ### ### ### ### ### ##### ###   ###  #########
### ####### ### ### ### ### ###### ###  ### ###   ###    ####
### ####### ### ### ### ### ###### ###  ### ###   ###     ###
### ##### ### ########## ###  ##### ###  #### ####  ####    ####
### ##### ### ########## ###  ##### #########  #########  ##########
### ##### ### ###  ### ###  #### #########  #########  ######### 
###  ###  ### ###  ### ###   ###  #######   #######   ####### 


                       #####           
Website: [url]http://www.getmangos.eu[/url]       ### #### #####  #### 
                        ##  ##  ## ## ## ##
 Wiki: [url]http://github.com/mangoswiki/wiki[/url]   ##  #### #####  ## ##
                       ##   ##  ## ##  ## ##
 Forum: [url]http://community.getmangos.eu[/url]   ##### #### ## ##  #### 






2013-10-13 16:15:41 Using configuration file /opt/mangos-zero/etc/mangosd.conf.
2013-10-13 16:15:41 World Database total connections: 2
2013-10-13 16:15:41 MySQL client library: 5.5.32
2013-10-13 16:15:41 MySQL server ver: 5.5.22-0ubuntu1 
2013-10-13 16:15:41 MySQL client library: 5.5.32
2013-10-13 16:15:41 MySQL server ver: 5.5.22-0ubuntu1 
2013-10-13 16:15:41 ERROR:SQL: SELECT required_r2441_01_mangos_db_version FROM db_version LIMIT 1
2013-10-13 16:15:41 ERROR:query ERROR: Unknown column 'required_r2441_01_mangos_db_version' in 'field list'
2013-10-13 16:15:41 ERROR:The table `db_version` in your [WORLD] database indicates that this database is out of date!
2013-10-13 16:15:41 ERROR:
2013-10-13 16:15:41 ERROR: [A] You have: --> `r2434_01_mangos_scripted_event.sql`
2013-10-13 16:15:41 ERROR:
2013-10-13 16:15:41 ERROR: [b] You need: --> `r2441_01_mangos_db_version.sql`
2013-10-13 16:15:41 ERROR:
2013-10-13 16:15:41 ERROR:You must apply all updates after [A] to [b] to use mangos with this database.
2013-10-13 16:15:41 ERROR:These updates are included in the sql/updates folder.
2013-10-13 16:15:41 ERROR:Please read the included [README] in sql/updates for instructions on updating.

Posted

This means you successfully upgraded mangos-zero now.

Now you to apply these updates from sql/updates:


  • [li]z2439_sxxxx_xxxxx_01_mangos_command.sql[/li]
    [li]z2441_sxxxx_xxxxx_01_mangos_db_version.sql[/li]

Posted

This means you successfully upgraded mangos-zero now.

Now you to apply these updates from sql/updates:


  • [li]z2439_sxxxx_xxxxx_01_mangos_command.sql[/li]
    [li]z2441_sxxxx_xxxxx_01_mangos_db_version.sql[/li]

I did it and it worked, but now another error appeared.

I need to apply all updates from sql/updates?

I'll try to reinstall the database and apply the updates.

Thank you for your attention TheLuda and Antz

[EDIT]

after I used all the update files sql / updates ... I could not fix the error. now appears

[A] You have: --> `s1350_11716_09_characters_mail.sql`
[b] You need: --> `z1794_s1350_11716_09_characters_auction.sql`

Posted

The message indicates that your character database is very, very old :o. Unless you have any data in there which you still need, I would recommend a fresh installation. Also, it seems the character database seems to be a mangos-one database?

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use