By Paul Murray on Thursday, 21 May 2015
Posted in Technical Issues
Likes 0
Views 826
Votes 0
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
Hi Paul,

The reason why you hitting this `Got error 122 from storage engine` error is most likely because your server has run out of disk space or temporary file space.

Perhaps you consult with your Webhosting provider regarding this?
·
Friday, 22 May 2015 00:18
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Arlex

You are of course correct.
After putting this off for donkeys years I am switching hoster:

http://stackideas.com/forums/recommendation-of-shared-hosting-or-vps-for-easyblog-and-easysocial

thanks all the same for your response.

Paul
·
Friday, 22 May 2015 22:23
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Paul,

You're welcome.
·
Saturday, 23 May 2015 17:24
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post