Warning:  [mysql error 126] Got error '126 "Index is corrupted"' for '/tmp/#sql-temptable-80007-2f55eb-1ba0b.MAI'

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 piwims_image_category AS ic
    INNER JOIN piwims_comments AS com
    ON ic.image_id = com.image_id
    LEFT JOIN piwims_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 142980
; in /home/transitionmh/public_html/piwigo/include/dblayer/functions_mysqli.inc.php on line 847