Aktuelles
MySQL error 1030: Got error 28 from storage engine
SQL query that caused the error:
SELECT gallery.*, DATE_FORMAT(gallery.date, '%d.%m.%Y') AS `date`, image.filename AS `image_filename`, MD5(CONCAT('image', image.id, 'filename')) AS `image_filename_md5` FROM `gallery` LEFT JOIN `gallery_image` ON gallery.id = gallery_image.gallery_id AND gallery_image.pos = 0 LEFT JOIN `image` ON gallery_image.image_id = image.id WHERE gallery.enabled != 'FALSE' AND YEAR(gallery.date) = YEAR(NOW()) OR YEAR(gallery.date) = (YEAR(NOW())-1) GROUP BY gallery.id ORDER BY gallery.date DESC