Jump to content
  • 0

[Zero] Database update issue


Terrs

Question

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

Link to comment
Share on other sites

5 answers to this question

Recommended Posts

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.

Link to comment
Share on other sites

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`

Link to comment
Share on other sites

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