Red Hat Bugzilla – Bug 136885
divide by zero error when selecting % complete
Last modified: 2013-06-23 22:55:09 EDT
User-Agent: Build Identifier: When viewing a bug list, if you change fields to include % complete and any of the estimate fields contain 0.0 (what are the chances of that happening?), you get a divide by 0 error. Reproducible: Always Steps to Reproduce: 1.View bug 123574, 2.build the dependency list 3.view as a bug list 4.change fields to add % complete 2. 3. Actual Results: 5.boom Expected Results: Well, if people actually filled in all the estimate fields, it should be OK, but there will always be slackers who don't, so perhaps put a check in for 0 before calculating percentage. DBD::Pg::st execute failed: ERROR: division by zero on numeric [for Statement "SELECT bugs.bug_id, bugs.bug_severity, bugs.priority, bugs.bug_status, bugs.resolution, bugs.remaining_time, (SUM(ldtime.work_time)*COUNT(DISTINCT ldtime.bug_when)/COUNT(bugs.bug_id)) AS actual_time, bugs.alias, bugs.bug_severity, bugs.priority, bugs.rep_platform, map_assigned_to.login_name, bugs.bug_status, bugs.resolution, (SUM(ldtime.work_time)*COUNT(DISTINCT ldtime.bug_when)/COUNT(bugs.bug_id)) AS actual_time, (100*((SUM(ldtime.work_time)*COUNT(DISTINCT ldtime.bug_when)/COUNT(bugs.bug_id))/((SUM(ldtime.work_time)*COUNT(DISTINCT ldtime.bug_when)/COUNT(bugs.bug_id))+bugs.remaining_time))) AS percentage_complete, bugs.short_desc FROM bugs LEFT JOIN bug_group_map ON bug_group_map.bug_id = bugs.bug_id AND bug_group_map.group_id NOT IN (33,22,32,4,31,78,48,75,68,44,12,67,76,41,15,58,25,30,21,35,7,62,61,17,72,50,71$LEFT JOIN cc ON cc.bug_id = bugs.bug_id AND cc.who = 81410 , profiles AS map_assigned_to, longdescs AS ldtime WHERE bugs.assigned_to = map_assigned_to.userid AND ldtime.bug_id = bugs.bug_id AND (bugs.bug_id IN ('131525','125445','117972','130896','132091','131580','126880','132313','10575$AND ((bug_group_map.group_id IS NULL) OR (bugs.reporter_accessible = 1 AND bugs.reporter = 81410) OR (bugs.cclist_accessible = 1 AND cc.who IS NOT NULL) OR (bugs.assigned_to = 81410) OR (bugs.qa_contact = 81410) ) GROUP BY bugs.bug_id, bugs.bug_id,bugs.bug_severity,bugs.priority,bugs.bug_status,bugs.resolution,bug$ORDER BY bugs.bug_status,bugs.bug_id "] at Bugzilla/DB.pm line 74 Bugzilla::DB::SendSQL('SELECT bugs.bug_id, bugs.bug_severity, bugs.priority, bugs.bu...') called at /var/www/bugzilla/beta1/buglist.cgi line 793
Red Hat's current Bugzilla version is 2.18. I am moving all older open bugs to this version. Any bugs against the older versions will need to be verified that they are still bugs. This will help me also to sort them better.
Red Hat Bugzilla is now using version 3.2 of the Bugzilla codebase and therefore this bug will need to be re-verified against the new release. With the updated code this bug may no longer be relevant or may have been fixed in the new code. Updating bug version to 3.2.