500 - DB function failed with error number 1021
Disk full (/tmp/mysqltmp/#sql-temptable-16b982-727f30-a1f3.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") SQL=SELECT x.* FROM ( (SELECT a.`id`, b.`nickname`, b.`avatar`, b.`description`, a.`name`, a.`username`, a.`registerDate`, a.`lastvisitDate`, COUNT(p.`id`) as `totalPost`, MAX(p.`created`) as `latestPostDate`, COUNT( DISTINCT(g.content_id) ) as `featured` FROM `jos_users` AS `a` LEFT JOIN `jos_easyblog_users` AS `b` ON a.`id` = b.`id` INNER JOIN `jos_core_acl_aro` AS `c` ON a.`id` = c.`value` AND c.`section_value` = 'users' INNER JOIN `jos_core_acl_groups_aro_map` AS `d` ON c.`id` = d.`aro_id` INNER JOIN `jos_easyblog_acl_group` AS `e` ON d.`group_id` = e.`content_id` AND e.`type` = 'group' AND e.`status` = 1 INNER JOIN `jos_easyblog_acl` as `f` ON e.`acl_id` = f.`id` AND f.`action` = 'add_entry' LEFT JOIN `jos_easyblog_featured` AS `g` ON a.`id`= g.`content_id` AND g.`type`='blogger' LEFT JOIN `jos_easyblog_post` AS `p` ON a.`id` = p.`created_by` AND `p`.`published`='1' GROUP BY a.`id` HAVING (COUNT(p.`id`) > 0) ) UNION (SELECT a1.`id`, b1.`nickname`, b1.`avatar`, b1.`description`, a1.`name`, a1.`username`, a1.`registerDate`, a1.`lastvisitDate`, COUNT(p1.`id`) as `totalPost`, MAX(p1.`created`) as `latestPostDate`, COUNT( DISTINCT(g1.`content_id`) ) as `featured` FROM `jos_users` AS `a1` LEFT JOIN `jos_easyblog_users` AS `b1` ON a1.`id` = b1.`id` INNER JOIN `jos_easyblog_acl_group` AS `c1` ON a1.`id` = c1.`content_id` AND c1.`type` = 'assigned' AND c1.`status` = 1 INNER JOIN `jos_easyblog_acl` as `d1` ON c1.`acl_id` = d1.`id` AND d1.`action` = 'add_entry' LEFT JOIN `jos_easyblog_featured` AS `g1` ON a1.`id`= g1.`content_id` AND g1.`type`='blogger' LEFT JOIN `jos_easyblog_post` AS `p1` ON a1.`id` = p1.`created_by` AND `p1`.`published`='1' GROUP BY a1.`id` HAVING (COUNT(p1.`id`) > 0) ) ) as x ORDER BY x.`featured` DESC LIMIT 0,10

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 1021
Disk full (/tmp/mysqltmp/#sql-temptable-16b982-727f30-a1f3.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") SQL=SELECT x.* FROM ( (SELECT a.`id`, b.`nickname`, b.`avatar`, b.`description`, a.`name`, a.`username`, a.`registerDate`, a.`lastvisitDate`, COUNT(p.`id`) as `totalPost`, MAX(p.`created`) as `latestPostDate`, COUNT( DISTINCT(g.content_id) ) as `featured` FROM `jos_users` AS `a` LEFT JOIN `jos_easyblog_users` AS `b` ON a.`id` = b.`id` INNER JOIN `jos_core_acl_aro` AS `c` ON a.`id` = c.`value` AND c.`section_value` = 'users' INNER JOIN `jos_core_acl_groups_aro_map` AS `d` ON c.`id` = d.`aro_id` INNER JOIN `jos_easyblog_acl_group` AS `e` ON d.`group_id` = e.`content_id` AND e.`type` = 'group' AND e.`status` = 1 INNER JOIN `jos_easyblog_acl` as `f` ON e.`acl_id` = f.`id` AND f.`action` = 'add_entry' LEFT JOIN `jos_easyblog_featured` AS `g` ON a.`id`= g.`content_id` AND g.`type`='blogger' LEFT JOIN `jos_easyblog_post` AS `p` ON a.`id` = p.`created_by` AND `p`.`published`='1' GROUP BY a.`id` HAVING (COUNT(p.`id`) > 0) ) UNION (SELECT a1.`id`, b1.`nickname`, b1.`avatar`, b1.`description`, a1.`name`, a1.`username`, a1.`registerDate`, a1.`lastvisitDate`, COUNT(p1.`id`) as `totalPost`, MAX(p1.`created`) as `latestPostDate`, COUNT( DISTINCT(g1.`content_id`) ) as `featured` FROM `jos_users` AS `a1` LEFT JOIN `jos_easyblog_users` AS `b1` ON a1.`id` = b1.`id` INNER JOIN `jos_easyblog_acl_group` AS `c1` ON a1.`id` = c1.`content_id` AND c1.`type` = 'assigned' AND c1.`status` = 1 INNER JOIN `jos_easyblog_acl` as `d1` ON c1.`acl_id` = d1.`id` AND d1.`action` = 'add_entry' LEFT JOIN `jos_easyblog_featured` AS `g1` ON a1.`id`= g1.`content_id` AND g1.`type`='blogger' LEFT JOIN `jos_easyblog_post` AS `p1` ON a1.`id` = p1.`created_by` AND `p1`.`published`='1' GROUP BY a1.`id` HAVING (COUNT(p1.`id`) > 0) ) ) as x ORDER BY x.`featured` DESC LIMIT 0,10