Hi everyone,

I got a problem with the Quests views a) on the character details and b) on the search quest group screens.

Error on character page is:

Code: Select all

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in
/home/www/blablabla/roster/lib/wowdb.php on line 117

The funny thing is, I checked the file and line 117 is empty(??!)

Error on quest group screen is (it's a MySQL database error directly):

Code: Select all

Database Error
1016: Can't open file: 'roster_quests.MYI' (error: 145)

SQL:
SELECT DISTINCT quests.zone FROM 'roster_quests' quests,'roster_members' members
WHERE quests.member_id = members.member_id
ORDER BY quests.zone ASC

File: questlist.php

Line: 60

Anyone got any ideas?

Kind regards,
Tweetor

Code: Select all

Database Error
1016: Can't open file: 'roster_quests.MYI' (error: 145)

That would tend to indicate you have an actuialy MySQL data index corruption error.

Please go to your MySQL manuals for how best to resolve but *I think* form memory you can literally stop MySQL, rename the file, then restart to auto-recreate but don't quote me on that.

Fixed.

I could repair the table succesfully within myphpAdmin.

Thanks for giving me direction on this! :-)