Piwigo bug tracker has moved to Github
This bugtracker is kept to provide history on old issues.
Anonymous | Login | Signup for a new account | 2018.04.19 21:28 CEST | ![]() |
My View | View Issues | Change Log | Roadmap |
View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||||||
ID | Project | Category | View Status | Date Submitted | Last Update | ||||||||
0003211 | Piwigo | web API | public | 2015.03.15 16:26 | 2015.03.16 10:53 | ||||||||
Reporter | Epy | ||||||||||||
Assigned To | |||||||||||||
Priority | normal | Severity | crash | Reproducibility | always | ||||||||
Status | new | Resolution | open | ||||||||||
Platform | OS | OS Version | |||||||||||
Product Version | 2.7.4 | ||||||||||||
Target Version | Fixed in Version | ||||||||||||
Summary | 0003211: Can't give an order to pwg.tags.getImages | ||||||||||||
Description | Hi, I was playing with webservices with a python script and web UI here: http://piwigo.org/demo/tools/ws.htm#top [^] when I got this error: If I send any authorized value (from the info popup) in the "order" field I get a MySQL error Warning: [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 'RAND()' at line 8 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 (72) AND (category_id NOT IN (9,10,11,12,13,18,28,65,66,67,48,50,71) AND level<=0) GROUP BY id RAND() in /home/sys/var/www/piwigo.org/demo/include/dblayer/functions_mysqli.inc.php on line 830 Fatal error: Call to a member function fetch_assoc() on a non-object in /home/sys/var/www/piwigo.org/demo/include/dblayer/functions_mysqli.inc.php on line 891 | ||||||||||||
Steps To Reproduce | Go to: http://piwigo.org/demo/tools/ws.htm [^] Choose pwg.tags.getImages on the left Enter a tag id (e.g. 72 'Weather') Enter an order for sorting from the info button, for example 'random' or 'date_creation' Select "Invoke", you'll get the error in result frame | ||||||||||||
Additional Information | I don't have a gallery right now, so I just played with the demo one and didn't try another That's why I don't have any information on webserver software versions or piwigo version | ||||||||||||
Tags | No tags attached. | ||||||||||||
browser | Mozilla | ||||||||||||
Database engine and version | |||||||||||||
PHP version | |||||||||||||
Web server | Apache 2 | ||||||||||||
Attached Files | |||||||||||||
![]() |
|
(0007783) Epy (reporter) 2015.03.16 10:53 |
(Sorry, I didn't see the first bug report when I searched) |
![]() |
|||
Date Modified | Username | Field | Change |
2015.03.15 16:26 | Epy | New Issue | |
2015.03.16 10:29 | rvelices | Relationship added | duplicate of 0003163 |
2015.03.16 10:53 | Epy | Note Added: 0007783 |
Copyright © 2000 - 2018 MantisBT Team Contact |