[Mangos Two] Database error, requiring update to an older version

[rayonaboat]

I'm running Centos 7, installed everything following the centos 7 wiki tutorial but replaced mangosthree with two. Server is updated to the latest version, so is database. Realmd works, but mangosd is giving me errors.

[rayonaboat@wow-server bin]$ ./mangosd
MaNGOS Two/ (* * Revision 12578 - *) for Linux_x64 (little-endian) [world-daemon]
<Ctrl-C> to stop.
 __  __      _  _  ___  ___  ___                       
|  \/  |__ _| \| |/ __|/ _ \/ __|                      
| |\/| / _` | .` | (_ | (_) \__ \                      
|_|  |_\__,_|_|\_|\___|\___/|___/                      
                                       _____           
For help and support please visit:    |_   _|_ __ _____
Website: https://getmangos.eu           | | \ V  V / _ \
   Wiki: http://github.com/mangoswiki   |_|  \_/\_/\___/ 

Using configuration file /opt/mangos/etc/mangosd.conf.
OpenSSL 1.0.1e 11 Feb 2013 (Library: OpenSSL 1.0.1e-fips 11 Feb 2013)
Using ACE: 5.8.3
World Database total connections: 2
Connected to MySQL database [email protected]:3306/mangos
MySQL client library: 10.0.24-MariaDB
MySQL server ver: 10.0.24-MariaDB 
AUTOCOMMIT SUCCESSFULLY SET TO 1
Connected to MySQL database [email protected]:3306/mangos
MySQL client library: 10.0.24-MariaDB
MySQL server ver: 10.0.24-MariaDB 
AUTOCOMMIT SUCCESSFULLY SET TO 1
Character Database total connections: 2
Connected to MySQL database [email protected]:3306/characters
MySQL client library: 10.0.24-MariaDB
MySQL server ver: 10.0.24-MariaDB 
AUTOCOMMIT SUCCESSFULLY SET TO 1
Connected to MySQL database [email protected]:3306/characters
MySQL client library: 10.0.24-MariaDB
MySQL server ver: 10.0.24-MariaDB 
AUTOCOMMIT SUCCESSFULLY SET TO 1
SQL: SELECT required_12546_01_characters_random_battleground FROM character_db_version LIMIT 1
query ERROR: Table 'characters.character_db_version' doesn't exist
SQL: SELECT * FROM character_db_version LIMIT 1
query ERROR: Table 'characters.character_db_version' doesn't exist
The table `character_db_version` in your [CHARACTER] database is missing or corrupt.
MaNGOS can not find the version info needed to check that the db is up to date.
This revision of mangos requires a database updated to:
`12546_01_characters_random_battleground.sql`
Reinstall your [CHARACTER] database with the included sql file in the sql folder.

So I get this. Seems like i have to apply characters.sql. Mangosd still doesnt work.

I decide to run the 01_characters_random_battleground.sql update, and I get this error

[root@wow-server characters]# mysql -u root -p mangos < 01_characters_random_battleground.sql
Enter password: 
ERROR 1054 (42S22) at line 1: Unknown column 'required_12487_01_characters_characters' in 'character_db_versio
n'

Is there something I should do/shouldn't have done? Can I fix it?

[LaMigne]

Hello rayonaboat,

It looks like you inverted some DB...

your command

mysql -u root -p mangos < 01_characters_random_battleground.sql

asks mysql to install a characters DB update on your "mangos" table !

you must change the code with

mysql -u root -p characters < 01_characters_random_battleground.sql

or characters2 (maybe) followinf how you named your table you are using

I'm a noob too, maybe i'm totally wrong,

hope it helped,

C.

[antz]

Are you using the develop21 branch on the repo - If not, I would seriously suggest you do