Jump to content
  • 0

No quests ingame, `mangos.quest_relations` does not exist


Valleion

Question

Posted

MangosZERO on windows64.

Ive followed REL21+ TEMPORARY COMPILE GUIDE

Server starts just fine and I can login without any problems but no quests appear in game.

A closer look at World-server.log states that DB table `quest_relations` is empty.

When connecting to the DB and looking at the tables I cant find a table called `quest_relations` just a table called 'gameobject_questrelation' is this the problem?

World-server.log

2016-04-14 02:07:33 Loading Quests...
2016-04-14 02:07:34 >> Loaded 4248 quests definitions
2016-04-14 02:07:34 
2016-04-14 02:07:34 Loading Quests Relations...
2016-04-14 02:07:34 ERROR:SQL: SELECT entry, quest FROM quest_relations WHERE actor = 1 AND role = 0
2016-04-14 02:07:34 ERROR:query ERROR: Table 'mangos.quest_relations' doesn't exist
2016-04-14 02:07:34 
2016-04-14 02:07:34 ERROR:>> Loaded 0 quest relations. DB table `quest_relations` is empty.
2016-04-14 02:07:34 ERROR:SQL: SELECT entry, quest FROM quest_relations WHERE actor = 1 AND role = 1
2016-04-14 02:07:34 ERROR:query ERROR: Table 'mangos.quest_relations' doesn't exist
2016-04-14 02:07:34 
2016-04-14 02:07:34 ERROR:>> Loaded 0 quest relations. DB table `quest_relations` is empty.
2016-04-14 02:07:34 ERROR:SQL: SELECT entry, quest FROM quest_relations WHERE actor = 0 AND role = 0
2016-04-14 02:07:34 ERROR:query ERROR: Table 'mangos.quest_relations' doesn't exist
2016-04-14 02:07:34 
2016-04-14 02:07:34 ERROR:>> Loaded 0 quest relations. DB table `quest_relations` is empty.
2016-04-14 02:07:34 ERROR:SQL: SELECT entry, quest FROM quest_relations WHERE actor = 0 AND role = 1
2016-04-14 02:07:34 ERROR:query ERROR: Table 'mangos.quest_relations' doesn't exist
2016-04-14 02:07:34 
2016-04-14 02:07:34 ERROR:>> Loaded 0 quest relations. DB table `quest_relations` is empty.
2016-04-14 02:07:34 >>> Quests Relations loaded

Everything else seems to load just fine, when running InstallDatabases.bat it gives no errors exept that DB mangos (world) already exists. I looked through \World\Updates\Rel21 and tried to add quest related .sql files like Rel21_05_6_quest_1948.sq but get this output:

Preparing...
Importing Rel21_05_6_quest_1948.sql...
Finished executing script
===== Status =====	=== Expected ===	===== Found Version =====
* UPDATE SKIPPED *	NULL	quest_relations
Operation completed successfully

I need some help here please! Not sure what to do.

2 answers to this question

Recommended Posts

Posted

Oh! I did not apply them in the right order! I changed the version of the database manually instead of applying Rel21_11_1_quest_relations.sql. I redid this and applied the update, now it works!

Archived

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

×
×
  • 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