- user warning: Out of resources when opening file '/tmp/#sql_e7c_0.MYD' (Errcode: 24) query: SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid, node.title AS node_title, node.language AS node_language, node_data_field_shop_loaction.field_shop_loaction_value AS node_data_field_shop_loaction_field_shop_loaction_value, node.type AS node_type, node.vid AS node_vid, node_data_field_shop_loaction.field_prefecture_value AS node_data_field_shop_loaction_field_prefecture_value FROM node node LEFT JOIN content_type_shops node_data_field_shop_loaction ON node.vid = node_data_field_shop_loaction.vid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'content_access_author') OR (na.gid = 1 AND na.realm = 'content_access_rid'))) AND ( (node.status <> 0) AND (node.type in ('shops')) )GROUP BY nid ) count_alias in /home/dirtybik/public_html/sites/all/modules/views/includes/view.inc on line 739.
- user warning: Out of resources when opening file '/tmp/#sql_e7c_0.MYD' (Errcode: 24) query: SELECT DISTINCT(node.nid) AS nid, node.title AS node_title, node.language AS node_language, node_data_field_shop_loaction.field_shop_loaction_value AS node_data_field_shop_loaction_field_shop_loaction_value, node.type AS node_type, node.vid AS node_vid, node_data_field_shop_loaction.field_prefecture_value AS node_data_field_shop_loaction_field_prefecture_value FROM node node LEFT JOIN content_type_shops node_data_field_shop_loaction ON node.vid = node_data_field_shop_loaction.vid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'content_access_author') OR (na.gid = 1 AND na.realm = 'content_access_rid'))) AND ( (node.status <> 0) AND (node.type in ('shops')) )GROUP BY nid LIMIT 0, 400 in /home/dirtybik/public_html/sites/all/modules/views/includes/view.inc on line 765.