mangos two Database version error

[Coolfox]

Hey guys,

i have a problem with updating worldDB to the right version. The only update that i can not apply is 

Rel21_2_0_SD2_refactoring.sql.(ERROR 1091 (42000) at line 5: Can't DROP 'ScriptName'; check that column/key exists).

 

Who can help me out here?

 

thx in advance

 

The table `db_version` indicates that your [World] database does not match the expected structure!

  [A] You have database Version: 21
                      Structure: 1
                        Content: 0
                    Description: revision_refactor

  [B] You need database Version: 21
                      Structure: 2
                        Content: 6
                    Description: dbdocs updates

You must apply all updates after [A] to [B] to use MaNGOS with this database.
These updates are included in the database/World/Updates folder.

 

[Necrovoice]

Seems you missed  the update 

21000_10_db_version.sql


Try on a fresh world database... if the problem continues let me know.

 

[Coolfox]

Goodmorning  necrovoice,

 

I tried a fresh install with a fresh world db. I checked the file on github, (https://github.com/mangostwo/database/blob/Develop21/World/Updates/Rel21/21000_10_db_version.sql) i see also the incorrect version. Iam i looking in the wrong branch? I don't get it.

[Necrovoice]

Same as what I have here, just to double check before moving on to some other questions..  You cloned the develop21  server and database correct? if yes then make sure you are following the proper install and update order..

You installed and attempted to update in this order?

mangos_full_db.sql
21000_10_db_version.sql
Rel21_2_0_SD2_refactoring.sql
Rel21_2_1_fix_startup_errors.sql
Rel21_2_2_Windrunner_Spire_NPCs.sql
Rel21_2_3_Zaxxis_NPCs.sql
Rel21_2_4_Crust_Busters.sql
Rel21_2_5_dbdocs_updates.sql
Rel21_2_6_dbdocs_updates.sql
Rel21_2_7_start_up_error_fixes.sql

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

Also how are you applying the updates? I use an interface program called SQLyog

[Coolfox]

Hey,

 

I did. Just that one error:

Rel21_2_0_SD2_refactoring.sql.(ERROR 1091 (42000) at line 5: Can't DROP 'ScriptName'; check that column/key exists).

I don't how this works. Is it so if one fails, the others will fail also? Them the problem lies in Rel21_2_0_SD2_refactoring.sql.

I have tried direct import in sql, phpmyadmin and HeidiSQL to import.

 

I did checked out if the column exists, what didn't. So i did remove those lines.

With that in the process, i did apply the rest of the sql updates followed in order.

World server is now running. 

 

Thanks for the pointers in the right direction mate, Cheers 

 

[madmax]

This has been moved to general help and support