Noobie looking for help

teddybairs1 · May 26, 2015

I am running Debian Stretch/Sid. I just got mangoszero-server-master to compile using a script I found online. I've been trying to figure out how to extract the data files from the Warcraft 1.12 folder (also found online) in order to get it to run (as well as direct the configuration files in the right direction). Looking online, there seems to be several references to binaries or scripts for extracting the data and maps from the Warcraft Data folder, but I can't seem to find them in folders created after compilation.

I'm not sure of the mangoszero version, it was just called mangoszero-server online. According to the change-log it is 0.19 (2014-07-09) - Ludas Legacy. I have another version in another tarball which I downloaded from this site as well: MangosZero_Rel20_Release_x32_March2015

The script is just called "mangos-installer".

Should I use the script to compile this one instead? The script is the only way I've been able to get it to compile. I'm not really a coder (I've only learned a little C++ and BASIC, but I'm really rusty in both). I've only been able to get a few things to successfully compile on my own by following good instructions for noobies.

I would really like to get this running. I recently discovered WoW, but I don't like that I have to be online to play it.

I realize I'm just a noob, and these questions are probably very easily answered, but if you could just direct me to those answers I'd appreciate it. Thank you.

Foereaper · May 26, 2015

Hey there,

The current development is running on the branch develop21, which is what I'd recommend using for now.

Server files: "git clone https://github.com/mangoszero/server -b develop21 --recursive"

Database files: "git clone https://github.com/mangoszero/database -b develop21 --recursive"

Then follow this guide to compile and set up your server:

https://getmangos.eu/wiki/Installation%20Guides/Linux/Debianinstall.md

teddybairs1 · May 26, 2015

I'll give that a shot. Thanks.

teddybairs1 · May 27, 2015

Okay, I've gotten to point 6. on the Debian Install, Importing the Mysql Database. I've tried entering the command line sequence for number one and it keeps telling me that the database for realmd doesn't exist. "ERROR 1049 (42000): Unknown database 'realmd'"

All I'm doing is copying and pasting the command and changing the home folder to the installation home folder like it said to.

Ravieh · May 27, 2015

Just remembered I had the same.

Try it like this.

mysql -u root -p < /home/mangos/database/Realm/Setup/realmdCreateDB.sql

mysql -u root -p realmd < /home/mangos/database/Realm/Setup/realmdLoadDB.sql

mysql -u root -p < /home/mangos/database/Character/Setup/characterCreateDB.sql

mysql -u root -p characters < /home/mangos/database/Character/Setup/characterLoadDB.sql

mysql -u root -p < /home/mangos/database/World/Setup/mangosdCreateDB.sql

mysql -u root -p mangos < /home/mangos/database/World/Setup/mangosdLoadDB.sql

teddybairs1 · May 27, 2015

Okay, so here's my output so far. I'd appreciate it if someone can tell me where I've gone wrong.

allen@allen-3541:~$ mysql -u root -p < /home/allen/database/Realm/Setup/realmdCreateDB.sql

Enter password:

allen@allen-3541:~$ mysql -u root -p realmd < /home/allen/database/Realm/Setup/realmdLoadDB.sql

Enter password:

allen@allen-3541:~$ mysql -u root -p < /home/allen/database/Character/Setup/characterCreateDB.sql

Enter password:

ERROR 1396 (HY000) at line 3: Operation CREATE USER failed for 'mangos'@'localhost'

allen@allen-3541:~$ mysql -u root -p < /home/allen/database/Character/Setup/characterCreateDB.sql

Enter password:

ERROR 1007 (HY000) at line 1: Can't create database 'characters'; database exists

allen@allen-3541:~$ cd database

allen@allen-3541:~/database$ ls

Character InstallDatabases.bat make_full_WorldDB.sh Realm World

icons LICENSE.md README.md Tools

allen@allen-3541:~/database$ cd Tools

allen@allen-3541:~/database/Tools$ ls

backupDB.cmd make_full_db.bat mysql.exe

cleanup make_full_db.sh postgre_compatibility_addon.sql

drop_mysql.sql mangos_spell_check.sql updateRealm.sql

dump_tables.sh mysqldump.exe

allen@allen-3541:~/database/Tools$ mysql -u root -p characters < /home/allen/database/Character/Setup/characterLoadDB.sql

Enter password:

allen@allen-3541:~/database/Tools$ mysql -u root -p < /home/allen/database/World/Setup/mangosdCreateDB.sql

Enter password:

ERROR 1007 (HY000) at line 3: Can't create database 'characters'; database exists

