From Bugzilla Helper: User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.5) Gecko/20031110 Firebird/0.7 Description of problem: I'm using PostgreSQL 7.3.4 on Fedora Core 1. When you run "processmail rescanall", it compares lastdiffed to delta_ts in the "bugs" table. delta_ts contains microseconds, and lastdiffed does not. So, delta_ts is always greater than lastdiffed. Thus, _all_ bugs are returned as having not had their email sent. I'll attach a patch as my next action after I submit this bug. -M Version-Release number of selected component (if applicable): rh-bugzilla-pg-LATEST How reproducible: Always Steps to Reproduce: wesadf Additional info:
Created attachment 96101 [details] Make the SQL truncate delta_ts at the second Here's a patch against just the processmail file. -M
By the way, dkl, did you ever look at this? It also happens in sanitycheck.cgi. I think a better solution than mine might be to actually date_trunc() delta_ts when it's INSERTed, instead of when it's read. Also, I discovered that I had to modify this patch slightly -- I'll post another version, perhaps. -M
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.
No longer relevant for current releases of Bugzilla.