Feeling Lucky
?
[#16372] - Invalid datetime default values
- Closed
- 30 May 2017
- Medium
- Build: staging
- # 16372
Related to
# 11530
In Joomla! We use 0000-00-00 00:00:00 as a default value for datetime to determine that's it's not set. This is actually invalid since it's an invalid date.
In MySQL 5.7, this causes MySQL issues since NO_ZERO is enabled by default. I would suggest we either use 1970-01-01 08:00 which is unix 0. Or we convert to NULL.
Thoughts?
joomla-cms-bot
- | Labels |
Added:
?
|
||
tonypartridge
- comment
- 30 May 2017
That's a good thought! ;) I'll do a few search types
franz-wohlkoenig
- | Status | New | ⇒ | Discussion |
| Category | ⇒ | Administration |
| Category | Administration | ⇒ | Administration Components Installation Libraries SQL |
| Status | Discussion | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2017-05-30 18:34:09 |
| Closed_By | ⇒ | Bakual |
| Status | Closed | ⇒ | Discussion |
| Rel_Number | 0 | ⇒ | 1530 |
| Relation Type | ⇒ | Related to |
Bakual
- comment
- 30 May 2017
Closing as there is a PR.
| Rel_Number | 1530 | ⇒ | 11530 |
| Status | Discussion | ⇒ | Closed |
| Closed_Date | 2017-05-30 18:34:09 | ⇒ | 2017-05-30 18:35:11 |
| Closed_By | Bakual | ⇒ | tonypartridge |
There's a PR open somewhere.
On Tue, May 30, 2017 at 8:23 PM Tony Partridge notifications@github.com
wrote:
--