MYSQL ERROR: Can't create/write to file '/tmp/#sql_6cc6_0.MAI' (Errcode: 28 "No space left on device")
Query: SELECT *, CONCAT(date_date, ' ', date_time) AS datetime,date_format(date_date, '%M %e, %Y ') AS date_show_date , time_format(date_time, '%l:%i %p') AS date_time_show,date_format(last_modified, '%M %e, %Y %l:%i %p') AS last_modified , date_format(date_expire, '%M %e, %Y ') AS date_expire_show FROM ms_calendar LEFT JOIN ms_blog_cats_connect ON ms_calendar.date_id=ms_blog_cats_connect.con_prod LEFT JOIN ms_blog_categories ON ms_calendar.date_cat=ms_blog_categories.cat_id WHERE date_public!='2' AND date_public!='4' AND date_type='news' AND (book_special_event_date='0000-00-00' OR book_special_event_date>'2026-05-07' ) AND (ms_calendar.date_cat='109' OR ms_blog_cats_connect.con_cat='109' ) AND page_under='0' AND date_id!='0' AND CONCAT(date_date, ' ', date_time)<='2026-05-07 07:29:33' AND private<='1' GROUP BY date_id ORDER BY date_date DESC,date_time DESC LIMIT 0,20
Query: SELECT *, CONCAT(date_date, ' ', date_time) AS datetime,date_format(date_date, '%M %e, %Y ') AS date_show_date , time_format(date_time, '%l:%i %p') AS date_time_show,date_format(last_modified, '%M %e, %Y %l:%i %p') AS last_modified , date_format(date_expire, '%M %e, %Y ') AS date_expire_show FROM ms_calendar LEFT JOIN ms_blog_cats_connect ON ms_calendar.date_id=ms_blog_cats_connect.con_prod LEFT JOIN ms_blog_categories ON ms_calendar.date_cat=ms_blog_categories.cat_id WHERE date_public!='2' AND date_public!='4' AND date_type='news' AND (book_special_event_date='0000-00-00' OR book_special_event_date>'2026-05-07' ) AND (ms_calendar.date_cat='109' OR ms_blog_cats_connect.con_cat='109' ) AND page_under='0' AND date_id!='0' AND CONCAT(date_date, ' ', date_time)<='2026-05-07 07:29:33' AND private<='1' GROUP BY date_id ORDER BY date_date DESC,date_time DESC LIMIT 0,20