0001954: dashboard_my_incidents.php shows closed tickets

View Issue Details [ Jump to Notes ]

[ Issue History ] [ Print ]

Project

Category

View Status

Date Submitted

Last Update

0001954

SiT!

dashboard

public

2014-10-15 16:57

2015-04-25 13:54

Reporter

dipohl

Assigned To

paulh

Priority

normal

Severity

major

Reproducibility

always

Status

resolved

Resolution

fixed

Platform

Linux

OS Version

2.6+later

Product Version

3.67 LTS

Target Version

Fixed in Version

Current SVN

Summary

0001954: dashboard_my_incidents.php shows closed tickets

Description

mysql-server-5.1.73-3.el6_5.x86_64
php-mysql-5.3.3-27.el6_5.2.x86_64

Steps To Reproduce

Installed and activated the plugin v.1.44
Downloaded from here: http://sitracker.org/wiki/Dashboard_my_incidents [^]

Additional Information

I fixed the error by changing the select statement in this way:

# diff -u dashboard_my_incidents.php dashboard_my_incidents.php.mine
--- dashboard_my_incidents.php 2010-11-16 17:45:56.000000000 +0100
+++ dashboard_my_incidents.php.mine 2014-10-15 17:55:02.978146266 +0200
@@ -50,7 +50,7 @@
     $nasql .= "($now - lastupdated) AS timesincelastupdate, pr.name AS pname, pr.id as pid ";
     $nasql .= "FROM `{$dbIncidents}` AS i, `{$dbContacts}` AS c, `{$dbPriority}` AS pr ";
     $nasql .= "WHERE owner = {$sit[2]} AND contact = c.id AND i.priority = pr.id ";
- $nasql .= "AND (status!='2' OR status!='7' OR status!='9') ORDER BY pid DESC, i.id ASC ";
+ $nasql .= "AND (status not in (2,7,9)) ORDER BY pid DESC, i.id ASC ";

     $result = mysql_query($nasql);
     if (mysql_error()) trigger_error("MySQL Query Error ".mysql_error(), E_USER_WARNING);

Tags

No tags attached.

Attached Files

Relationships

Notes
(0004968) paulh (administrator) 2015-04-25 13:54	r7598 resolves this, thanks Dipohl

Issue History
Date Modified	Username	Field	Change
2014-10-15 16:57	dipohl	New Issue
2015-04-25 13:54	paulh	Note Added: 0004968
2015-04-25 13:54	paulh	Assigned To	=> paulh
2015-04-25 13:54	paulh	Status	new => feedback
2015-04-25 13:54	paulh	Resolution	open => fixed
2015-04-25 13:54	paulh	Fixed in Version	=> Current SVN
2015-04-25 13:54	paulh	Status	feedback => resolved