Piwigo Bugtracker

Viewing Issue Advanced Details Jump to Notes ] Issue History ] Print ]
ID Category Severity Reproducibility Date Submitted Last Update
0001722 [Piwigo] database major always 2010.06.04 20:58 2010.06.09 22:27
Reporter nikrou View Status public  
Assigned To nikrou
Priority normal Resolution fixed Platform
Status closed   OS
Projection none   OS Version
ETA none Fixed in Version 2.1.2 Product Version 2.1.1
  Target Version 2.1.2 Product Build
Summary 0001722: PosgtreSQL wants all fields in select to be in Group by clause or agregate function
Description 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.

Steps To Reproduce
Additional Information http://piwigo.org/forum/viewtopic.php?pid=113765#p113765 [^]
Tags No tags attached.
browser any
Database engine and version
PHP version
Web server Apache 1.3.x
Attached Files

- Relationships

-  Notes
(0003967)
svn (reporter)
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 (reporter)
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.

- Issue History
Date Modified Username Field Change
2010.06.04 20:58 nikrou New Issue
2010.06.04 20:58 nikrou browser => any
2010.06.04 20:58 nikrou Web server => Apache 1.3.x
2010.06.09 22:19 nikrou Status new => assigned
2010.06.09 22:19 nikrou Assigned To => nikrou
2010.06.09 22:25 svn Checkin
2010.06.09 22:25 svn Note Added: 0003967
2010.06.09 22:26 svn Checkin
2010.06.09 22:26 svn Note Added: 0003968
2010.06.09 22:27 nikrou Status assigned => closed
2010.06.09 22:27 nikrou Resolution open => fixed
2010.06.09 22:27 nikrou Fixed in Version => 2.1.2


Mantis 1.1.6[^]
Copyright © 2000 - 2008 Mantis Group
Contact
Powered by Mantis Bugtracker