Hello
I am running into an issue after installing and now reinstalling Piwigo. When I click on photos, I get the following error:
Warning: [mysql error 3065] Expression #1 of ORDER BY clause is not in SELECT list, references column 'photo2016.piwigo_images.date_available' which is not in SELECT list; this is incompatible with DISTINCT
SELECT DISTINCT(image_id)
FROM piwigo_image_category
INNER JOIN piwigo_images ON id = image_id
WHERE
category_id = 1
ORDER BY date_available DESC, file ASC, id ASC
; in /Library/Server/Web/Data/Sites/anchorphoto/include/dblayer/functions_mysqli.inc.php on line 832
Fatal error: Call to a member function fetch_assoc() on a non-object in /Library/Server/Web/Data/Sites/anchorphoto/include/dblayer/functions_mysqli.inc.php on line 893
Piwigo version: 2.81
PHP version: 5.5.31
MySQL version: 5.7.12
Piwigo URL: http://anchorphoto.com
Offline
Hello
spartyguy wrote:
MySQL version: 5.7.12
that's the problem [Github] Piwigo issue #376 Solution currently [Github] Piwigo issue #376
Offline