[PrestaShopDatabaseException]

Incorrect key file for table '/tmp/#sql_a4d_0.MYI'; try to repair it

                SELECT DISTINCT od.product_id, pl.name, pl.description_short, pl.link_rewrite, p.reference, i.id_image, product_shop.show_price,
                    cl.link_rewrite category, p.ean13, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity
                FROM ps_order_detail od
                LEFT JOIN ps_product p ON (p.id_product = od.product_id)
                 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)LEFT JOIN `ps_product_attribute` pa
                ON (p.`id_product` = pa.`id_product`)
                 LEFT JOIN ps_product_attribute_shop product_attribute_shop
		ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1 AND product_attribute_shop.`default_on` = 1)
                 LEFT JOIN ps_stock_available stock
			ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
                LEFT JOIN ps_product_lang pl ON (pl.id_product = od.product_id AND pl.id_shop = 1 )
                LEFT JOIN ps_category_lang cl ON (cl.id_category = product_shop.id_category_default AND cl.id_shop = 1 )
                LEFT JOIN ps_image i ON (i.id_product = od.product_id)
                
                LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = product_shop.id_category_default
                    AND cp.id_product = product_shop.id_product)
                LEFT JOIN `ps_category_group` cg ON (cp.`id_category` = cg.`id_category`)
                WHERE od.id_order IN (119,1362,1430,1986,4027,4597,4965)
                AND pl.id_lang = 1
                AND cl.id_lang = 1
                AND od.product_id NOT IN (1675)
                AND i.cover = 1
                AND product_shop.active = 1
                AND cg.`id_group` =1
                ORDER BY RAND()
                LIMIT 10

at line 791 in file classes/db/Db.php

786.         if ($webservice_call && $errno) {
787.             $dbg = debug_backtrace();
788.             WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
789.         } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
790.             if ($sql) {
791.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
792.             }
793. 
794.             throw new PrestaShopDatabaseException($this->getMsgError());
795.         }
796.     }