- Code: Select all
Quests could not be deleted
1016: Can't open file: 'roster_quests.MYI' (errno: 145)
And here's what I get when I try to go to the Keys page.
- Code: Select all
Database Error
1016: Can't open file: 'roster_quests.MYI' (errno: 145)
SQL:
SELECT members.name, sum(if(quests.quest_name = 'Scholomance', 1, 0)) AS Scholo1, sum(if(quests.quest_name = 'Skeletal Fragments', 1, 0)) AS Scholo2, sum(if(quests.quest_name = 'Mold Rhymes With...', 1, 0)) AS Scholo3, sum(if(quests.quest_name = 'Fire Plume Forged', 1, 0)) AS Scholo4, sum(if(quests.quest_name = 'Araj\'s Scarab', 1, 0)) AS Scholo5, sum(if(quests.quest_name = 'The Key to Scholomance', 1, 0)) AS Scholo6, sum(if(quests.quest_name = 'Warlord\'s Command', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Eitrigg\'s Wisdom', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'For The Horde!', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'What the Wind Carries', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'The Champion of the Horde', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'The Testament of Rexxar', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Oculus Illusions', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Emberstrife', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'The Test of Skulls, Scryer', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'The Test of Skulls, Somnus', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'The Test of Skulls, Chronalis', 1, 0)) AS Onyxia11, sum(if(quests.quest_name = 'The Test of Skulls, Axtroz', 1, 0)) AS Onyxia12, sum(if(quests.quest_name = 'Ascension...', 1, 0)) AS Onyxia13, sum(if(quests.quest_name = 'Blood of the Black Dragon Champion', 1, 0)) AS Onyxia14 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 15 AND ( quests.quest_name = 'Scholomance' OR quests.quest_name = 'Skeletal Fragments' OR quests.quest_name = 'Mold Rhymes With...' OR quests.quest_name = 'Fire Plume Forged' OR quests.quest_name = 'Araj\'s Scarab' OR quests.quest_name = 'The Key to Scholomance' OR quests.quest_name = 'Warlord\'s Command' OR quests.quest_name = 'Eitrigg\'s Wisdom' OR quests.quest_name = 'For The Horde!' OR quests.quest_name = 'What the Wind Carries' OR quests.quest_name = 'The Champion of the Horde' OR quests.quest_name = 'The Testament of Rexxar' OR quests.quest_name = 'Oculus Illusions' OR quests.quest_name = 'Emberstrife' OR quests.quest_name = 'The Test of Skulls, Scryer' OR quests.quest_name = 'The Test of Skulls, Somnus' OR quests.quest_name = 'The Test of Skulls, Chronalis' OR quests.quest_name = 'The Test of Skulls, Axtroz' OR quests.quest_name = 'Ascension...' OR quests.quest_name = 'Blood of the Black Dragon Champion') GROUP BY members.name ORDER BY members.name ASC
File: membersinst.php
Line: 297
