Piwigo Bugtracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0001722Piwigodatabasepublic2010.06.04 20:582010.06.09 22:27
Reporternikrou 
Assigned Tonikrou 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOSOS Version
Product Version2.1.1 
Target Version2.1.2Fixed in Version2.1.2 
Summary0001722: PosgtreSQL wants all fields in select to be in Group by clause or agregate function
DescriptionAfter 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.

Additional Informationhttp://piwigo.org/forum/viewtopic.php?pid=113765#p113765 [^]
TagsNo tags attached.
browserany
Database engine and version
PHP version
Web serverApache 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


Copyright © 2000 - 2015 MantisBT Team
Contact
Powered by Mantis Bugtracker