Announcement

#1 2016-05-15 22:00:00

spartyguy
Member
2016-05-15
1

Error after Upload

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

 

#2 2016-05-16 11:29:57

flop25
Piwigo Team
2006-07-06
7037

Re: Error after Upload

Hello

spartyguy wrote:

MySQL version: 5.7.12

that's the problem [Github] Piwigo issue #376 Solution currently [Github] Piwigo issue #376


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

Board footer

Powered by FluxBB

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