#1 2016-06-13 14:18:29

Tom999
Gast

mysql error wenn ich navigationslinks nutzen will

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

Brett Fußzeile

Unterstützt von FluxBB

github twitter newsletter Spenden Piwigo.org © 2002-2024 · Kontakt