SiT! Bugs - SiT! | |||||
View Issue Details | |||||
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. | ||||
Relationships | |||||
Attached Files | |||||
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 |
Notes | |||||
|
|||||
|
|