Seiten: 1
Hallo
Ich bekomme bei meiner erst einrichtung von piwigo überall mysql fehler:
Warning: [mysql error 3065] Expression #1 of ORDER BY clause is not in SELECT list, references column 'db37153.piwigovrmd_images.date_available' which is not in SELECT list; this is incompatible with DISTINCT
SELECT DISTINCT(id)
FROM piwigovrmd_images
INNER JOIN piwigovrmd_image_category AS ic ON id = ic.image_id
WHERE date_available>=LEAST(SUBDATE(CURRENT_DATE,INTERVAL 7 DAY),SUBDATE('2016-06-11 13:25:17',INTERVAL 1 DAY))
ORDER BY date_available DESC,date_available DESC, file ASC, id ASC
; in /homepages/xxx/yyy/include/dblayer/functions_mysqli.inc.php on line 832
Fatal error: Call to a member function fetch_assoc() on boolean in /homepages/xxx/yyy/include/dblayer/functions_mysqli.inc.php on line 893
Piwigo 2.8.1
PHP: 5.6.22 (Info anzeigen) [2016-06-13 14:16:48]
MySQL: 5.7.13 [2016-06-13 14:16:48]
Grafikbibliothek: ImageMagick 6.7.7-10
Seiten: 1