mangos zero Db_version does not match source version

[hifish]

Hi all,

it try to install mangos zero.

 

I checked out the following:

git clone https://github.com/mangoszero/server.git serverZero --recursive

git clone https://github.com/mangoszero/database.git dbZero --recursive

 

I installed the world db like this:

 

cd ~/dbZero/

chmod +x make_full_WorldDB.sh

./make_full_WorldDB.sh

mysql -u root -p zero_world < full_db.sql

 

And when i try to start mangosd, i get the following error:

 

mangos@mangos:~/zero/bin$ ./mangosd
20007 [world-daemon]
<Ctrl-C> to stop.
  __  __      _  _  ___  ___  ___
 |  \/  |__ _| \| |/ __|/ _ \/ __|        We Love
 | |\/| / _` | .` | (_ | (_) \__ \      Vanilla Wow
 |_|  |_\__,_|_|\_|\___|\___/|___/
                                        ____
 For help and support please visit:    /_  /___ _ _ ___
 Website: https://getmangos.eu          / // -_) '_/ _ \
    Wiki: http://github.com/mangoswiki /___\___|_| \___/

Using configuration file ../etc/mangosd.conf.
OpenSSL 1.0.2g  1 Mar 2016 (Library: OpenSSL 1.0.2g-fips  1 Mar 2016)
Using ACE: 6.3.0
World Database total connections: 2
Connected to MySQL database mangos@127.0.0.1:3306/zero_world
MySQL client library: 5.7.13
MySQL server ver: 5.7.13-0ubuntu0.16.04.2
AUTOCOMMIT SUCCESSFULLY SET TO 1
Connected to MySQL database mangos@127.0.0.1:3306/zero_world
MySQL client library: 5.7.13
MySQL server ver: 5.7.13-0ubuntu0.16.04.2
AUTOCOMMIT SUCCESSFULLY SET TO 1
SQL: SELECT required_20007_01_Rel20_Release_Prep FROM db_version LIMIT 1
query ERROR: Unknown column 'required_20007_01_Rel20_Release_Prep' in 'field lis                   t'
The table `db_version` in your [WORLD] database indicates that this database is                    out of date!

  [A] You have: --> `20007_18_Deadmines_Mr_Smite_Corrections.sql`

  [B] You need: --> `20007_01_Rel20_Release_Prep.sql`

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

 

So this indicates that my applied database version is to new for my mangosd, but i checked out the same branch(trunk?).

So i need a newer server version or an older database version. So which branches should i use?

[hifish]

Hi,

 

ok, i get it to work. I get a bit into it and saw that there was a commit from 28.05.2015 in the database release20 branch, which changes the name of the third column from 'required_20007_01_Rel20_Release_Prep'  to 'required_20007_18_Deadmines_Mr_Smite_Corrections'

 

But there are no changes like that in the server release20 branch. I changed this value back to 'required_20007_01_Rel20_Release_Prep' and now it works. I think this is a bug, because there was just a change of the version field without applying all the fixes.

 

The next problem was that my mangosd do not find any maps, it always says:

Please check for the existence of map file './maps/0004331.map'
Correct *.map files not found in path './maps' or *.vmtree/*.vmtile files in './vmaps'. Please place *.map and vmap files in appropriate directories or correct the DataDir value in the mangosd.conf file.

 

I found out that the default Datadir ="." now searches for everything in the bin folder. Changing this to "../" works for me, but i think this is confusing. There should be a better default, or even better a hardcoded basedir from which you specify where the resources are.

So, now my realmd and ma mangosd run, now i have to check if i can connect my client and everything works fine.

 

Regards

[antz]

Could you try the following:-

git clone https://github.com/mangoszero/server.git serverZero --recursive -b develop21
git clone https://github.com/mangoszero/database.git dbZero --recursive -b develop21

The develop21 branch has over a years worth of enhancements, I would try using that !