0001565: Unable to validate a comment from the picture page

Piwigo Bugtracker

Viewing Issue Advanced Details [ Jump to Notes ]

[ Issue History ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0001565

[Piwigo] user comments

major

always

2010.04.03 12:41

2010.04.05 00:47

Reporter

grum

View Status

public

Assigned To

plg

Priority

normal

Resolution

fixed

Platform

Status

closed

Projection

none

OS Version

ETA

none

Fixed in Version

2.1.0RC2

Product Version

2.1.0RC1

Target Version

2.1.0RC2

Product Build

Summary

0001565: Unable to validate a comment from the picture page

Description

On the picture page, when clicking the button "validate", an error message is displayed :

---------------------------------------------------------------------
Notice: Undefined index: comment_to_delete in /home/..../testpwgtrunk/html/picture.php on line 369
Piwigo encountered a non recoverable error

[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

SELECT
    author_id
  FROM piwigo_comments
  WHERE id =
;

# 1 my_error /home/..../testpwgtrunk/html/include/dblayer/functions_mysql.inc.php(81)
# 2 pwg_query /home/..../testpwgtrunk/html/include/functions_comment.inc.php(345)
# 3 get_comment_author_id /home/..../testpwgtrunk/html/picture.php(369)
---------------------------------------------------------------------

Steps To Reproduce

Additional Information

note it's noticed "Undefined index: comment_to_delete"
but it's on the 'validate' button we click

Tags

No tags attached.

browser

any

Database engine and version

PHP version

Web server

Apache 1.3.x

Attached Files

Relationships

Notes
(0003678) grum (administrator) 2010.04.03 12:45	validation works on the comments page

(0003691) svn (reporter) 2010.04.05 00:46	[Subversion] r5653 by plg on trunk -----[Subversion commit log]---------------------------------------------------- bug 1565 fixed: ability to validate a user comment from the picture page (copy/past typo fixed)

Issue History
Date Modified	Username	Field	Change
2010.04.03 12:41	grum	New Issue
2010.04.03 12:41	grum	browser	=> any
2010.04.03 12:41	grum	Web server	=> Apache 1.3.x
2010.04.03 12:42	grum	version	=> 2.1.0RC2
2010.04.03 12:42	grum	Description Updated
2010.04.03 12:45	grum	Note Added: 0003678
2010.04.03 22:19	plg	Status	new => assigned
2010.04.03 22:19	plg	Assigned To	=> plg
2010.04.05 00:46	svn	Checkin
2010.04.05 00:46	svn	Note Added: 0003691
2010.04.05 00:47	plg	Status	assigned => closed
2010.04.05 00:47	plg	Resolution	open => fixed
2010.04.05 00:47	plg	version	2.1.0RC2 => 2.1.0RC1
2010.04.05 00:47	plg	Fixed in Version	=> 2.1.0RC2
2010.04.05 00:47	plg	Target Version	=> 2.1.0RC2

Mantis 1.1.6[^]

Contact