Warning:  [mysql error 1021] Disk got full writing '.(temporary)' (Errcode: 28 "No space left on device")

SELECT SQL_CALC_FOUND_ROWS com.id AS comment_id,
       com.image_id,
       ic.category_id,
       com.author,
       com.author_id,
       u.mail_address AS user_email,
       com.email,
       com.date,
       com.website_url,
       com.content,
       com.validated
  FROM image_category AS ic
    INNER JOIN comments AS com
    ON ic.image_id = com.image_id
    LEFT JOIN users As u
    ON u.id = com.author_id
  WHERE 1=1
    AND validated='true'
    AND  (category_id NOT IN (92,99,151,203,238))
  GROUP BY comment_id
  ORDER BY date DESC
  LIMIT 10 OFFSET 0
; in /var/www/piwigo__3/include/dblayer/functions_mysqli.inc.php on line 847