There has been an error processing your request

SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/MYC2wCJs' (Errcode: 28 - No space left on device), query was: SELECT `count_table`.`category_id`, COUNT(DISTINCT count_table.product_id) AS `product_count` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '10'
 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
 INNER JOIN `catalog_category_product_index` AS `count_table` ON count_table.product_id = e.entity_id WHERE (e.status = 1) AND (count_table.store_id = 1) AND (count_table.category_id IN ('11', '12', '13', '14', '15', '21', '24', '34', '37', '38', '39', '40', '53', '66', '156', '159', '162', '163', '164', '178', '44', '177', '181', '172', '111', '95')) GROUP BY `count_table`.`category_id`
Trace: #0 /home/amazingp/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) #1 /home/amazingp/public_html/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array) #2 /home/amazingp/public_html/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #3 /home/amazingp/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `count_t...', Array) #4 /home/amazingp/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `count_t...', Array) #5 /home/amazingp/public_html/lib/Zend/Db/Adapter/Abstract.php(811): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array) #6 /home/amazingp/public_html/app/code/core/Mage/Catalog/Model/Resource/Product/Collection.php(1058): Zend_Db_Adapter_Abstract->fetchPairs(Object(Varien_Db_Select)) #7 /home/amazingp/public_html/app/code/local/Amasty/Shopby/Model/Catalog/Layer/Filter/Category.php(32): Mage_Catalog_Model_Resource_Product_Collection->addCountToCategories(Array) #8 /home/amazingp/public_html/app/code/local/Amasty/Shopby/Model/Catalog/Layer/Filter/Category.php(72): Amasty_Shopby_Model_Catalog_Layer_Filter_Category->_getItemsData() #9 /home/amazingp/public_html/app/code/core/Mage/Catalog/Model/Layer/Filter/Abstract.php(120): Amasty_Shopby_Model_Catalog_Layer_Filter_Category->_initItems() #10 /home/amazingp/public_html/app/code/core/Mage/Catalog/Model/Layer/Filter/Abstract.php(109): Mage_Catalog_Model_Layer_Filter_Abstract->getItems() #11 /home/amazingp/public_html/app/code/core/Mage/Catalog/Block/Layer/Filter/Abstract.php(132): Mage_Catalog_Model_Layer_Filter_Abstract->getItemsCount() #12 /home/amazingp/public_html/app/code/local/Amasty/Shopby/Block/Catalog/Layer/View.php(28): Mage_Catalog_Block_Layer_Filter_Abstract->getItemsCount() #13 /home/amazingp/public_html/app/code/core/Mage/Catalog/Block/Layer/View.php(217): Amasty_Shopby_Block_Catalog_Layer_View->getFilters() #14 /home/amazingp/public_html/app/code/core/Mage/Catalog/Block/Layer/View.php(233): Mage_Catalog_Block_Layer_View->canShowOptions() #15 /home/amazingp/public_html/app/design/frontend/default/theme216/template/catalog/layer/view.phtml(34): Mage_Catalog_Block_Layer_View->canShowBlock() #16 /home/amazingp/public_html/app/code/core/Mage/Core/Block/Template.php(241): include('/home/amazingp/...') #17 /home/amazingp/public_html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/defaul...') #18 /home/amazingp/public_html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView() #19 /home/amazingp/public_html/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Template->_toHtml() #20 /home/amazingp/public_html/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml() #21 /home/amazingp/public_html/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Text_List->_toHtml() #22 /home/amazingp/public_html/app/code/core/Mage/Core/Block/Abstract.php(641): Mage_Core_Block_Abstract->toHtml() #23 /home/amazingp/public_html/app/code/core/Mage/Core/Block/Abstract.php(585): Mage_Core_Block_Abstract->_getChildHtml('right', true) #24 /home/amazingp/public_html/app/design/frontend/default/theme216/template/page/2columns-right.phtml(58): Mage_Core_Block_Abstract->getChildHtml('right') #25 /home/amazingp/public_html/app/code/core/Mage/Core/Block/Template.php(241): include('/home/amazingp/...') #26 /home/amazingp/public_html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/defaul...') #27 /home/amazingp/public_html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView() #28 /home/amazingp/public_html/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Template->_toHtml() #29 /home/amazingp/public_html/app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract->toHtml() #30 /home/amazingp/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout->getOutput() #31 /home/amazingp/public_html/app/code/core/Mage/Catalog/controllers/CategoryController.php(161): Mage_Core_Controller_Varien_Action->renderLayout() #32 /home/amazingp/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Catalog_CategoryController->viewAction() #33 /home/amazingp/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('view') #34 /home/amazingp/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http)) #35 /home/amazingp/public_html/app/code/core/Mage/Core/Model/App.php(381): Mage_Core_Controller_Varien_Front->dispatch() #36 /home/amazingp/public_html/app/Mage.php(687): Mage_Core_Model_App->run(Array) #37 /home/amazingp/public_html/index.php(85): Mage::run('', 'store') #38 {main}

Error log record number: 1183533908762