MantisBT - Piwigo
View Issue Details
0001722Piwigodatabasepublic2010.06.04 20:582010.06.09 22:27
nikrou 
nikrou 
normalmajoralways
closedfixed 
2.1.1 
2.1.22.1.2 
any
Apache 1.3.x
0001722: PosgtreSQL wants all fields in select to be in Group by clause or agregate function
After installation, we try to know if we use an external table for users and the following query failed :
SELECT COUNT(1) AS counter, ui.*, uc.*, t.name AS theme_name FROM piwigo_user_infos AS ui LEFT JOIN piwigo_user_cache AS uc ON ui.user_id = uc.user_id LEFT JOIN piwigo_themes AS t ON t.id = ui.theme WHERE ui.user_id = '2' GROUP BY ui.user_id ;

An idea is to add a new configuration variable for people using external authentification in config_default.inc.php :

$conf['external_authentication'] = false;

After we will use that new variable to make two queries without group by clause and it will make the trick.

http://piwigo.org/forum/viewtopic.php?pid=113765#p113765 [^]
No tags attached.
Issue History
2010.06.04 20:58nikrouNew Issue
2010.06.04 20:58nikroubrowser => any
2010.06.04 20:58nikrouWeb server => Apache 1.3.x
2010.06.09 22:19nikrouStatusnew => assigned
2010.06.09 22:19nikrouAssigned To => nikrou
2010.06.09 22:25svnCheckin
2010.06.09 22:25svnNote Added: 0003967
2010.06.09 22:26svnCheckin
2010.06.09 22:26svnNote Added: 0003968
2010.06.09 22:27nikrouStatusassigned => closed
2010.06.09 22:27nikrouResolutionopen => fixed
2010.06.09 22:27nikrouFixed in Version => 2.1.2

Notes
(0003967)
svn   
2010.06.09 22:25   
[Subversion] r6510 by nikrou on trunk

-----[Subversion commit log]----------------------------------------------------
Fix bug 1722 : PosgtreSQL wants all fields in select to be in Group by clause
or agregate function
Fix issue for lambda function (incorrect number of params)
(0003968)
svn   
2010.06.09 22:26   
[Subversion] r6511 by nikrou on branch 2.1

-----[Subversion commit log]----------------------------------------------------
Fix bug 1722 : PosgtreSQL wants all fields in select to be in Group by clause
or agregate function
Fix issue for lambda function (incorrect number of params)

merge from trunk.