user warning: Incorrect key file for table '/tmp/#sql_45e3_1.MYI'; try to repair it query: SELECT t.type, t.name, COUNT(n.nid) AS node_count FROM node n INNER JOIN node_type t ON t.type = n.type WHERE n.status = 1 AND t.type IN ('blog', 'cases', 'story', 'story2', 'story3', '0') GROUP BY t.type, t.name, n.created ORDER BY n.created in /opt/www/acom/public/sites/all/modules/archive/archive.pages.inc on line 186.