[#21582] - Joomla 4.0 installation fails on mysql 5.5
- Closed
- 14 Aug 2018
- Medium
- Build: staging
- # 21582
Steps to reproduce the issue
Run DB installation script https://github.com/joomla/joomla-cms/blob/4.0-dev/installation/sql/mysql/joomla.sql on mysql 5.5
Actual result
Mysql fails with: ERROR 1067 (42000) at line 1943: Invalid default value for 'created'
System information (as much as possible)
Mysql version 5.5.59
Additional comments
Mysql 5.5 doesn't accept default value NOW() for datetime columns.
Like https://github.com/joomla/joomla-cms/blob/4.0-dev/installation/sql/mysql/joomla.sql#L1951
On mysql 5.7 it works correctly.
joomla-cms-bot
- | Labels |
Added:
?
|
||
| Labels |
Added:
?
|
||
franz-wohlkoenig
- | Status | New | ⇒ | Discussion |
| Category | ⇒ | com_installer com_workflow SQL |
or simply use the normal default DEFAULT '0000-00-00 00:00:00',
Mysql 5.5 is EOL on release of J4 but I'm note sure if the minimum version is pumped to 5.6.
yes i'll do when the state/stage will end
It may be EOL but the technical requirements are
https://docs.joomla.org/Potential_backward_compatibility_issues_in_Joomla_4
thx for the link
Mainly because over 50% of our user base still use MySQL 5.5 https://developer.joomla.org/stats/
From what time frame are those statistics? From the start of gathering or perhaps from the last year?
The API endpoint is all time. It is still 50% for data updated in the last 90 days.
| Labels |
Added:
J4 Issue
|
||
Closing as we have the PR for testing
| Status | Discussion | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2018-08-14 08:26:19 |
| Closed_By | ⇒ | wilsonge |
| Labels |
Added:
?
Removed: J4 Issue ? |
||
A possible fix is to change the column type to timestamp not datetime and adding a trigger