Anonymous | Login | Signup for a new account | 2021-04-16 11:43 BST | ![]() |
Main | My View | View Issues | Change Log | Roadmap |
View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||
ID | 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 | 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 | |||||||||
![]() |
|||
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 - 2021 MantisBT Team |