Warning:  [mysql error 1] Can't create/write to file '/tmp/MYZoKhBF' (Errcode: 13 "Permission denied")

SELECT DISTINCT(image_id),date_available, file, id
  FROM piwigo_image_category
    INNER JOIN piwigo_images ON id = image_id
  WHERE
    1=1

   ORDER BY date_available DESC, file ASC, id ASC
; in /var/www/gallery.digitalshot.fr/include/dblayer/functions_mysql.inc.php on line 651