SiT! Bugs - SiT!
View Issue Details
0000246SiT!incidentspublic2008-11-24 17:312010-03-04 17:38
gdavidvlk 
paulh 
normalminoralways
closedfixed 
3.40 
3.413.41 
0000246: Malformed sql query in reopen_incident.php module
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
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
No tags attached.
Issue History
2008-11-24 17:31gdavidvlkNew Issue
2008-11-24 20:35paulhNote Added: 0000205
2008-11-24 20:35paulhAssigned To => paulh
2008-11-24 20:35paulhStatusnew => resolved
2008-11-24 20:35paulhResolutionopen => fixed
2008-11-24 20:35paulhFixed in Version => 3.41
2008-11-24 20:35paulhTarget Version => 3.41
2010-03-04 17:38ivanStatusresolved => closed

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