0003211: Can't give an order to pwg.tags.getImages

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 ]

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 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

Issue History
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

Notes
(0007783) Epy (reporter) 2015.03.16 10:53	(Sorry, I didn't see the first bug report when I searched)