Hello
I got the following message when I try to browse a category
Warning: pg_query(): Query failed: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list LINE 8: ORDER BY date_available DESC, file ASC, id ASC ^ in /srv/www/lighttpd/bluebox/piwigo/include/dblayer/functions_pgsql.inc.php on line 122 SELECT DISTINCT(image_id) FROM piwigo_image_category INNER JOIN piwigo_images ON id = image_id WHERE category_id = 4 ORDER BY date_available DESC, file ASC, id ASC ;
ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list LINE 8: ORDER BY date_available DESC, file ASC, id ASC
I am having the same error message whenever I click on an image or on a category.
This does make Piwigo completely unusable.