0000246: Malformed sql query in reopen_incident.php module

View Issue Details [ Jump to Notes ]

[ Issue History ] [ Print ]

Project

Category

View Status

Date Submitted

Last Update

0000246

SiT!

incidents

public

2008-11-24 17:31

2010-03-04 17:38

Reporter

gdavidvlk

Assigned To

paulh

Priority

normal

Severity

minor

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

3.40

Target Version

3.41

Fixed in Version

3.41

Summary

0000246: Malformed sql query in reopen_incident.php module

Description

Reopening incidents is not possible.
In reopen_incident.php, substitute line 26:
$sql = "SELECT * FROM incidents WHERE id = $id LIMIT 1";
with:
$sql = "SELECT * FROM $dbIncidents WHERE id = $id LIMIT 1";
to let the module work correctly

Additional Information

Thi is the error message:

Application Warning [512]
Table 'sit.incidents' doesn't exist in /home/applicazioni/sit/htdocs/reopen_incident.php @ line 29

The SiT schema may need updating to fix this problem.

Warning [2]
mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/applicazioni/sit/htdocs/reopen_incident.php @ line 30

Tags

No tags attached.

Attached Files

Relationships

Notes
(0000205) paulh (administrator) 2008-11-24 20:35	Thanks gdavidvlk this is now fixed in 3.41 (as for revision 4240)

Issue History
Date Modified	Username	Field	Change
2008-11-24 17:31	gdavidvlk	New Issue
2008-11-24 20:35	paulh	Note Added: 0000205
2008-11-24 20:35	paulh	Assigned To	=> paulh
2008-11-24 20:35	paulh	Status	new => resolved
2008-11-24 20:35	paulh	Resolution	open => fixed
2008-11-24 20:35	paulh	Fixed in Version	=> 3.41
2008-11-24 20:35	paulh	Target Version	=> 3.41
2010-03-04 17:38	ivan	Status	resolved => closed