Jump to content

UDB SQL Errors


Guest jamessinger

Recommended Posts

Hi,

I tried a Mangos repack from Ac-web to see what mangos was like and as soon as i logged on and started questing in northshire i thought WOW!! this is better than Arcemu and trinity core put together. So i decided to compile mangos for the first time today, ive just come from Arcemu(ive never had problems with them but they are so slow at updating and their updates are nothing of much excitement most of the time).

Im running Windows7 ultimate x64, mangos rev 9852 and UDB 390 but everytime i try to start my server i get this error:

2010-05-10 11:31:35 MaNGOS/0.16.0-DEV (* * Revision 9852 - *) for Win32 (little-endian) [world-daemon]
2010-05-10 11:31:35 <Ctrl-C> to stop.


MM   MM         MM   MM  MMMMM   MMMM   MMMMM
MM   MM         MM   MM MMM MMM MM  MM MMM MMM
MMM MMM         MMM  MM MMM MMM MM  MM MMM
MM M MM         MMMM MM MMM     MM  MM  MMM
MM M MM  MMMMM  MM MMMM MMM     MM  MM   MMM
MM M MM M   MMM MM  MMM MMMMMMM MM  MM    MMM
MM   MM     MMM MM   MM MM  MMM MM  MM     MMM
MM   MM MMMMMMM MM   MM MMM MMM MM  MM MMM MMM
MM   MM MM  MMM MM   MM  MMMMMM  MMMM   MMMMM
       MM  MMM [url]http://getmangos.eu[/url]
       MMMMMM


2010-05-10 11:31:35 Using configuration file mangosd.conf.
2010-05-10 11:31:35 World Database: 127.0.0.1;3306;root;ascent;mangos
2010-05-10 11:31:35 MySQL client library: 5.0.56
2010-05-10 11:31:35 MySQL server ver: 5.0.45-community-nt 
2010-05-10 11:31:35 ERROR:SQL: SELECT required_9826_01_mangos_spell_script_target FROM db_version LIMIT 1
2010-05-10 11:31:35 ERROR:query ERROR: Unknown column 'required_9826_01_mangos_spell_script_target' in 'field list'
2010-05-10 11:31:35 ERROR:Table `db_version` have field `required_9763_01_mangos_battleground_template` but expected `required_9826_01_mangos_spell_script_target`! Not all sql updates applied?

so i try to import 9763_01_mangos_battleground_template.sql but i get this error:

4594581127_b46e83eda3_o.jpg

But i get the same error when i try to import the file before, and it keep going i tried importing back till i got to 4679_mangos_spell_proc_event.sql but got this error:

4595202506_1cc472c0a9_o.jpg

If there is anything else you need i will post it up for you

Could someone please mayby upload a mangos database which all the mangos updates applied? because im getting fed up of all these errors.

James

Link to comment
Share on other sites

ok ty, but i did try all the sql files.

Not in the correct order, if you got that error message.

But if you read the message,

it tells you that the last sql update to your database was "9763_01_mangos_battleground_template".

And of course you get an error when you try to apply the same sql update again to the database,

those updates already exists in the database, and can't be applied twice.

You must start with applying the next sql update from "9763_01_mangos_battleground_template",

up to "9826_01_mangos_spell_script_target".

Link to comment
Share on other sites

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use