DB function failed with error number 126
Incorrect key file for table '/tmp/#sql_6c8c_3.MYI'; try to repair it SQL=SELECT DISTINCT `product_name` ,`products_per_row` ,`category_browsepage` ,`category_flypage` ,`jos_vm_category`.`category_id` ,`jos_vm_product`.`out_id` ,`jos_vm_product`.`product_id` ,`product_full_image` ,`product_thumb_image` ,`product_s_desc` ,`product_parent_id` ,`product_publish` ,`product_in_stock` ,`product_sku` ,`jos_vm_product`.sefcode as p_code ,`jos_vm_category`.sefcode as c_code ,`product_available_date` ,`product_availability` ,if(`jos_vm_product`.`data_propazhi`='0000-00-00','1',if (`jos_vm_product`.`data_propazhi`>DATE_ADD(curdate(), INTERVAL -10 DAY),'2','3')) AS pstatus ,`jos_vm_product`.`product_desc` ,`jos_vm_product`.`xml_id` FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`) LEFT JOIN `jos_vm_product_price` ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id` WHERE `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id` AND `jos_vm_product`.`product_name`<>'' AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id` AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id` AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL) AND `jos_vm_shopper_group`.`default` = 1 AND `product_parent_id`=0 AND `product_publish`='Y' AND `category_publish`='Y' GROUP BY `jos_vm_product`.`product_sku` ORDER BY `jos_vm_product_price`.`product_price` ASC LIMIT 0, 15
Incorrect key file for table '/tmp/#sql_6c8c_3.MYI'; try to repair it SQL=SELECT DISTINCT `product_name` ,`products_per_row` ,`category_browsepage` ,`category_flypage` ,`jos_vm_category`.`category_id` ,`jos_vm_product`.`out_id` ,`jos_vm_product`.`product_id` ,`product_full_image` ,`product_thumb_image` ,`product_s_desc` ,`product_parent_id` ,`product_publish` ,`product_in_stock` ,`product_sku` ,`jos_vm_product`.sefcode as p_code ,`jos_vm_category`.sefcode as c_code ,`product_available_date` ,`product_availability` ,if(`jos_vm_product`.`data_propazhi`='0000-00-00','1',if (`jos_vm_product`.`data_propazhi`>DATE_ADD(curdate(), INTERVAL -10 DAY),'2','3')) AS pstatus ,`jos_vm_product`.`product_desc` ,`jos_vm_product`.`xml_id` FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`) LEFT JOIN `jos_vm_product_price` ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id` WHERE `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id` AND `jos_vm_product`.`product_name`<>'' AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id` AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id` AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL) AND `jos_vm_shopper_group`.`default` = 1 AND `product_parent_id`=0 AND `product_publish`='Y' AND `category_publish`='Y' GROUP BY `jos_vm_product`.`product_sku` ORDER BY `jos_vm_product_price`.`product_price` ASC LIMIT 0, 15