Warning:  [mysql error 1] Can't create/write to file '/var/tmp/#sql_46b_0.MAI' (Errcode: 2 "No such file or directory")

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 piwigo_image_category AS ic
    INNER JOIN piwigo_comments AS com
    ON ic.image_id = com.image_id
    LEFT JOIN piwigo_users As u
    ON u.id = com.author_id
  WHERE 1=1
    AND validated='true'
    AND  1 = 1
  GROUP BY comment_id
  ORDER BY date DESC
  LIMIT 10 OFFSET 0
; in /var/www/html/datix/photos/include/dblayer/functions_mysqli.inc.php on line 845