Warning:  [mysql error 1] Can't create/write to file '/tmp/#sql_68e6_0.MYI' (Errcode: 30)

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 (8))
    AND author IS NOT NULL
  GROUP BY author, id
  ORDER BY author
; in /home/hotchkiss/public_html/photo/include/dblayer/functions_mysqli.inc.php on line 856