SiT! Bugs

View Issue Details Jump to Notes ] Issue History ] Print ]
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.
Attached Files

- Relationships

-  Notes
User avatar (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


Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker