SiT! Bugs - SiT!
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0001954SiT!dashboardpublic2014-10-15 16:572015-04-25 13:54
Reporterdipohl 
Assigned Topaulh 
PrioritynormalSeveritymajorReproducibilityalways
StatusresolvedResolutionfixed 
PlatformLinuxOSLinuxOS Version2.6+later
Product Version3.67 LTS 
Target VersionFixed in VersionCurrent SVN 
Summary0001954: dashboard_my_incidents.php shows closed tickets
Descriptionmysql-server-5.1.73-3.el6_5.x86_64
php-mysql-5.3.3-27.el6_5.2.x86_64

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

TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
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