SiT! Bugs - SiT!
View Issue Details
0001954SiT!dashboardpublic2014-10-15 16:572015-04-25 13:54
dipohl 
paulh 
normalmajoralways
resolvedfixed 
LinuxLinux2.6+later
3.67 LTS 
Current SVN 
0001954: dashboard_my_incidents.php shows closed tickets
mysql-server-5.1.73-3.el6_5.x86_64
php-mysql-5.3.3-27.el6_5.2.x86_64

Installed and activated the plugin v.1.44
Downloaded from here: http://sitracker.org/wiki/Dashboard_my_incidents [^]
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);

No tags attached.
Issue History
2014-10-15 16:57dipohlNew Issue
2015-04-25 13:54paulhNote Added: 0004968
2015-04-25 13:54paulhAssigned To => paulh
2015-04-25 13:54paulhStatusnew => feedback
2015-04-25 13:54paulhResolutionopen => fixed
2015-04-25 13:54paulhFixed in Version => Current SVN
2015-04-25 13:54paulhStatusfeedback => resolved

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