Piwigo Bugtracker

Piwigo bug tracker has moved to Github

This bugtracker is kept to provide history on old issues.


View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0003163Piwigoweb APIpublic2014.10.21 09:122015.03.16 10:29
Reporterwahlis 
Assigned Torvelices 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOSLinuxOS VersionDebian 7
Product Version2.7.1 
Target Version2.8.0beta1Fixed in Version2.8.0beta1 
Summary0003163: pwg.tags.getImages can't handle order
DescriptionIf you try to add order to pwg.tags.getImages Piwigo generates broken sql.

Additional InformationWarning: [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'id' at line 7

SELECT id
  FROM images i
    INNER JOIN image_category ic ON id=ic.image_id
    INNER JOIN image_tag it ON id=it.image_id
    WHERE tag_id IN (111)
  GROUP BY id
id in /var/www/piwigo/include/dblayer/functions_mysqli.inc.php on line 830


Fatal error: Call to a member function fetch_assoc() on boolean in /var/www/piwigo/include/dblayer/functions_mysqli.inc.php on line 891
TagsNo tags attached.
browserany
Database engine and version
PHP version
Web serverApache 1.3.x
Attached Files

- Relationships
has duplicate 0003211new Can't give an order to pwg.tags.getImages 

-  Notes
(0007707)
svn (reporter)
2014.11.03 22:07

[Subversion] r30359 by rvelices on trunk

-----[Subversion commit log]----------------------------------------------------
bug 3163: pwg.tags.getImages mysql error if order parameter is provided

- Issue History
Date Modified Username Field Change
2014.10.21 09:12 wahlis New Issue
2014.10.21 09:12 wahlis browser => any
2014.10.21 09:12 wahlis Web server => Apache 1.3.x
2014.11.03 22:07 svn Checkin
2014.11.03 22:07 svn Note Added: 0007707
2014.11.03 22:09 rvelices Assigned To => rvelices
2014.11.03 22:09 rvelices Status new => closed
2014.11.03 22:09 rvelices Resolution open => fixed
2014.11.03 22:09 rvelices Fixed in Version => 2.8.0beta1
2014.11.03 22:09 rvelices Target Version => 2.8.0beta1
2015.03.16 10:29 rvelices Relationship added has duplicate 0003211


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