SQLSTATE[HY000]: General error: 1 Can't create/write to file '/tmp/#sql-temptable-7c38-14feda-3958.MAI' (Errcode: 28 "No space left on device"), query was: SELECT `route`.`routeId`, `route`.`companyId` AS `company_id`, `company`.`name` AS `company`, `company_ownership`.`is_quoted`, `company_ownership`.`name` AS `ownership`, `route_from_city`.`name` AS `from_city`, `route_from_province`.`name` AS `from_province`, `route_from_country`.`name` AS `from_country`, IF(route_from_country.country_code != '', route_from_country.country_code, route_from_province.country_code) AS `from_country_code`, `route_to_city`.`name` AS `to_city`, `route_to_province`.`name` AS `to_province`, `route_to_country`.`name` AS `to_country`, IF(route_to_country.country_code != '', route_to_country.country_code, route_to_province.country_code) AS `to_country_code`, `body`.`name` AS `body`, `body`.`class` AS `body_class`, `route`.`volume`, `route`.`cargo_capacity`, `route`.`seat_count_from`, `route`.`seat_count_to`, `route`.`date_from`, `route`.`date_to`, `route`.`date_created`, `user`.`phone` FROM `route` LEFT JOIN `company` ON company.company_id = route.companyId LEFT JOIN `company_ownership` ON company.ownership_id = company_ownership.ownership_id LEFT JOIN `body` ON route.bodyId = body.body_id INNER JOIN `route_direction` AS `route_from` ON route_from.routeId = route.routeId AND route_from.type='from' AND route_from.is_main=1 LEFT JOIN `region` AS `route_from_city` ON route_from_city.regionId = route_from.regionId LEFT JOIN `region` AS `route_from_province` ON route_from_province.regionId = route_from_city.parentId LEFT JOIN `region` AS `route_from_country` ON route_from_country.regionId = route_from_province.parentId INNER JOIN `route_direction` AS `route_to` ON route_to.routeId = route.routeId AND route_to.type='to' AND route_to.is_main=1 LEFT JOIN `region` AS `route_to_city` ON route_to_city.regionId = route_to.regionId LEFT JOIN `region` AS `route_to_province` ON route_to_province.regionId = route_to_city.parentId LEFT JOIN `region` AS `route_to_country` ON route_to_country.regionId = route_to_province.parentId LEFT JOIN `user` ON user.userId = route.user_id WHERE (route.is_approved = 1) AND (company.is_approved = 1) AND (route.status = 'enabled') AND (1 IN ( IF(route_from_country.regionId IS NOT NULL, route_from_country.regionId, route_from_province.regionId), IF(route_to_country.regionId IS NOT NULL, route_to_country.regionId, route_to_province.regionId) )) GROUP BY `route`.`routeId` ORDER BY `route`.`date_created` DESC LIMIT 3#0 /var/www/asdap/data/www/asdap.ru/library/Zend/Db/Statement.php(323): Zend_Db_Statement_Pdo->_execute(Array) #1 /var/www/asdap/data/www/asdap.ru/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #2 /var/www/asdap/data/www/asdap.ru/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(Object(Model_Collection_Route), Array) #3 /var/www/asdap/data/www/asdap.ru/library/Zend/Db/Adapter/Abstract.php(737): Zend_Db_Adapter_Pdo_Abstract->query(Object(Model_Collection_Route), Array) #4 /var/www/asdap/data/www/asdap.ru/library/Universal/Model.php(310): Zend_Db_Adapter_Abstract->fetchAll(Object(Model_Collection_Route)) #5 /var/www/asdap/data/www/asdap.ru/library/Universal/Collection.php(85): Universal_Model->cacheFetchAll(Object(Model_Collection_Route), true) #6 /var/www/asdap/data/www/asdap.ru/library/Asdap/View/Helper/BlockLatest.php(50): Universal_Collection->fetchCols() #7 /var/www/asdap/data/www/asdap.ru/application/modules/default/views/helpers/BlockLatestRoute.php(62): Asdap_View_Helper_BlockLatest->getPreparedRows() #8 /var/www/asdap/data/www/asdap.ru/application/modules/default/views/helpers/BlockLatestRoute.php(22): Default_View_Helper_BlockLatestRoute->_fetchRows() #9 [internal function]: Default_View_Helper_BlockLatestRoute->blockLatestRoute() #10 /var/www/asdap/data/www/asdap.ru/library/Zend/View/Abstract.php(350): call_user_func_array(Array, Array) #11 /var/www/asdap/data/www/asdap.ru/application/modules/default/views/scripts/_layout/sidebar_left.phtml(34): Zend_View_Abstract->__call('blockLatestRout...', Array) #12 /var/www/asdap/data/www/asdap.ru/application/modules/default/views/scripts/_layout/sidebar_left.phtml(34): Zend_View->blockLatestRoute() #13 /var/www/asdap/data/www/asdap.ru/library/Zend/View.php(108): include('/var/www/asdap/...') #14 /var/www/asdap/data/www/asdap.ru/library/Zend/View/Abstract.php(888): Zend_View->_run('/var/www/asdap/...') #15 /var/www/asdap/data/www/asdap.ru/library/Zend/View/Helper/Partial.php(109): Zend_View_Abstract->render('_layout/sidebar...') #16 [internal function]: Zend_View_Helper_Partial->partial('_layout/sidebar...') #17 /var/www/asdap/data/www/asdap.ru/library/Zend/View/Abstract.php(350): call_user_func_array(Array, Array) #18 /var/www/asdap/data/www/asdap.ru/application/modules/default/views/scripts/layout.phtml(94): Zend_View_Abstract->__call('partial', Array) #19 /var/www/asdap/data/www/asdap.ru/application/modules/default/views/scripts/layout.phtml(94): Zend_View->partial('_layout/sidebar...') #20 /var/www/asdap/data/www/asdap.ru/library/Zend/View.php(108): include('/var/www/asdap/...') #21 /var/www/asdap/data/www/asdap.ru/library/Zend/View/Abstract.php(888): Zend_View->_run('/var/www/asdap/...') #22 /var/www/asdap/data/www/asdap.ru/library/Zend/Layout.php(796): Zend_View_Abstract->render('layout.phtml') #23 /var/www/asdap/data/www/asdap.ru/library/Zend/Layout/Controller/Plugin/Layout.php(143): Zend_Layout->render() #24 /var/www/asdap/data/www/asdap.ru/library/Zend/Controller/Plugin/Broker.php(333): Zend_Layout_Controller_Plugin_Layout->postDispatch(Object(Zend_Controller_Request_Http)) #25 /var/www/asdap/data/www/asdap.ru/library/Zend/Controller/Front.php(965): Zend_Controller_Plugin_Broker->postDispatch(Object(Zend_Controller_Request_Http)) #26 /var/www/asdap/data/www/asdap.ru/library/Zend/Application/Bootstrap/Bootstrap.php(101): Zend_Controller_Front->dispatch() #27 /var/www/asdap/data/www/asdap.ru/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run() #28 /var/www/asdap/data/www/asdap.ru/public_html/index.php(59): Zend_Application->run() #29 {main}