Warning:  [mysql error 126] Incorrect key file for table '/tmp/#sql_4b34_11.MYI'; try to repair it

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 /web/talkgear.fun/photo/include/dblayer/functions_mysqli.inc.php on line 856