[#24058] - [3.9] Wrong default value [SQL ]
- Fixed in Code Base
- 7 Mar 2019
- Medium
- Build: staging
- # 24058
- Diff
- amitranjan2:sql
User tests: Successful: Unsuccessful:
Pull Request for Issue # .
Summary of Changes
`INT DEFAULT value changed to numeric from char
Testing Instructions
see the code
installation/sql/mysql/joomla.sql
installation/sql/postgresql/joomla.sql
Expected result
same as before
Actual result
same as before
Documentation Changes Required
NO
| Status | New | ⇒ | Pending |
joomla-cms-bot
- | Category | ⇒ | SQL Installation Postgresql |
| Labels |
Added:
?
|
||
There are more columns remaining that should be changed, e.g.
joomla-cms/installation/sql/mysql/joomla.sql
Line 1654 in 5200e18
There are more columns remaining that should be changed, e.g.
joomla-cms/installation/sql/mysql/joomla.sql
Line 1654 in 5200e18
language_client_idtinyint(3) NOT NULL DEFAULT '1',
done, thanks
you should check the update sql files as well
for example https://github.com/joomla/joomla-cms/blob/staging/administrator/components/com_admin/sql/updates/mysql/3.9.0-2018-05-02.sql#L8
| Category | SQL Installation Postgresql | ⇒ | SQL Administration com_admin Installation Postgresql |
please take a look at all sql updates files
another example https://github.com/joomla/joomla-cms/blob/staging/administrator/components/com_admin/sql/updates/mysql/3.9.0-2018-05-24.sql#L6
please take a look at all sql updates files
another example https://github.com/joomla/joomla-cms/blob/staging/administrator/components/com_admin/sql/updates/mysql/3.9.0-2018-05-24.sql#L6
Already done
yes, I have checked for mysql as well as PostgreSQL also, thanks
please tell me if any left
this one https://github.com/joomla/joomla-cms/blob/staging/administrator/components/com_admin/sql/updates/mysql/3.9.0-2018-08-12.sql for example
oops sorry , done
I have tested this item
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/24058.
| Title |
|
||||||
I have tested this item
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/24058.
| Status | Pending | ⇒ | Ready to Commit |
RTC
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/24058.
@amitranjan2 patience is a virtue
| Status | Ready to Commit | ⇒ | Fixed in Code Base |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2019-03-07 20:49:09 |
| Closed_By | ⇒ | HLeithner | |
| Labels |
Added:
?
|
||
thx
thanks
@alikon some days ago We solved this for joomla [4.0]
remembered?