Jump to content
  • 0

Error in updates for Mangoszero Rel21


teddybairs1

Question

Reinstalling Mangos after changing over my OS a couple of times. Having trouble with updating the database, specifically the Realm database. This is my feedback:

root@debian:/home/allen/database/Realm/Updates/Rel19# mysql -u root -p mangos < 20140607_Realm_Resync.sql

Enter password:

ERROR 1146 (42S02) at line 1: Table 'mangos.realmd_db_version' doesn't exist

No idea what it's talking about.

This is my output when I try to run either realmd or mangosd:

SQL: SELECT required_20150420_warden_db_log FROM realmd_db_version LIMIT 1

query ERROR: Unknown column 'required_20150420_warden_db_log' in 'field list'

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

[A] You have: --> `20150409_Playerbot_and_Warden.sql`

You need: --> `20150420_warden_db_log.sql`

You must apply all updates after [A] to 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.

And this is my output when I try and rectify the situation:

root@debian:/home/allen/database/Realm/Updates/Rel21# mysql -u root -p mangos < 20150412_01_warden_db_log.sql

Enter password:

Status Required Version Found Version

* UPDATE SKIPPED * required_20150409_Playerbot_and_Warden NULL

root@debian:/home/allen/database/Realm/Updates/Rel21# mysql -u root -p mangos < 20150409_Playerbot_and_Warden.sql

Enter password:

Status Required Version Found Version

* UPDATE SKIPPED * required_20140607_Realm_Resync NULL

I'm not the greatest with mysql, and I know some of the guys on here have helped me get it running well before. Just wondering if I could get a hand.

Thanks.

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

root@debian:/home/allen/database/Realm/Updates/Rel19#
mysql -u root -p [color="#FF0000"]mangos[/color] < 20140607_Realm_Resync.sql

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

The mysql command above tries to modify "mangos" database. The Mangos setup contains 3 databases (named by default as realmd, characters0, and mangos0). The core informs you about an issue with REALMD database, so the mentioned updates must be applied to "realmd". The following command looks correct:

mysql -u root -p realmd < 20150412_01_warden_db_log.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