Error: Disk full (/tmp/#sql_30182e_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Query: SELECT pi.*, f.hidden, f.sourceID, s.sourcehidden, f.path, f.ext FROM cms_mod_picture_item pi LEFT JOIN cms_files f ON f.id = pi.imageID LEFT JOIN cms_files_source s ON s.id = f.sourceID WHERE pi.deleted="0" and pi.listID="490" and ((pi.startTime <= "18:14:00" and (pi.endTime > "18:14:00" or pi.endTime = "00:00:00" or (pi.endTime < "18:14:00" and endTime < pi.startTime )) or (pi.startTime >= "18:14:00" and pi.endTime > "18:14:00" and pi.endTime < pi.startTime))) and pi.appear <= "2025-04-07 18:14:00" and (pi.expire >= "2025-04-07 18:14:00" or pi.expire ="0000-00-00 00:00:00") and pi.hide = "0" HAVING pi.imageID = 0 OR (f.hidden != "1" AND (f.sourceID = 0 OR s.sourcehidden != "1")) order by RAND()
Location: /data/home/emuweb/www/module/picture/picture.php:Line 71
Query: SELECT pi.*, f.hidden, f.sourceID, s.sourcehidden, f.path, f.ext FROM cms_mod_picture_item pi LEFT JOIN cms_files f ON f.id = pi.imageID LEFT JOIN cms_files_source s ON s.id = f.sourceID WHERE pi.deleted="0" and pi.listID="490" and ((pi.startTime <= "18:14:00" and (pi.endTime > "18:14:00" or pi.endTime = "00:00:00" or (pi.endTime < "18:14:00" and endTime < pi.startTime )) or (pi.startTime >= "18:14:00" and pi.endTime > "18:14:00" and pi.endTime < pi.startTime))) and pi.appear <= "2025-04-07 18:14:00" and (pi.expire >= "2025-04-07 18:14:00" or pi.expire ="0000-00-00 00:00:00") and pi.hide = "0" HAVING pi.imageID = 0 OR (f.hidden != "1" AND (f.sourceID = 0 OR s.sourcehidden != "1")) order by RAND()
Location: /data/home/emuweb/www/module/picture/picture.php:Line 71