mediamax.am
2014-11-23 08:19
Fatal error : SQL error : Incorrect key file for table '/tmp/#sql_48b_0.MYI'; try to repair it
(SELECT sed_znews.id,sed_znews.alias, sed_znewsentries.id as nid, sed_znewsentries_info.title as ntitle, sed_znewsentries.exclusive as exclusive, sed_znewsentries.persona as persona, DATE_FORMAT(date, '%w.%d.%m.%Y.%H.%i') AS date, sed_znewsentries_info.short_description, sed_znewsentries_views_day_tmp.hit as ht, sed_znews.parent_id, 'news' as tbl FROM sed_znewsentries INNER JOIN sed_znewsentries_info ON (sed_znewsentries.id = sed_znewsentries_info.sed_znewsentries_id) INNER JOIN sed_znews ON (sed_znewsentries.parent_id = sed_znews.id) INNER JOIN sed_znewsentries_views_day_tmp ON (sed_znewsentries_views_day_tmp.newsentries_id = sed_znewsentries.id) WHERE sed_znewsentries_info.lang='am' AND sed_znews.visible=1 AND (sed_znewsentries.breaking_link>0 OR sed_znewsentries.breaking<1) AND sed_znewsentries.coming_soon=0 AND sed_znewsentries.visible=1 AND sed_znewsentries_info.visible=1 ) UNION ( SELECT sed_zauthors.id, 'column' as alias, sed_zblogsentries.id as nid, sed_zblogsentries_info.title as ntitle, '0' as exclusive, '0' as persona, DATE_FORMAT(date, '%w.%d.%m.%Y.%H.%i') AS date, sed_zblogsentries_info.short_description, sed_zblogsentries_views_day_tmp.hit as ht, sed_zblogsentries.authorsid, 'authors' as tbl FROM sed_zblogsentries INNER JOIN sed_zblogsentries_info ON (sed_zblogsentries.id = sed_zblogsentries_info.sed_zblogsentries_id) INNER JOIN sed_zauthors ON (sed_zblogsentries.authorsid = sed_zauthors.id) INNER JOIN sed_zblogsentries_views_day_tmp ON (sed_zblogsentries_views_day_tmp.blogsentries_id = sed_zblogsentries.id) WHERE sed_zblogsentries_info.lang='am' AND sed_zauthors.visible=1 AND sed_zblogsentries.visible=1 AND sed_zblogsentries_info.visible=1 ) ORDER BY ht DESC, date DESC LIMIT 0,5