500 - DB function failed with error number 126
Incorrect key file for table '/tmp/#sql_2606_0.MYI'; try to repair it SQL=SELECT a.*, COUNT(DISTINCT(a.id)), IF( a.groupid>0, IF( c.approvals=0,true,(SELECT COUNT( DISTINCT(s.id) ) FROM `jos_community_photos_albums` AS s RIGHT JOIN `jos_community_groups_members` AS t ON s.groupid=t.groupid WHERE t.memberid='0' AND t.approved=1) ), true ) AS display FROM `jos_community_photos_albums` AS a INNER JOIN `jos_community_photos` AS b ON a.id=b.albumid LEFT JOIN `jos_community_groups` AS c ON a.groupid = c.id GROUP BY a.id HAVING display=true

You may not be able to visit this page because of:

  1. an out-of-date bookmark/favourite
  2. a search engine that has an out-of-date listing for this site
  3. a mistyped address
  4. you have no access to this page
  5. The requested resource was not found.
  6. An error has occurred while processing your request.

Please try one of the following pages:

If difficulties persist, please contact the System Administrator of this site.

DB function failed with error number 126
Incorrect key file for table '/tmp/#sql_2606_0.MYI'; try to repair it SQL=SELECT a.*, COUNT(DISTINCT(a.id)), IF( a.groupid>0, IF( c.approvals=0,true,(SELECT COUNT( DISTINCT(s.id) ) FROM `jos_community_photos_albums` AS s RIGHT JOIN `jos_community_groups_members` AS t ON s.groupid=t.groupid WHERE t.memberid='0' AND t.approved=1) ), true ) AS display FROM `jos_community_photos_albums` AS a INNER JOIN `jos_community_photos` AS b ON a.id=b.albumid LEFT JOIN `jos_community_groups` AS c ON a.groupid = c.id GROUP BY a.id HAVING display=true