user warning: Error writing file '/tmp/MYc9W6GJ' (Errcode: 28)
query: SELECT c.cid as cid, c.pid, c.nid, c.subject, c.comment, c.format, c.timestamp, c.name, c.mail, c.homepage, u.uid, u.name AS registered_name, u.signature, u.signature_format, u.picture, u.data, c.thread, c.status FROM swportal_comments c INNER JOIN swportal_users u ON c.uid = u.uid WHERE c.nid = 813 AND c.status = 0 ORDER BY SUBSTRING(c.thread, 1, (LENGTH(c.thread) - 1)) LIMIT 1600, 50 in /var/www/drupal/modules/comment/comment.module on line 991.
user warning: Incorrect key file for table '/tmp/#sql_9ec_4.MYI'; try to repair it
query: SELECT node.title AS node_title,
node.nid AS nid,
node.type AS node_type,
node.vid AS node_vid,
node_revisions.teaser AS node_revisions_teaser,
node_revisions.format AS node_revisions_format,
RAND() AS _random
FROM swportal_node node
LEFT JOIN swportal_node_revisions node_revisions ON node.vid = node_revisions.vid
WHERE (node.type in ('review', 'soft')) AND (node.status = 1) AND ((node_revisions.body) != (''))
ORDER BY _random ASC
LIMIT 0, 8 in /var/www/drupal/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1191.
user warning: Incorrect key file for table '/tmp/#sql_9ec_3.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.