Warning:  [mysql error 3] Error writing file '/tmp/MYAVLOYh' (Errcode: 28)

SELECT DISTINCT(image_id)
  FROM piwigo_image_category
    INNER JOIN piwigo_images ON id = image_id
  WHERE
    1=1
AND (category_id NOT IN (879,883,890,894,909,912,933,114,115,116,117,100,376,124,125,120,121,122,387,931,927))
  ORDER BY date_available DESC, file ASC, id ASC
; in /usr/share/piwigo/include/dblayer/functions_mysqli.inc.php on line 845