Issues updating the SQL

[Pyrarrows]

I'm installing a Mangos server on an Ubuntu server in my basement, but I'm running into some trouble.

Everything seems to have compiled just fine, realmd starts, but the worldd server doesn't start, giving me this output

Using configuration file /opt/mangos/etc.home/mangosd.conf.
OpenSSL 1.0.0 29 Mar 2010 (Library: OpenSSL 0.9.8g 19 Oct 2007)
WARNING: Outdated version of OpenSSL lib. Logins to server may not work!
WARNING: Minimal required version [OpenSSL 0.9.8k]
Using ACE: 5.6.6
World Database: 127.0.0.1;3306;mangos;password;mangos
Connected to MySQL database at 127.0.0.1
MySQL client library: 5.0.83
MySQL server ver: 5.1.37-1ubuntu5.4 
AUTOCOMMIT SUCCESSFULLY SET TO 1
SQL: SELECT required_10208_01_mangos_playercreateinfo FROM db_version LIMIT 1
query ERROR: Unknown column 'required_10208_01_mangos_playercreateinfo' in 'field list'
[0 ms] SQL: SELECT * FROM db_version LIMIT 1
The table `db_version` in your [WORLD] database indicates that this database is out of date!

 [A] You have: --> `9539_01_mangos_spell_bonus_data.sql`

 [b] You need: --> `10208_01_mangos_playercreateinfo.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.
[1 ms] SQL: SET NAMES `utf8`
[0 ms] SQL: SET CHARACTER SET `utf8`

I used the python script in the compiling on Ubuntu section of the wiki, and I just got a ton of error messages like this

--------------
ALTER TABLE db_version CHANGE COLUMN required_10207_01_mangos_npc_vendor required_10208_01_mangos_playercreateinfo bit
--------------

ERROR 1054 (42S22) at line 1: Unknown column 'required_10207_01_mangos_npc_vendor' in 'db_version'

nothing gets updated, due to the Unknown column error, it appears on every line.

[Schmoozerd]

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

[A] You have: --> `9539_01_mangos_spell_bonus_data.sql`

You need: --> `10208_01_mangos_playercreateinfo.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.

Or read the FAQs

[VladimirMangos]

In fact i not understand how anyone can fail understand "You must apply all updates after [A] to to use mangos with this database.

These updates are included in the sql/updates folder."

[Pyrarrows]

first, 9539_01_mangos_spell_bonus_data.sql doesn't exist in the /opt/mangos/mangos/sql/updates folder, mangos says that it's installed, so that shouldn't be an issue, the other file does exist, but I end up getting this error when I try to apply it.

mysql -u ****** -p******** mangos < 10208_01_mangos_playercreateinfo.sql

ERROR 1054 (42S22) at line 1: Unknown column 'required_10207_01_mangos_npc_vendor' in 'db_version'

I've tried applying all of the updates manually, but I just get similar errors.

[Schmoozerd]

<mangos>\\sql\\updates\\0.16\\09539_01_mangos_spell_bonus_data.sql exists

[Curious]

You have to apply all the file between A and B......

Mangos sql update work this way :

your currently at revision [A] which is : 9539_01_mangos_spell_bonus_data.sql

in order to get to you have to applied all the sql file between the first number and the last (included).

There is a field name used to check which version currently running. At every SQL change this field name is update. This system has been put in place in order to force the user to apply every SQL update without errors. If you have a "very" old version the revision number may not be the same, if so the sql's files will be in separated folder (0.15,0.16,etc...)

It's not that hard to understand....

[Pyrarrows]

Oh, so it's in a subfolder... dang I can't believe that I missed that... although it wasn't moved during the install process, I had to find it in the folder I installed it from. Well now I get to test the server

Thanks for the help.