Warning:  [mysql error 3] Error writing file '/tmp/MYpQtg4o' (Errcode: 28 - No space left on device)

SELECT
    author,
    id
  FROM piwigo_images AS i
    JOIN piwigo_image_category AS ic ON ic.image_id = i.id
   WHERE  (category_id NOT IN (318,250,236,316,275,221,311,343,287,294,313,303,281,285,277,341,98,90,233,234,191,192,109,111,196,243,246,220,213,211,212))
    AND author IS NOT NULL
  GROUP BY author, id
  ORDER BY author
; in /var/www/html/library/public/gallery/include/dblayer/functions_mysqli.inc.php on line 856