user warning: Incorrect key file for table '/tmp/#sql_9ec_7.MYI'; try to repair it query: SELECT COUNT(*) FROM (SELECT comments.cid AS cid, comments.nid AS comments_nid, node_comments.nid AS node_comments_nid, 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 FROM swportal_comments comments LEFT JOIN swportal_node node_comments ON comments.nid = node_comments.nid WHERE node_comments.status = 1 OR (node_comments.uid = 0 AND 0 <> 0) OR 0 = 1 ) count_alias in /var/www/drupal/sites/all/modules/views/plugins/views_plugin_pager.inc on line 141.