Can\'t create/write to file \'/tmp/#sql_1_0.MYI\' (Errcode: 28 - No space left on device) SQL=select a.id as contentid ,a.title as contenttitle ,a.title_alias as titlealias ,\'\' as titlelink ,\'\' as morelink ,a.title as titlehtml ,a.introtext as introtext ,a.fulltext as wholetext ,a.created as created_date ,a.modified as modified_date ,a.access as contentaccess ,if(a.created_by_alias = \'\', u.name, a.created_by_alias) as author ,s.id as sectionid ,s.title as sectiontitle ,s.name as sectionname ,\'\' as sectionlink ,s.title as sectionhtml ,s.access as sectionaccess ,c.id as catid ,c.title as cattitle ,c.name as catname ,\'\' as catlink ,c.title as cathtml ,case when a.access > s.access and a.access > c.access then a.access when s.access > c.access then s.access else c.access end as accesslevel from jos_content a join jos_categories c on (c.id = a.catid) join jos_sections s on (s.id = a.sectionid) left join jos_content_frontpage f on (f.content_id = a.id) left join jos_users u on (u.id = a.created_by) where a.state = \'1\' and (a.publish_up = \'0000-00-00 00:00:00\' or a.publish_up <= now()) and (a.publish_down = \'0000-00-00 00:00:00\' or a.publish_down >= now()) and (s.published = \'1\') and (c.published = \'1\') and ( a.catid in (0,25)) and a.id not in (0,51) order by s.ordering asc, c.ordering asc, a.ordering asc limit 0, 999 |