Database error #1030 : Got error 28 from storage engine
QUERY: SELECT SQL_CALC_FOUND_ROWS *
FROM ((SELECT `Article`.`id`, `Article`.`slug` AS `itemLink`, `Article`.`title`, `Article`.`createdAt`, `Category`.`title` AS `categoryTitle`, `Category`.`alias` AS `categoryLink`, "article" AS `itemType`, `Article1Text`.`introText`, `Article1Text`.`text`, `Article`.`fileId`
FROM `Article`
INNER JOIN `Category` ON `Category`.`id` = `Article`.`categoryId` INNER JOIN `Article2Tag` ON `Article2Tag`.`articleId` = `Article`.`id` INNER JOIN `Article1Text` ON `Article1Text`.`articleId` = `Article`.`id`
WHERE `Article2Tag`.`tagId` = '93' AND `Article`.`status` = 'published' AND `Category`.`status` = 'published'
) UNION (SELECT `BlogPost`.`id`, CONCAT_WS("/", "blog", `Blog`.`slug`, `BlogPost`.`slug`) AS `itemLink`, `BlogPost`.`title`, `BlogPost`.`createdAt`, `Author`.`visibleName` AS `categoryTitle`, CONCAT_WS("/", "blog", `Blog`.`slug`) AS `categoryLink`, "blog" AS `itemType`, `BlogPost1Text`.`introText`, `BlogPost1Text`.`text`, `Author`.`fileId`
FROM `BlogPost`
INNER JOIN `Blog` ON `Blog`.`id` = `BlogPost`.`blogId` INNER JOIN `Author` ON `Author`.`id` = `Blog`.`authorId` INNER JOIN `BlogPost2Tag` ON `BlogPost2Tag`.`blogPostId` = `BlogPost`.`id` INNER JOIN `BlogPost1Text` ON `BlogPost1Text`.`blogPostId` = `BlogPost`.`id`
WHERE `BlogPost2Tag`.`tagId` = '93' AND `BlogPost`.`status` = 'published' AND `Blog`.`status` = 'published'
)) as t
ORDER BY t.createdAt DESC
LIMIT 120, 15
$this->_queryResult = @mysql_query($query, $this->_connection);
if (!$this->_queryResult) {
throw new DatabaseException("Database error #" . mysql_errno($this->_connection) . " : " . mysql_error($this->_connection) . "<br/>QUERY: {$query}");
return false;
} else {
return $this->_queryResult;
10. MySQL->query
/var/www/tt-inf/data/www/tt.inf.ua/framework/components/database/MySQL.php (220) view
9. MySQL->getAllArrays
() view
8. call_user_func_array
/var/www/tt-inf/data/www/tt.inf.ua/framework/components/Database.php (208) view
7. Database->__call
/var/www/tt-inf/data/www/tt.inf.ua/framework/classes/ObjectList2.php (403) view
6. Database->getAllArrays
/var/www/tt-inf/data/www/tt.inf.ua/framework/classes/ObjectList2.php (403) view
5. ObjectList2->select
/var/www/tt-inf/data/www/tt.inf.ua/applications/public/tag/controller.php (65) view
4. TagPageController->do_default
/var/www/tt-inf/data/www/tt.inf.ua/framework/classes/PageController.php (143) view
3. PageController->execute
/var/www/tt-inf/data/www/tt.inf.ua/framework/classes/Application.php (146) view
2. Application->execute
/var/www/tt-inf/data/www/tt.inf.ua/framework/classes/Application.php (106) view
1. Application->run
/var/www/tt-inf/data/www/tt.inf.ua/index.php (16) view