View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001545 | bugs.cacert.org | misc | public | 2023-01-11 14:14 | 2026-01-21 18:16 |
| Reporter | bdmc | Assigned To | bdmc | ||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | new | Resolution | open | ||
| Platform | Default | OS | any | OS Version | any |
| Summary | 0001545: Date Calculation issues throughout system | ||||
| Description | Date calculations reported in Bug 1544 also occur in other places in the various CACert systems. For instance, date-dependent e-mail messages are not being sent. Locate and correct these date calculations similarly to what was done for 1544. | ||||
| Tags | No tags attached. | ||||
|
|
I have examined all ( most ) of the SQL-related date calculations in the system, and, aside from the ones covered in bug 1544, they are all using the MySQL function unix_timestamp, which returns an integer number of seconds, related to the UNIX epoch. All other parts of those calculations are also integers. Because of that, I do not feel that any of those calculations can produce wrong results in themselves. As always, I am open to guidance as to areas to investigate further. |
|
|
Any notes in answer to my analysis three years ago? |
|
|
Now, another bug arised: If an user revoke any of his/her certificate, new period of 90 days starts. So if s/he do that in a good faith, s/he will get the unwanted result. This behaviour is apparently much better. I have prepared a modified text of "delete init" mail, so it is possible to put it to the Email message patterns for the "Delete accounts" queue. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2023-01-11 14:14 | bdmc | New Issue | |
| 2023-01-11 14:14 | bdmc | Assigned To | => bdmc |
| 2023-01-11 14:15 | bdmc | Relationship added | related to 0001544 |
| 2023-02-08 04:29 | bdmc | Note Added: 0006159 | |
| 2023-02-08 22:35 | bdmc | Note Edited: 0006159 | |
| 2026-01-21 17:38 | bdmc | Note Added: 0006349 | |
| 2026-01-21 18:13 | alkas | Note Added: 0006352 | |
| 2026-01-21 18:16 | alkas | Note Edited: 0006352 |
