Layered navigation error

[dirsubmit]

Hi,

 

When I create a layered navigation and add categories and filters, etc.. everything works fine.  When I go back in and try to edit it (for example added a new category so I want to include it)  I always get the same error message.

 

 

 

 

Fatal error: Uncaught Incorrect key file for table 'C:\Windows\TEMP\#sql15ec_8d7e_0.MYI'; try to repair it

 

SELECT fl.id_feature, fl.name, COUNT(DISTINCT(fv.id_feature_value)) n

FROM prstshp_feature_lang fl

LEFT JOIN prstshp_feature_value fv ON (fv.id_feature = fl.id_feature)

 

LEFT JOIN prstshp_feature_product fp ON (fp.id_feature = fv.id_feature)

LEFT JOIN prstshp_category_product cp ON (cp.id_product = fp.id_product)

WHERE (fv.custom IS NULL OR fv.custom = 0) AND fl.id_lang = 1 AND cp.id_category IN (1,2,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,1 in

 

 

I have looked and there is no such file either C:\Windows\TEMP\#sql15ec_8d7e_0.MYI'

 

What can be causing this and how can I fix it?

 

Thanks