Hello Support
This is in red and kind of looks scary! Any ideas?
Got error 122 from storage engine 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` FROM `fbug_users` AS `a` INNER JOIN `fbug_easyblog_users` AS `b` ON a.`id` = b.`id` INNER JOIN `fbug_user_usergroup_map` AS `d` ON d.`user_id` = a.`id` INNER JOIN `fbug_easyblog_acl_group` AS `e` ON d.`group_id` = e.`content_id` AND e.`type` = 'group' AND e.`status` = 1 INNER JOIN `fbug_easyblog_acl` as `f` ON e.`acl_id` = f.`id` AND f.`action` = 'add_entry' LEFT JOIN `fbug_easyblog_post` AS `p` ON a.`id` = p.`created_by` 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` FROM `fbug_users` AS `a1` INNER JOIN `fbug_easyblog_users` AS `b1` ON a1.`id` = b1.`id` INNER JOIN `fbug_easyblog_acl_group` AS `c1` ON a1.`id` = c1.`content_id` AND c1.`type` = 'assigned' AND c1.`status` = 1 INNER JOIN `fbug_easyblog_acl` as `d1` ON c1.`acl_id` = d1.`id` AND d1.`action` = 'add_entry' LEFT JOIN `fbug_easyblog_post` AS `p1` ON a1.`id` = p1.`created_by` GROUP BY a1.`id` HAVING (COUNT(p1.`id`) > 0) ) ) as x ORDER BY x.`name` ASC
I see the above when I go here:
http://finalbug.net/administrator/index.php?option=com_easyblog&view=blogs
thanks in advance
Paul
This is in red and kind of looks scary! Any ideas?
Got error 122 from storage engine 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` FROM `fbug_users` AS `a` INNER JOIN `fbug_easyblog_users` AS `b` ON a.`id` = b.`id` INNER JOIN `fbug_user_usergroup_map` AS `d` ON d.`user_id` = a.`id` INNER JOIN `fbug_easyblog_acl_group` AS `e` ON d.`group_id` = e.`content_id` AND e.`type` = 'group' AND e.`status` = 1 INNER JOIN `fbug_easyblog_acl` as `f` ON e.`acl_id` = f.`id` AND f.`action` = 'add_entry' LEFT JOIN `fbug_easyblog_post` AS `p` ON a.`id` = p.`created_by` 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` FROM `fbug_users` AS `a1` INNER JOIN `fbug_easyblog_users` AS `b1` ON a1.`id` = b1.`id` INNER JOIN `fbug_easyblog_acl_group` AS `c1` ON a1.`id` = c1.`content_id` AND c1.`type` = 'assigned' AND c1.`status` = 1 INNER JOIN `fbug_easyblog_acl` as `d1` ON c1.`acl_id` = d1.`id` AND d1.`action` = 'add_entry' LEFT JOIN `fbug_easyblog_post` AS `p1` ON a1.`id` = p1.`created_by` GROUP BY a1.`id` HAVING (COUNT(p1.`id`) > 0) ) ) as x ORDER BY x.`name` ASC
I see the above when I go here:
http://finalbug.net/administrator/index.php?option=com_easyblog&view=blogs
thanks in advance
Paul