Jump to content

DB table `mangos_string` is empty

moesi

By moesi
in Archived Help and support

Recommended Posts

moesi Newbie

moesi

Posted
Posted

Hi guys!

After some hours spending getting the vanilla server running i get this error:

>> Loaded 0 mangos strings. DB table `mangos_string` is empty. Can not continue.

Have i missed a sql-script?

I am running on Ubuntu server 14.04?

greetings

thehu

Edit: Ok i forgot to mention, i know why it is empty, but i cant run: (always different errors)

cd /home/mangos/database

bash make_full_WorldDB.sh

mysql -u root -p mangos < full_db.sql

like said in the wiki.

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

$ ./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.1f 6 Jan 2014 (Library: OpenSSL 1.0.1f 6 Jan 2014)

Using ACE: 6.3.0

World Database total connections: 2

Connected to MySQL database [email protected]:3306/mangos

MySQL client library: 5.5.43

MySQL server ver: 5.5.43-0ubuntu0.14.04.1

AUTOCOMMIT SUCCESSFULLY SET TO 1

Connected to MySQL database [email protected]:3306/mangos

MySQL client library: 5.5.43

MySQL server ver: 5.5.43-0ubuntu0.14.04.1

AUTOCOMMIT SUCCESSFULLY SET TO 1

Character Database total connections: 2

Connected to MySQL database [email protected]:3306/characters

MySQL client library: 5.5.43

MySQL server ver: 5.5.43-0ubuntu0.14.04.1

AUTOCOMMIT SUCCESSFULLY SET TO 1

Connected to MySQL database [email protected]:3306/characters

MySQL client library: 5.5.43

MySQL server ver: 5.5.43-0ubuntu0.14.04.1

AUTOCOMMIT SUCCESSFULLY SET TO 1

Login Database total connections: 2

Connected to MySQL database [email protected]:3306/realmd

MySQL client library: 5.5.43

MySQL server ver: 5.5.43-0ubuntu0.14.04.1

AUTOCOMMIT SUCCESSFULLY SET TO 1

Connected to MySQL database [email protected]:3306/realmd

MySQL client library: 5.5.43

MySQL server ver: 5.5.43-0ubuntu0.14.04.1

AUTOCOMMIT SUCCESSFULLY SET TO 1

Realm running as realm ID 1

Using World DB: MaNGOSZero Database Rev 21000_17

Using creature EventAI: No EventAI or Scripts available

Using DataDir /home/mangos/data/

WORLD: VMap support included. LineOfSight:1, getHeight:1, indoorCheck:1

WORLD: VMap data directory is: /home/mangos/data/vmaps

WORLD: MMap pathfinding enabled

Loading MaNGOS strings...

Loading texts from mangos_string

[**************************************************] 100%

>> Loaded 0 mangos strings. DB table `mangos_string` is empty. Can not continue.

Olion Advanced Member

Olion

Posted
Posted

You're correct in using develop21 branch as the latest one, but someone introduced an error into the make_full_WorldDB.sh file at the branch. You have to fix it manually changing

World/Setup/mangodLoadDB.sql

in the last text line of the file to

World/Setup/mangosdLoadDB.sql

moesi Newbie

moesi

Posted
  • Author
Posted

Thx for the quick reply!

after changing the line i face a new problem:

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

$ mysql -u root -p mangos < full_db.sql

Enter password: ...

ERROR 1062 (23000) at line 465704: Duplicate entry 'MaNGOSZero Database Rev 21000_17' for key 'PRIMARY'

line in the file looks like:

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

LOCK TABLES `db_version` WRITE;

/*!40000 ALTER TABLE `db_version` DISABLE KEYS */;

THAT ONE!!! ----> INSERT INTO `db_version` (`version`, `creature_ai_version`, `required_21000_17_dbdocslanguage`) VALUES ('ZeroDatabase 2.0.18 for MaNGOSZero / ScriptDev 20004+','MaNGOSZero Artificial Creature Intelligence Database',NULL),('MaNGOSZero Database 2.0.11 Rev 20007_18','EventAI and Scripts available',NULL),('MaNGOSZero Database 2.0.11 Rev 20007_19',NULL,NULL),('MaNGOSZero Database 2.0.11 Rev 20007_20',NULL,NULL),('MaNGOSZero Database Rev 21000_02',NULL,NULL),('MaNGOSZero Database Rev 21000_03',NULL,NULL),('MaNGOSZero Database Rev 21000_04',NULL,NULL),('MaNGOSZero Database Rev 21000_05',NULL,NULL),('MaNGOSZero Database Rev 21000_06',NULL,NULL),('MaNGOSZero Database Rev 21000_07',NULL,NULL),('MaNGOSZero Database Rev 21000_08',NULL,NULL),('MaNGOSZero Database 2.0.09 Rev 21000_09',NULL,NULL),('MaNGOSZero Database Rev 21000_10',NULL,NULL),('MaNGOSZero Database Rev 21000_11',NULL,NULL),('MaNGOSZero Database Rev 21000_12',NULL,NULL),('MaNGOSZero Database Rev 21000_13',NULL,NULL),('MaNGOSZero Database Rev 21000_14',NULL,NULL),('MaNGOSZero Database Rev 21000_17',NULL,NULL),('MaNGOSZero Database Rev 21000_17',NULL,NULL),('MaNGOSZero Database Rev 21000_17',NULL,NULL);

