(three) 12466_01_mangos_spell_script_target.sql broken or am i broken

[xorace]

i might have missed this some place in the help area but when i patch my db with 12466_01_mangos_spell_script_target.sql

it makes the db c12466_01_mangos_spell_script_target.sql and then it starts asking for patchs c12XXX when patched all the way up to latetest my server still says

You need: --> `12752_01_mangos_reputation_spillover_template.sql` even thou its at c1276X this is for Revision 12778 of the server on linux 64

i dont understand what im doing wrong im useing all the patches in https://github.com/mangosthree/server/tree/master/sql/updates upto 12466_01_mangos_spell_script_target.sql and after that it asks for files from https://github.com/cmangos/mangos-cata/tree/master/sql/updates

why? what am i doing wrong ? did i screw up or something or what im confused please help

after looking at both files there the same on both projects there line for line the same why ? is this why im haveing an issue? and then i found a post on here named core is higher than database this is the same issue im haveing

[antz]

Sadly, I think there must be a mistake in one of the patch files.

You should never need to get patches from another project, they should all be included.

Just to help me trace this issue, which was the first patch you applied ?

[xorace]

in order

12335_01_creature_template_spells-patch

12388_01_mangos_creature_template

12389_01_mangos_creature_template

12453_01_mangos_command

12458_01_mangos_dbscripts_on_creature_death

then at

12466_01_mangos_spell_script_target

it made

c12466_01_mangos_spell_script_target

[/size]

[/size]becuase

https://github.com/mangosthree/server/blob/master/sql/updates/12466_01_mangos_spell_script_target.sql

and

https://github.com/cmangos/mangos-cata/blob/master/sql/updates/c12466_01_mangos_spell_script_target.sql

are the same file i checked on both there idenical except for the prefix removed on yours

[bels]

Those files do look like they have some problems in them because of the required string. I don't know that you have to apply those though, they are fairly old. Did you import the full db first and then see which version your server asks for?

[xorace]

i was trying to use an old data base and patch it up then i stoped because i was getting the same issue so i did what you just said to got a new one patched up and no issues but i still wanted to let somebody know about those files

[STWoW]

I'm using the database mentioned here, on the MaNGOS Three server setup guide. I opted for the precompiled version of the server, which is nice and tidy. I take it this doesn't include any sort of database? Because I'm perfectly happy to just walk around in an empty world for just a while, to see if it worked.

So just to see how things work, I try the default 773KB mangos.sql contained in that precompiled MaNGOS three setup, alongside the 10KB realmd.sql and 72KB characters.sql files, and a scriptdev and updates folder.

Again, this is from a completely fresh mangos database. I had deleted it, recreated it using the same name, and imported the above mangos.sql.

Running that mangos.sql file results in this error in Navicat Premium.

[Err] 1054 - Unknown column 'required_12712_02_mangos_command' in 'field list'

[Err] INSERT INTO `db_version` (`version`, `creature_ai_version`, `cache_id`, `required_12712_02_mangos_command`) VALUES

('Mangos default database.','Creature EventAI not provided.',0,NULL);

[Msg] Finished - Unsuccessfully

--------------------------------------------------

So I'm really not sure why I would get such an error when there's nothing that could bog it down. It's all from the precompiled version from the 8th of March. Possibly the 10th.

Running the realmd and mangosd EXEs results in the following error:

2014-03-14 21:21:07 SQL: SELECT required_12752_01_mangos_reputation_spillover_template FROM db_version LIMIT 1

2014-03-14 21:21:07 query ERROR: Unknown column 'required_12752_01_mangos_reputation_spillover_template' in 'field list'

2014-03-14 21:21:07 The table `db_version` in your [WORLD] database indicates that this database is out of date!

2014-03-14 21:21:07

2014-03-14 21:21:07 [A] You have: --> `11785_01_mangos_instance_encounters.sql`

2014-03-14 21:21:07

2014-03-14 21:21:07 You need: --> `12752_01_mangos_reputation_spillover_template.sql`

2014-03-14 21:21:07

2014-03-14 21:21:07 You must apply all updates after [A] to to use mangos with this database.

2014-03-14 21:21:07 These updates are included in the sql/updates folder.

2014-03-14 21:21:07 Please read the included [README] in sql/updates for instructions on updating.

2014-03-14 21:44:34 The table `db_version` in your [WORLD] database is missing or corrupt.

2014-03-14 21:44:34 MaNGOS cannot find the version info needed to check that the db is up to date.

2014-03-14 21:44:34

2014-03-14 21:44:34 This revision of mangos requires a database updated to:

2014-03-14 21:44:34 `12752_01_mangos_reputation_spillover_template.sql`

2014-03-14 21:44:34

2014-03-14 21:44:34 Post this error to your database provider forum or find a solution there.

Using the Database UDB_0.12.1.393_mangos gives me similarly ill luck, as the only sql file updates I can run are in first few in the "0.5" folder. Scary.

For example, the current DB version I have is asking for

[madmax]

Try sqlyog. i've had a number of problems with navicat in the past.

[bels]

i was trying to use an old data base and patch it up then i stoped because i was getting the same issue so i did what you just said to got a new one patched up and no issues but i still wanted to let somebody know about those files

When you say old database, is it one that you were running in production before or an old one you found laying around? If it was just an old one you had laying around and you're not trying to preserve data I would suggest just getting the database from the github repo. You won't have this problem using that one.

[roadapathy]

i dont understand what im doing wrong im useing all the patches in https://github.com/mangosthree/server/tree/master/sql/updates upto 12466_01_mangos_spell_script_target.sql and after that it asks for files from https://github.com/cmangos/mangos-cata/tree/master/sql/updates

why? what am i doing wrong ? did i screw up or something or what im confused please help

Those are 2 different projects (forks) of Mangos. Only use the mangosthree github.com repository and you should be fine. I only had to run 3 SQL updates to get mine working. You can look at my post here in the help to see more details.

[antz]

Did you get your issues sorted out ?