user warning: Incorrect key file for table '/tmp/mysqltmp/#sql_1322_0.MYI'; try to repair it query: SELECT comments.cid AS cid, node_comments.title AS node_comments_title, node_comments.nid AS node_comments_nid, node_comments.language AS node_comments_language, comments.timestamp AS comments_timestamp, comments.name AS comments_name, comments.uid AS comments_uid, comments.homepage AS comments_homepage, comments.subject AS comments_subject, comments.nid AS comments_nid FROM comments comments LEFT JOIN node node_comments ON comments.nid = node_comments.nid LEFT JOIN comments node_comments__comments ON node_comments.nid = node_comments__comments.nid WHERE (node_comments.status <> 0 OR (node_comments.uid = 0 AND 0 <> 0) OR 0 = 1) AND (node_comments.type in ('blog')) AND (node_comments__comments.status = 0) ORDER BY comments_timestamp DESC LIMIT 0, 8 in /home/content/b/e/r/bergonzini/html/sites/odilas/thp/sites/all/modules/contrib/views/includes/view.inc on line 771.

Blog