Warning:  [mysql error 145] Table './Photos/piwigo_images' is marked as crashed and should be repaired

SELECT DISTINCT(WEEKDAY(date_creation)) as period,
  COUNT(DISTINCT id) as nb_images FROM piwigo_images
INNER JOIN piwigo_image_category ON id = image_id
WHERE category_id IN (172)
     AND date_creation BETWEEN '2016-01-01' AND '2016-12-31 23:59:59' AND WEEK(date_creation, 5)+1=42
  GROUP BY period; in /home/e-smith/files/ibays/piwigo/html/include/dblayer/functions_mysqli.inc.php on line 864