0002892: [pwg.images.setInfo] empty tag_ids input parameter produces errors

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

0002892

Piwigo

web API

public

2013.04.19 22:14

2013.04.19 22:22

Reporter

plg

Assigned To

plg

Priority

normal

Severity

minor

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

2.5.0

Target Version

2.5.1

Fixed in Version

2.5.1

Summary

0002892: [pwg.images.setInfo] empty tag_ids input parameter produces errors

Description

with define multiple_value_mode=replace :

Warning: [mysql error 1048] Column \'tag_id\' cannot be null

INSERT  INTO piwigo_image_tag
  (image_id,tag_id)
  VALUES(\'74\',NULL) in .../include/dblayer/functions_mysqli.inc.php on line 834

or define multiple_value_mode=append :

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 \')\' at line 4

DELETE
  FROM piwigo_image_tag
  WHERE image_id IN (74)
    AND tag_id IN ()
; in .../include/dblayer/functions_mysqli.inc.php on line 834

Warning: [mysql error 1048] Column \'tag_id\' cannot be null

INSERT  INTO piwigo_image_tag
  (image_id,tag_id)
  VALUES(\'74\',NULL) in .../include/dblayer/functions_mysqli.inc.php on line 834

Tags

No tags attached.

browser

any

Database engine and version

PHP version

Web server

Apache 1.3.x

Attached Files

Relationships

Notes
(0006934) svn (reporter) 2013.04.19 22:18	[Subversion] r22301 by plg on branch 2.5 -----[Subversion commit log]---------------------------------------------------- bug 2892 fixed: no more error when tag_ids input parameter is empty (but provided) on pwg.images.setInfo.

(0006935) svn (reporter) 2013.04.19 22:19	[Subversion] r22302 by plg on trunk -----[Subversion commit log]---------------------------------------------------- merge r22301 from branch 2.5 to trunk bug 2892 fixed: no more error when tag_ids input parameter is empty (but provided) on pwg.images.setInfo.

Issue History
Date Modified	Username	Field	Change
2013.04.19 22:14	plg	New Issue
2013.04.19 22:14	plg	Status	new => assigned
2013.04.19 22:14	plg	Assigned To	=> plg
2013.04.19 22:14	plg	browser	=> any
2013.04.19 22:14	plg	Web server	=> Apache 1.3.x
2013.04.19 22:18	svn	Checkin
2013.04.19 22:18	svn	Note Added: 0006934
2013.04.19 22:19	svn	Checkin
2013.04.19 22:19	svn	Note Added: 0006935
2013.04.19 22:22	plg	Status	assigned => closed
2013.04.19 22:22	plg	Resolution	open => fixed
2013.04.19 22:22	plg	Fixed in Version	=> 2.5.1

Contact