$

/*!40000 ALTER TABLE `db_version` ENABLE KEYS */;

UNLOCK TABLES;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

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

I am not sure if thats correct if i comment out that line. When i do so, i can start the server, but cant login to the realm. (freezes after selecting a realm)

world-server.log is full with such entries:

2015-07-09 17:13:50 <SD2 ERROR>: Script registering but ScriptName npc_dorius_stonetender is not assigned in database. Script will not be used.

and

2015-07-09 17:13:50 ERROR:SD2: DB table script_waypoint has waypoint for creature entry 11016, but creature does not have ScriptName defined and then useless.

greetings

Olion Advanced Member

Olion

Posted
Posted
ERROR 1062 (23000) at line 465704: Duplicate entry 'MaNGOSZero Database Rev 21000_17' for key 'PRIMARY'

line in the file looks like:

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

LOCK TABLES `db_version` WRITE;

/*!40000 ALTER TABLE `db_version` DISABLE KEYS */;

THAT ONE!!! ----> INSERT INTO `db_version`...

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

I am not sure if thats correct if i comment out that line. When i do so, i can start the server, but cant login to the realm. (freezes after selecting a realm)

You may drop all the content of the "db_version" table providing the table exists. I suppose the mysql client have stopped after this error, so no table after this one was filled.

To fix this, comment out the line you pointed at and reapply the modified "full_db.sql" file with mysql. It may be not the last problem, but we are unaware of these problems because have set up the server from scratch long ago, and the 2 issues from this topic were introduced just a month ago.

  • 3 months later...
flux Newbie

flux

Posted
Posted

I am getting the same error as OP.

2015-10-13 02:14:43 21000 [world-daemon]

2015-10-13 02:14:43 <Ctrl-C> to stop.

__ __ _ _ ___ ___ ___

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

| |\/| / _` | .` | (_ | (_) \__ \ Burning Crusade

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

___

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

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

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

2015-10-13 02:14:43 Using configuration file mangosd.conf.

2015-10-13 02:14:43 World Database total connections: 2

2015-10-13 02:14:43 MySQL client library: 5.6.26

2015-10-13 02:14:43 MySQL server ver: 5.6.25-log

2015-10-13 02:14:43 MySQL client library: 5.6.26

2015-10-13 02:14:43 MySQL server ver: 5.6.25-log

2015-10-13 02:14:43 Character Database total connections: 2

2015-10-13 02:14:43 MySQL client library: 5.6.26

2015-10-13 02:14:43 MySQL server ver: 5.6.25-log

2015-10-13 02:14:43 MySQL client library: 5.6.26

2015-10-13 02:14:43 MySQL server ver: 5.6.25-log

2015-10-13 02:14:43 Login Database total connections: 2

2015-10-13 02:14:43 MySQL client library: 5.6.26

2015-10-13 02:14:43 MySQL server ver: 5.6.25-log

2015-10-13 02:14:43 MySQL client library: 5.6.26

2015-10-13 02:14:43 MySQL server ver: 5.6.25-log

2015-10-13 02:14:43

2015-10-13 02:14:43 Realm running as realm ID 1

2015-10-13 02:14:43

2015-10-13 02:14:43 Using World DB: Version: 21, Structure: 1, Content: 0

2015-10-13 02:14:43

2015-10-13 02:14:43 Using DataDir E:\mangosdownload\database/

2015-10-13 02:14:43 WORLD: VMap support included. LineOfSight:1, getHeight:1, indoorCheck:1

2015-10-13 02:14:43 WORLD: VMap data directory is: E:\mangosdownload\database/vmaps

2015-10-13 02:14:43 WORLD: MMap pathfinding enabled

2015-10-13 02:14:43

2015-10-13 02:14:43 Loading MaNGOS strings...

2015-10-13 02:14:43 Loading texts from mangos_string

2015-10-13 02:14:43

2015-10-13 02:14:43 ERROR:>> Loaded 0 mangos strings. DB table `mangos_string` is empty. Can not continue.

  • 2 months later...
Akka Newbie

Akka

Posted
Posted

Had this same error, and from what I've seen the reason is that the full_db.sql includes an error, which crash the actual content export.

It seems that the entry 'MaNGOSZero Database Rev 21000_17' is added early in the script, and then added again when the db_version table is filled (line 458456), which causes a duplicate primary key and stops the script, hence ending with tons of table empty.

I removed the second duplicate, which allowed the full_db.sql scripts to run completely. Don't forget to also run the "21000_22_db_version.sql" after that to update the version.

Archived

This topic is now archived and is closed to further replies.

Go to topic listing

Contact Us

To contact us click here
You can also email us at [email protected]

Privacy Policy | Terms & Conditions

Repositories

The Link to the master list
of MaNGOS repositories:
Copyright © getMaNGOS. All rights Reserved.

This website is in no way associated with or endorsed by Blizzard Entertainment®
×
×
  • 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