SQL Error: Error writing file '/tmp/MYP9ZIQT' (Errcode: 28 - No space left on device) at /home/shef/isras.ru/html/dreamedit/includes/class.Ilines.php line 1767<br><pre>Array
(
    [code] => 3
    [message] => Error writing file '/tmp/MYP9ZIQT' (Errcode: 28 - No space left on device)
    [query] =>  SELECT z.*,IF(IFNULL(d2.icont_text,'')='',z.ddd,d2.icont_text) AS date2,itype,
		REPLACE(SUBSTRING(d22,1,10),'.','')  AS ddd2
		
			FROM ( SELECT ie.el_id AS ARRAY_KEY, ie.itype_id AS itype,ie.*, IFNULL(d2.icont_text,'') AS ddd ,d22.icont_text AS d22 FROM adm_ilines_content AS ic, adm_ilines_element AS ie  INNER JOIN adm_ilines_content AS innerTable0 ON ie.el_id = innerTable0.el_id AND innerTable0.icont_var= 'DATE2'  INNER JOIN adm_ilines_content AS d2 ON d2.el_id=ie.el_id AND (d2.icont_var='date2' OR d2.icont_var='dates_')  INNER JOIN adm_ilines_content AS d ON d.el_id=ie.el_id AND d.icont_var='date'  LEFT OUTER JOIN adm_ilines_content AS m ON m.el_id=ie.el_id AND m.icont_var='main'   LEFT OUTER JOIN adm_ilines_content AS ss ON ss.el_id=ie.el_id AND ss.icont_var='status2'  LEFT OUTER JOIN adm_ilines_content AS d22 ON d22.el_id=ie.el_id AND (d22.icont_var='date2')  WHERE (ie.itype_id = 2 OR ((ie.itype_id=3 OR ie.itype_id=8 OR ie.itype_id=56 ) AND IFNULL(d2.icont_text,'')<>'' AND IFNULL(m.icont_text,0)=1))AND ie.el_id = ic.el_id  AND d2.icont_text NOT LIKE '2024.11.22%' AND  ic.icont_var  = 'status' AND ic.icont_text <> '' AND ic.icont_text IS NOT NULL  AND ((ie.itype_id=8 AND m.icont_text=1) OR ie.itype_id<>8)  AND IFNULL(ss.icont_text,0)<>1  AND (ie.itype_id <> 3 OR m.icont_text=1) AND IFNULL(ss.icont_text,1)<>0  AND (ie.itype_id<>8 OR (ie.itype_id=8 AND (REPLACE(SUBSTRING(d2.icont_text,1,10),'.','')<=20241202 OR REPLACE(SUBSTRING(d.icont_text,1,10),'.','')=20241122))) GROUP BY ie.el_id   ORDER BY  innerTable0.icont_text DESC ) AS z  LEFT OUTER JOIN adm_ilines_content AS d2 ON d2.el_id=z.el_id AND (d2.icont_var='dates')  ORDER BY  IF (REPLACE(SUBSTRING(z.ddd,1,10),'.','')>20241122 AND z.itype=8,0,1) ASC, 
CASE 
         WHEN itype = 8 AND ddd2>20241122  THEN ddd2 
        ELSE NULL 
    END ASC,
    CASE 
        WHEN itype <> 8 OR  ddd2<20241122 THEN ddd2 
        ELSE NULL 
    END DESC
			 LIMIT 2 
    [context] => /home/shef/isras.ru/html/dreamedit/includes/class.Ilines.php line 1767
)
</pre>