500 - DB function failed with error number 23
Out of resources when opening file './lmft11_troylmft/jos_community_connection.MYD' (Errcode: 24) SQL=SELECT x.*, COUNT( DISTINCT(b.id) ) AS count, MAX(b.created) AS lastupdated FROM (SELECT a.`id`, a.`creator`, a.`name`, a.`description`, a.`permissions`, a.`created`, a.`path` , a.`type` , a.`groupid`, a.`location`, c.thumbnail, c.storage, c.id as photoid, IF( a.groupid>0, IF( d.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, CASE a.permissions WHEN 0 THEN true WHEN 20 THEN (SELECT COUNT(u.id) FROM `jos_users` AS u WHERE u.block=0 AND u.id='0') WHEN 30 THEN IF( a.creator='0' or 0, true, (SELECT COUNT(v.connection_id) FROM `jos_community_connection` AS v WHERE v.connect_from=a.creator AND v.connect_to='0' AND v.status=1) ) WHEN 40 THEN IF(a.creator='0' or 0,true,false) END AS privacy FROM `jos_community_photos_albums` AS a LEFT JOIN `jos_community_photos` AS c ON a.photoid=c.id LEFT JOIN `jos_community_groups` AS d ON a.groupid=d.id GROUP BY a.id HAVING display=true AND privacy=true ORDER BY a.`created` DESC ) AS x INNER JOIN `jos_community_photos` AS b ON x.id=b.albumid GROUP BY x.id ORDER BY x.`created` DESC

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 23
Out of resources when opening file './lmft11_troylmft/jos_community_connection.MYD' (Errcode: 24) SQL=SELECT x.*, COUNT( DISTINCT(b.id) ) AS count, MAX(b.created) AS lastupdated FROM (SELECT a.`id`, a.`creator`, a.`name`, a.`description`, a.`permissions`, a.`created`, a.`path` , a.`type` , a.`groupid`, a.`location`, c.thumbnail, c.storage, c.id as photoid, IF( a.groupid>0, IF( d.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, CASE a.permissions WHEN 0 THEN true WHEN 20 THEN (SELECT COUNT(u.id) FROM `jos_users` AS u WHERE u.block=0 AND u.id='0') WHEN 30 THEN IF( a.creator='0' or 0, true, (SELECT COUNT(v.connection_id) FROM `jos_community_connection` AS v WHERE v.connect_from=a.creator AND v.connect_to='0' AND v.status=1) ) WHEN 40 THEN IF(a.creator='0' or 0,true,false) END AS privacy FROM `jos_community_photos_albums` AS a LEFT JOIN `jos_community_photos` AS c ON a.photoid=c.id LEFT JOIN `jos_community_groups` AS d ON a.groupid=d.id GROUP BY a.id HAVING display=true AND privacy=true ORDER BY a.`created` DESC ) AS x INNER JOIN `jos_community_photos` AS b ON x.id=b.albumid GROUP BY x.id ORDER BY x.`created` DESC