allen@allen-3541:~/database/Tools$ mysql -u root -p mangos < /home/allen/database/World/Setup/mangosdLoadDB.sql

Enter password:

allen@allen-3541:~/database/Tools$ cat /home/mangos/database/World/Update/Rel21/*.sql >> /home/mangos/all.sql

bash: /home/mangos/all.sql: No such file or directory

allen@allen-3541:~/database/Tools$ cat /home/allen/database/World/Update/Rel21/*.sql >> /home/mangos/all.sql

bash: /home/mangos/all.sql: No such file or directory

allen@allen-3541:~/database/Tools$ cat /home/allen/database/World/Update/Rel21/*.sql >> /home/allen/all.sql

cat: /home/allen/database/World/Update/Rel21/*.sql: No such file or directory

allen@allen-3541:~/database/Tools$ cat /home/allen/database/World/Updates/Rel21/*.sql >> /home/allen/all.sql

allen@allen-3541:~/database/Tools$ mysql -u root -p mangos < /home/allen/all.sqlEnter password:

Status Required Version Found Version

* UPDATE SKIPPED * required_20007_20_Hotfix_Corrections_to_RegenerateStatsrequired_20007_01_Rel20_Release_Prep

Status Required Version Found Version

* UPDATE SKIPPED * required_21000_01_Release21_initial required_20007_01_Rel20_Release_Prep

Status Required Version Found Version

* UPDATE SKIPPED * required_21000_02_Waypoint_update required_20007_01_Rel20_Release_Prep

Status Required Version Found Version

* UPDATE SKIPPED * required_21000_02_Waypoint_update required_20007_01_Rel20_Release_Prep

Status Required Version Found Version

* UPDATE SKIPPED * required_21000_02_Waypoint_update required_20007_01_Rel20_Release_Prep

Status Required Version Found Version

* UPDATE SKIPPED * required_21000_05_Script_refactoring required_20007_01_Rel20_Release_Prep

Status Required Version Found Version

* UPDATE SKIPPED * required_21000_05_Script_refactoring required_20007_01_Rel20_Release_Prep

ERROR 1054 (42S22) at line 6305: Unknown column 'required_21000_05_Script_refactoring' in 'db_version'

allen@allen-3541:~/database/Tools$ cd ..

allen@allen-3541:~/database$ bash make_full_WorldDB.sh

allen@allen-3541:~/database$ mysql -u root -p mangos < full_db.sql

Enter password:

allen@allen-3541:~/database$ cd ..

allen@allen-3541:~$ cd zero

allen@allen-3541:~/zero$ cd bin

allen@allen-3541:~/zero/bin$ ls

lua_scripts mangosd realmd tools

allen@allen-3541:~/zero/bin$ ./realmd

Could not find configuration file ../etc/realmd.conf.

allen@allen-3541:~/zero/bin$ ./realmd

21000 [realm-daemon]

<Ctrl-C> to stop.

Using configuration file ../etc/realmd.conf.

Login Database total connections: 2

MySQL client library: 5.5.43

MySQL server ver: 5.5.42-1

MySQL client library: 5.5.43

MySQL server ver: 5.5.42-1

SQL: SELECT required_20150420_warden_db_log FROM realmd_db_version LIMIT 1

query ERROR: Unknown column 'required_20150420_warden_db_log' in 'field list'

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

[A] You have: --> `20150409_Playerbot_and_Warden.sql`

You need: --> `20150420_warden_db_log.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.

allen@allen-3541:~/zero/bin$ cat /home/allen/database/World/Updates/Rel21/*.sql >> /home/allen/all.sql

allen@allen-3541:~/zero/bin$ cat /home/allen/database/World/Updates/Rel20/*.sql >> /home/allen/all.sql

allen@allen-3541:~/zero/bin$ mysql -u root -p mangos < /home/allen/all.sql

Enter password:

Status Required Version Found Version

* UPDATE SKIPPED * required_20007_20_Hotfix_Corrections_to_RegenerateStatsrequired_20007_01_Rel20_Release_Prep

Status Required Version Found Version

* UPDATE SKIPPED * required_21000_01_Release21_initial required_20007_01_Rel20_Release_Prep

Status Required Version Found Version

* UPDATE SKIPPED * required_21000_02_Waypoint_update required_20007_01_Rel20_Release_Prep

Status Required Version Found Version

* UPDATE SKIPPED * required_21000_02_Waypoint_update required_20007_01_Rel20_Release_Prep

Status Required Version Found Version

* UPDATE SKIPPED * required_21000_02_Waypoint_update required_20007_01_Rel20_Release_Prep

Status Required Version Found Version

* UPDATE SKIPPED * required_21000_05_Script_refactoring required_20007_01_Rel20_Release_Prep

Status Required Version Found Version

* UPDATE SKIPPED * required_21000_05_Script_refactoring required_20007_01_Rel20_Release_Prep

ERROR 1054 (42S22) at line 6305: Unknown column 'required_21000_05_Script_refactoring' in 'db_version'

allen@allen-3541:~/zero/bin$ ./realmd

21000 [realm-daemon]

<Ctrl-C> to stop.

Using configuration file ../etc/realmd.conf.

Login Database total connections: 2

MySQL client library: 5.5.43

MySQL server ver: 5.5.42-1

MySQL client library: 5.5.43

MySQL server ver: 5.5.42-1

SQL: SELECT required_20150420_warden_db_log FROM realmd_db_version LIMIT 1

query ERROR: Unknown column 'required_20150420_warden_db_log' in 'field list'

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

[A] You have: --> `20150409_Playerbot_and_Warden.sql`

You need: --> `20150420_warden_db_log.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.

Ravieh · May 27, 2015

You are on the exact same point I am now.

If I understand correctly you need to do exactly what it says.

[A] You have: --> `20150409_Playerbot_and_Warden.sql`

You need: --> `20150420_warden_db_log.sql`

In realmd/Updates/Rel21/ you have:

20150409_Playerbot_and_Warden.sql

20150412_01_warden_db_log.sql

20150412_02_auth_realmlist.sql

20150420_03_warden_db_log.sql

so first run: mysql -u root -p realmd < 20150412_01_warden_db_log.sql

after that you would think it needs the next one, but nooo, that gives an error

mysql -u root -p realmd < 20150412_02_auth_realmlist.sql

Status Required Version Found Version

* UPDATE SKIPPED * required_20150412_warden_db_log required_20150412_auth_realmlist

so I guess that already went in with the first one.

next:

mysql -u root -p realmd < 20150420_03_warden_db_log.sql

Status DB is now on Version

* UPDATE COMPLETE * required_20150420_warden_db_log

Now realmd should run

teddybairs1 · May 27, 2015

Okay, I did this, and got this:

allen@allen-3541:~/database/Realm/Updates/Rel21$ mysql -u root -p realmd < 20150412_01_warden_db_log.sql

Enter password:

Status DB is now on Version

* UPDATE COMPLETE * required_20150412_warden_db_log

allen@allen-3541:~/database/Realm/Updates/Rel21$ cd ..

allen@allen-3541:~/database/Realm/Updates$ cd /home/allen/zero/bin

allen@allen-3541:~/zero/bin$ ls

lua_scripts mangosd realmd realm-list.log tools

allen@allen-3541:~/zero/bin$ ./realmd

21000 [realm-daemon]

<Ctrl-C> to stop.

Using configuration file ../etc/realmd.conf.

Login Database total connections: 2

MySQL client library: 5.5.43

MySQL server ver: 5.5.42-1

MySQL client library: 5.5.43

MySQL server ver: 5.5.42-1

SQL: SELECT required_20150420_warden_db_log FROM realmd_db_version LIMIT 1

query ERROR: Unknown column 'required_20150420_warden_db_log' in 'field list'

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

[A] You have: --> `20150412_warden_db_log.sql`

You need: --> `20150420_warden_db_log.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.

allen@allen-3541:~/zero/bin$ cd /home/allen/database/Realm/Updates/Rel21

allen@allen-3541:~/database/Realm/Updates/Rel21$ ls

20150409_Playerbot_and_Warden.sql 20150412_02_auth_realmlist.sql

20150412_01_warden_db_log.sql 20150420_03_warden_db_log.sql

allen@allen-3541:~/database/Realm/Updates/Rel21$ mysql -u root -p realmd < 20150420_03_warden_db_log.sql

Enter password:

Status Required Version Found Version

* UPDATE SKIPPED * required_20150412_auth_realmlist required_20150412_warden_db_log

allen@allen-3541:~/database/Realm/Updates/Rel21$

I appreciate the time you're taking here, btw.

Ravieh · May 27, 2015

Try this one..

mysql -u root -p realmd < 20150420_03_warden_db_log.sql

Status DB is now on Version

* UPDATE COMPLETE * required_20150420_warden_db_log

teddybairs1 · May 27, 2015

Okay, realmd is working, now this is the output I'm getting from mangosd

allen@allen-3541:~$ ./mangosd

bash: ./mangosd: No such file or directory

allen@allen-3541:~$ cd /home/allen/zero/bin

allen@allen-3541:~/zero/bin$ ./mangosd

21000 [world-daemon]

<Ctrl-C> to stop.

__ __ _ _ ___ ___ ___

| \/ |__ _| \| |/ __|/ _ \/ __| We Love

| |\/| / _` | .` | (_ | (_) \__ \ Vanilla Wow

|_| |_\__,_|_|\_|\___|\___/|___/

____

For help and support please visit: /_ /___ _ _ ___

Website: https://getmangos.eu / // -_) '_/ _ \

Wiki: MaNGOS Wiki Â· GitHub /___\___|_| \___/

Using configuration file ../etc/mangosd.conf.

OpenSSL 1.0.2a 19 Mar 2015 (Library: OpenSSL 1.0.2a 19 Mar 2015)

Using ACE: 6.3.0

World Database total connections: 2

Could not connect to MySQL database at 127.0.0.1: Access denied for user 'mangos'@'localhost' to database 'mangos'

Can not connect to world database 127.0.0.1;3306;mangos;mangos;mangos

allen@allen-3541:~/zero/bin$

Ravieh · May 27, 2015

I can't help you any further right now because I';m still stuck at updating the mangos db... (last time I did it it went more smooth lol, that's the fun with dev versions I guess)

[A] You have: --> `20007_01_Rel20_Release_Prep.sql`

You need: --> `21000_13_Backports.sql`

Hope a dev can chime in.

Rutger

teddybairs1 · May 27, 2015

I think I know where I went wrong. Thanks for everything. I'll probably holler again in a few. This is my first time installing something this complex from source.

Foereaper · May 27, 2015

Could not connect to MySQL database at 127.0.0.1: Access denied for user 'mangos'@'localhost' to database 'mangos'

Can not connect to world database 127.0.0.1;3306;mangos;mangos;mangos

allen@allen-3541:~/zero/bin$

This means mangosd was not able to connect to/authenticate your database using the settings above (Wrong username/password/database name?) Make sure the information in your config file is correct.

Foereaper · May 27, 2015

I can't help you any further right now because I';m still stuck at updating the mangos db... (last time I did it it went more smooth lol, that's the fun with dev versions I guess)
[A] You have: --> `20007_01_Rel20_Release_Prep.sql`

You need: --> `21000_13_Backports.sql`

Hope a dev can chime in.

Rutger

What you need to do is run the Rel20 updates > than the database version you currently have. You have version 20007_01, thus you need the versions greater than that, found in the Updates/Rel20 folder. After you have ran all the updates needed from Updates/Rel20, run the updates found in Updates/Rel21 and you should be good to go!

Ravieh · May 27, 2015

On phone atm..

@foereaper that's what i tried but somehow that doesn't give me any output at all. Not skipped/failed or whatsoever.

Weird.

teddybairs1 · May 28, 2015

This means mangosd was not able to connect to/authenticate your database using the settings above (Wrong username/password/database name?) Make sure the information in your config file is correct.

Yeah, that's what I figured. Now I just need to figure out how to configure it correctly.

teddybairs1 · May 28, 2015

@Ravieh & @foereaper, I sorted out the user issues, but have now run into the same thing as Ravieh. I just went through by hand and added all the updates that it told me to from ~/Rel20 and then attempted to add the ones from ~/Rel21 and this is what I got:

allen@allen-3541:~/database/World/Updates/Rel21$ mysql -u root -p mangos < 21000_01_Release21_initial.sql

Enter password:

Status Required Version Found Version

* UPDATE SKIPPED * required_20007_20_Hotfix_Corrections_to_RegenerateStatsrequired_20007_01_Rel20_Release_Prep

Being a newbie, I didn't worry about whether or not it confirmed anything. I just plowed on ahead until I got here.

btw, I did the mysql for all the updates between 20007_20_Hotfix_Corrections_to_RegenerateStates.sql and 20007_01_Rel20_Release_Prep.sql so I don't know what it's talking about now.

Foereaper · May 28, 2015

I'll try to do a fresh database import today to see what the issue could be I'll keep you posted

Edit:

I see, it would seem the Rel20 base sets the wrong version in the db_version field! We'll get this fixed up shortly.

Edit 2:

Quick workaround that seems to work for me:

Run...

[color=#A71D5D]ALTER[/color] [color=#A71D5D]TABLE[/color] creature_template CHANGE ManaMultiplier PowerMultiplier float [color=#A71D5D]NOT NULL[/color] DEFAULT [color=#183691]'1'[/color];
[color=#A71D5D]ALTER[/color] [color=#A71D5D]TABLE[/color] creature_template CHANGE RegenerateHealth RegenerateStats [color=#A71D5D]tinyint[/color]([color=#0086B3]3[/color]) unsigned [color=#A71D5D]NOT NULL[/color] DEFAULT [color=#183691]'3'[/color];
[color=#A71D5D][font=Consolas]UPDATE[/font][/color][color=#333333][font=Consolas] creature_template [/font][/color][color=#A71D5D][font=Consolas]SET[/font][/color][color=#333333][font=Consolas] RegenerateStats[/font][/color][color=#A71D5D][font=Consolas]=[/font][/color][color=#333333][font=Consolas]RegenerateStats|[/font][/color][color=#0086B3][font=Consolas]2[/font][/color][color=#333333][font=Consolas];[/font][/color]
[/Code]

Then run 20007_02 and continue updating from there. Once you are done with Rel20 updates, run the below:
[code]
-- --------------------------------------------------------------------------------
-- This is an attempt to create a full transactional update
-- --------------------------------------------------------------------------------
DROP PROCEDURE IF EXISTS `update_mangos`; 


DELIMITER $$


CREATE DEFINER=`getmango`@`localhost` PROCEDURE `update_mangos`()
BEGIN
   DECLARE bRollback BOOL  DEFAULT FALSE ;
   DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET `bRollback` = TRUE;


 SET @cOldRev = 'required_20007_01_Rel20_Release_Prep'; 


 -- Set the new revision string
 SET @cNewRev = 'required_20007_20_Hotfix_Corrections_to_RegenerateStats';


 -- Set thisRevision to the column name of db_version in the currently selected database
 SET @cThisRev := ((SELECT column_name FROM information_schema.`COLUMNS` WHERE table_name='db_version' AND table_schema=(SELECT DATABASE() AS thisDB FROM DUAL) AND column_name LIKE 'required%'));



 -- Only Proceed if the old values match
 IF @cThisRev = @cOldRev THEN
   -- Make this all a single transaction
   START TRANSACTION;


   -- Apply the Version Change from Old Version to New Version
   SET @query = CONCAT('ALTER TABLE db_version CHANGE COLUMN ',@cOldRev, ' ' ,@cNewRev,' bit;');
   PREPARE stmt1 FROM @query;
   EXECUTE stmt1;
   DEALLOCATE PREPARE stmt1;
   -- The Above block is required for making table changes


   -- -- -- -- Normal Update / Insert / Delete statements will go here  -- -- -- -- --

   -- Just changing the version this time    

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

   -- If we get here ok, commit the changes
   IF bRollback = TRUE THEN
     ROLLBACK;
     SELECT '* UPDATE FAILED *' AS 'Status',@cThisRev AS 'DB is on Version';
   ELSE
     COMMIT;
     SELECT '* UPDATE COMPLETE *' AS 'Status',@cNewRev AS 'DB is now on Version';
   END IF;
 ELSE
   SELECT '* UPDATE SKIPPED *' AS 'Status',@cOldRev AS 'Required Version',@cThisRev AS 'Found Version';
 END IF;


END $$


DELIMITER ;


-- Execute the procedure
CALL update_mangos();


-- Drop the procedure
DROP PROCEDURE IF EXISTS `update_mangos`;

Then continue on from 21000_01 and up to 21000_08

Once 21000_08 has been added, run the below:

-- --------------------------------------------------------------------------------
-- This is an attempt to create a full transactional update
-- --------------------------------------------------------------------------------
DROP PROCEDURE IF EXISTS `update_mangos`; 


DELIMITER $$


CREATE DEFINER=`getmango`@`localhost` PROCEDURE `update_mangos`()
BEGIN
   DECLARE bRollback BOOL  DEFAULT FALSE ;
   DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET `bRollback` = TRUE;


 SET @cOldRev = 'required_21000_05_Script_refactoring'; 


 -- Set the new revision string
 SET @cNewRev = 'required_21000_08_warden_checks';


 -- Set thisRevision to the column name of db_version in the currently selected database
 SET @cThisRev := ((SELECT column_name FROM information_schema.`COLUMNS` WHERE table_name='db_version' AND table_schema=(SELECT DATABASE() AS thisDB FROM DUAL) AND column_name LIKE 'required%'));



 -- Only Proceed if the old values match
 IF @cThisRev = @cOldRev THEN
   -- Make this all a single transaction
   START TRANSACTION;


   -- Apply the Version Change from Old Version to New Version
   SET @query = CONCAT('ALTER TABLE db_version CHANGE COLUMN ',@cOldRev, ' ' ,@cNewRev,' bit;');
   PREPARE stmt1 FROM @query;
   EXECUTE stmt1;
   DEALLOCATE PREPARE stmt1;
   -- The Above block is required for making table changes


   -- -- -- -- Normal Update / Insert / Delete statements will go here  -- -- -- -- --

   -- Just changing the version this time    

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

   -- If we get here ok, commit the changes
   IF bRollback = TRUE THEN
     ROLLBACK;
     SELECT '* UPDATE FAILED *' AS 'Status',@cThisRev AS 'DB is on Version';
   ELSE
     COMMIT;
     SELECT '* UPDATE COMPLETE *' AS 'Status',@cNewRev AS 'DB is now on Version';
   END IF;
 ELSE
   SELECT '* UPDATE SKIPPED *' AS 'Status',@cOldRev AS 'Required Version',@cThisRev AS 'Found Version';
 END IF;


END $$


DELIMITER ;


-- Execute the procedure
CALL update_mangos();


-- Drop the procedure
DROP PROCEDURE IF EXISTS `update_mangos`;

Then continue with 21000_09 and up to the required version

Ravieh · May 28, 2015

Thanks mr foe! I'll check when I get home

teddybairs1 · May 28, 2015

@Foereaper, thanks, will try later today. Um, how do I add it? Do I save it as an .sql and run it the same way as the updates, or what?

Foereaper · May 28, 2015

Yes, you can do that I updated my post as another step was required to move on. Continuing testing, then I will update my above post again if more is needed.

teddybairs1 · May 28, 2015

Okay. Thanks.

teddybairs1 · May 28, 2015

@foereaper, tried running your first fix:

allen@allen-3541:~/database/World/Updates$ mysql -u root -p mangos < mangosdb_fix1.sql

Enter password:

ERROR 1054 (42S22) at line 1: Unknown column 'ManaMultiplier' in 'creature_template'

Then thought maybe I should try running 20007_01 again just to make sure I had covered my bases and got this:

allen@allen-3541:~/database/World/Updates$ cd Rel20

allen@allen-3541:~/database/World/Updates/Rel20$ mysql -u root -p mangos < 20007_01_Rel20_Release_prep.sql

Enter password:

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

allen@allen-3541:~/database/World/Updates/Rel20$

Ideas?

Also, just tried running mangosd to see if all the update entry I did yesterday from ~/Rel20 took. Nope. It still says I need everything from 20007_01 to 21000_13.

Ravieh · May 28, 2015

I hope two people in one thread isn't too confusing:

Ok, what I just did: (just to start with a fresh database)

1. git clone --recursive https://www.github.com/mangoszero/database.git -b develop21

2. ran World/Setup/mangosdCreateDB.sql since that creates all databases and the mangos user

3. ran World/Setup/mangosdLoadDB.sql creates tables

4. ran Realm/Setup/realmdLoadDB.sql creates tables

5. ran Character/Setup/characterLoadDB.sql creates tables

6. ran below on mangos database:

ALTER TABLE creature_template CHANGE ManaMultiplier PowerMultiplier float NOT NULL DEFAULT '1';
ALTER TABLE creature_template CHANGE RegenerateHealth RegenerateStats tinyint(3) unsigned NOT NULL DEFAULT '3';

UPDATE creature_template SET RegenerateStats=RegenerateStats|2;

after that I end up with

#1054 - Unknown column 'RegenerateHealth' in 'creature_template'

Rutger

Foereaper · May 28, 2015

Bah. Antz is fixing up the issues with the database now, I'll have him chime in whenever it's all fixed up and should be straight forward for use

Sign In

Noobie looking for help

Recommended Posts

teddybairs1

Foereaper

teddybairs1

teddybairs1

Ravieh

teddybairs1

Ravieh

teddybairs1

Ravieh

teddybairs1

Ravieh

teddybairs1

Foereaper

Foereaper

Ravieh

teddybairs1

teddybairs1

Foereaper

Ravieh

teddybairs1

Foereaper

teddybairs1

teddybairs1

Ravieh

Foereaper

Archived

Recently Browsing 0 members

Contact Us

Repositories

Support

Wiki

Browse

Activity

My Activity Streams

Important Information