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

SELECT DISTINCT(DAYOFMONTH(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 (1,89,109,112,124,165,180,193,200,214)
     AND date_creation BETWEEN '2018-04-01' AND '2018-04-30 23:59:59'
  GROUP BY period; in /home/e-smith/files/ibays/piwigo/html/include/dblayer/functions_mysqli.inc.php on line 864