Announcement

  •  » Beta testing
  •  » Postgresql : Error while browsing category

#1 2010-12-19 14:54:02

EdB
Guest

Postgresql : Error while browsing category

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

 

#2 2011-01-01 17:28:15

J. Roeleveld
Guest

Re: Postgresql : Error while browsing category

I am having the same error message whenever I click on an image or on a category.
This does make Piwigo completely unusable.

 
  •  » Beta testing
  •  » Postgresql : Error while browsing category

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2024 · Contact