Hello Support
Something has gone horribly wrong!
If you go to the Site the template, the pages, modules, blah, blah are all there.
But there is no content.
eg Blog shows Blog pages but no blogs.
In the back end when I go to the Easy Blog part I see
DB function failed with error number 1030
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 am putting the Site offline for maintenance ;-)
And would ask some one to look at this ASAP
Will post more as I figure out more
There was an update performed today.
And I had no more space for a back up in PLesk and tried to free up some space by deleting some stuff that I had lying around.
I had a folder with some video files in it. the files had technicaly nothing to do with the Site!
I removed said video files and then tried downloading the back up and got and error message in Plesk
ERROR: Zend_Db_Statement_Exception: SQLSTATE[HY000]: General error: 1030 Got error 122 from storage engine (Pdo.php:234)
I do not know if this was the update or my attempt to slim down the backup and then download. Or a combination of both.
Either way I think I am in a pickle and could really do with some help on this one thanks
Paul
ps can not put Site off line as I get this:
Could not save data. Error: The Global Configuration extension could not be found. Text filter settings have not been saved.