Content
View differences
Updated by Cécile Guiot over 1 year ago
### Steps to reproduce
1. There should be at least one date/timestamp field available to filter projects on (Created on, Last activity at, …)
2. Open any project query, for example the default one [http://localhost:3000/projects](http://localhost:3000/projects)
3. Add a filter by the date/timestamp field, operator will be `less than days ago` by default and specify `10000000` as value
4. Click on "Apply"
### What is the buggy behavior?
* Page with status 500 is shown
### What is the expected behavior?
There are multiple possibilities:
* From Ivan: Do not Showing it as an error in the filter form
* Error is on database level, so ensure date is in supported range
* Ignore the filter and show any a notification about that
### **Logs**
```log
PG::DatetimeFieldOverflow: ERROR: timestamp out of range: "25356-11-13 23:59:59.999999 BC"
LINE 1: ...jects.active IN ('t')) AND (projects.created_at > '25356-11-...
```
### Screenshots and other files
_<img class="op-uc-image op-uc-image_inline" src="/api/v3/attachments/105530/content">_
### Environment information
**OpenProject installation type**
* [x] Hosted cloud edition
* [ ] Packaged installation
* What distribution?
* [ ] Docker All-in-one container
* [ ] Docker-compose installation
* [ ] Other (please specify)
**OpenProject version**
_Checked on dev@a64e23d2f9480a73820bddc9954ee90bd20b2bfe_
1. There should be at least one date/timestamp field available to filter projects on (Created on, Last activity at, …)
2. Open any project query, for example the default one [http://localhost:3000/projects](http://localhost:3000/projects)
3. Add a filter by the date/timestamp field, operator will be `less than days ago` by default and specify `10000000` as value
4. Click on "Apply"
### What is the buggy behavior?
* Page with status 500 is shown
### What is the expected behavior?
* Error is on database level, so ensure date is in supported range
* Ignore the filter and
### **Logs**
```log
PG::DatetimeFieldOverflow: ERROR: timestamp out of range: "25356-11-13 23:59:59.999999 BC"
LINE 1: ...jects.active IN ('t')) AND (projects.created_at > '25356-11-...
```
### Screenshots and other files
_<img class="op-uc-image op-uc-image_inline" src="/api/v3/attachments/105530/content">_
### Environment information
**OpenProject installation type**
*
*
_Checked on dev@a64e23d2f9480a73820bddc9954ee90bd20b2bfe_