Hi,

Just installed the Theme (on 1.5.4.1) and starting to look around. Everything seems to work except for the product count (enable/disable) when you have Category Module enabled on certain views (i.e. category and product).

I have disabled it everywhere (OC settings  and Shoppica settings) but it seems like it is not as the page load is extremely slow.

The front (index) is OK to load but when I try to access a page where I have enabled Category Module it breaks down. I get an SQL error:

Notice: Error: Incorrect key file for table ‘/tmp/#sql_2988_0.MYI’; try to repair it
Error No: 126
SELECT c.category_id, COUNT(p2c.category_id) AS products_count, GROUP_CONCAT(p2c.product_id) AS ids FROM category c INNER JOIN category_description cd ON (c.category_id = cd.category_id) INNER JOIN category_to_store c2s ON (c.category_id = c2s.category_id) LEFT JOIN product_to_store AS p2s ON p2s.store_id = c2s.store_id LEFT JOIN product_to_category AS p2c ON c.category_id = p2c.category_id AND p2c.product_id = p2s.product_id WHERE c.category_id IN (1,171,228,227,84,41,33,229,230,29,40,12,34,27,2,310,311,312,313,314,157,110,6,168,13,286,169,7,21,24,25,209,32,15,16,17,18,22,305,306,307,308,309,4,66,5,97,8,45,9,19,59,48,132,49,135,136,56,50,52,47,89,130,58,30,51,46,57,54,20,131,43,62,85,63,129,285,141,142,143,144,145,83,174,167,159,164,175,176,231,185,81,161,123,292,258,259,260,117,184,232,80,162,65,294,152,153,154,155,156,166,10,26,23,11,28,60,61,67,124,125,126,127,128,137,165,35,36,146,149,150,151,315,321,316,317,318,320,319,158,119,53,253,273,270,267,268,274,269,272,275,271,163,276,178,180,284,74,68,77,71,282,283,262,339) AND cd.language_id = 2 AND c2s.store_id = 0 AND c.status = 1 AND c.sort_order <> -1 GROUP BY c.category_id ORDER BY c.sort_order, LCASE(cd.name) in /home/xxxxx/public_html/clean/system/database/mysql.php on line 49

Please help!