I've been using Virtuemart 2.0.8.e for a while now, but all of a sudden I have an error when I try to view my products in the back end
vmError: exeSortSearchListQuery Incorrect key file for table '/tmp/#sql_2e9_0.MYI'; try to repair it SQL=SELECT SQL_CALC_FOUND_ROWS * FROM `jos_virtuemart_products_en_gb` as l JOIN `jos_virtuemart_products` AS p using (`virtuemart_product_id`)group by p.`virtuemart_product_id` ORDER BY p.`created_on` DESC LIMIT 0, 12
If I try to choose a manufacturer I get
vmError: exeSortSearchListQuery Incorrect key file for table '/tmp/#sql_2e9_0.MYI'; try to repair it SQL=SELECT SQL_CALC_FOUND_ROWS * FROM `jos_virtuemart_products_en_gb` as l JOIN `jos_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `jos_virtuemart_product_manufacturers` ON p.`virtuemart_product_id` = `jos_virtuemart_product_manufacturers`.`virtuemart_product_id` LEFT JOIN `jos_virtuemart_manufacturers_en_gb` as m ON m.`virtuemart_manufacturer_id` = `jos_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` WHERE ( `jos_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = 1) group by p.`virtuemart_product_id` ORDER BY p.`created_on` DESC LIMIT 0, 12
However if I choose a category (with or without choosing a manufacturer) everything lists fine.
I can't think of any new modules or plugins I've installed recently, nor do I mess around in my databases. The only thing I've done there is manually change the parents of a few children that got incorrectly assigned.
I know nothing about code, so any help would be appreciated.
Edit Aug 22: updated to 2.0.10 and it seems fixed.