Error: Disk full (/tmp/#sql_1e4705_0.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="224" and
((pi.startTime <= "13:39:00" and (pi.endTime > "13:39:00" or pi.endTime = "00:00:00" or (pi.endTime < "13:39:00" and endTime < pi.startTime )) or (pi.startTime >= "13:39:00" and pi.endTime > "13:39:00" and pi.endTime < pi.startTime)))
and pi.appear <= "2024-06-10 13:39:00" and (pi.expire >= "2024-06-10 13:39: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