[Zero] Error while updating...

[virgo77]

Hi all!

First: great job for what you do about MaNGOS, sincerely!

Second: for my personal interest, i try to create my little own MaNGOS Zero server. I downloaded all the files (Core/Database) and i compiled successfully the Core.

Actually, i'm going to install the SQL Files into my new fresh and empty database.

With the adapted SQL, i created the 'Characters' 'MaNGOS' & 'Realmd' databases.

Inside each database, i launched the 'characters.sql' 'mangos.sql' & 'realmd.sql'.

My databases are ready. Now, i put the updates. I start with the first folder: 0.5, and execute each sql file i find inside it:

- 1150_character_aura.sql into 'characters' db

- 1155_commands.sql into 'mangos' db

- 1155_npc_option.sql into 'mangos' db

- 1158_character_inventory.sql into 'characters' db

... ouch, what's wrong? I got an error!

[Err] 1060 - Duplicate column name 'bag'
[Err] ALTER TABLE `character_inventory` ADD `bag` TINYINT( 3 ) DEFAULT '0' NOT NULL AFTER `guid` ;

ALTER TABLE `character_inventory` DROP PRIMARY KEY ,
ADD INDEX `idx_guid` ( `guid` , `bag` ) ;
[Msg] Finished - Unsuccessfully
--------------------------------------------------

I try to execute again but, it still not work.

I tried to fully reinstall my entire database... but when i execute this sql one, i still got the same error.

My questions are:

- Am I doing something wrong?

- Am I missunderstanding how to install updates?

- Should I install first:

--> z2192_s1825_12278_01_mangos_creature_template.sql

--> z2193_s1826_12279_01_mangos_creature_template.sql

--> etc., then the updates folders (0.5/0.6/etc.)?

- Or should I install first the update folders, and then the Zxxx_Sxxx SQL updates ?

- What is the real order of installing updates? ("characters, mangos, realmd, scriptdev2" or "characters,mangos, scriptdev2, realmd" or another order)

I tried to use the Wiki from GetMangos, but it's really concise and actually incomplete. So it's a bit hard when there are no all the tutorials.

Actually, I'm using Google and other forums to learn how to do correctly, but it's not an easy way. Maybe I'm doing something wrong, but I don't know what.

I repeat: it's for my only personal use. I'm a newbie about the scripting and SQL but I want to learn how it works. And it's a little project I would like to accomplish!

My system :

CPU: Intel Pentium E5200 (Socket 775, dual core)

MotherBoard: Asus P5KPL-AM

Memory : 4 gb DDR2

Windows Server 2012 Standard x64

WampServer 2.2E x64 (apache 2.4.2 / php 5.4.3 / MySQL 5.5.24)

Navicat 10.x Enterprise

Microsoft Visual Studio Express 2012

Need help on understanding how to do correctly!

Thanks a lot for your answers.

Sincerely,

V77 (France)