Feeling Lucky
?
?
[#13513] - Normalize #__ucm_content table across 3 db systems and add default values
- Fixed in Code Base
- 10 Jan 2017
- Medium
- Build: staging
- # 13513
- Diff
- andrepereiradasilva:issue-13510
User tests: Successful: Unsuccessful:
Pull Request for Issue #13510 and probably other issues relating ucm_content table in more strict db systems (which in joomla 4.0 mysql will be also).
Summary of Changes
Normalize the #__ucm_content table across db systems.
Only tested in mysql.
@waader please check mssql
@alikon please also check postgresql and mssql.
Testing Instructions
- SQL code review
- Test update: Apply patch, manually run the sql query for your Db system, confirm db table, confirm all fine
- Test install: apply patch, delete configuration.php do a normal install, confirm db table, confirm all fine
Documentation Changes Required
None.
| Status | New | ⇒ | Pending |
joomla-cms-bot
- | Category | ⇒ | SQL Administration com_admin Postgresql MS SQL Installation |
| Labels |
Added:
?
|
||
andrepereiradasilva
- comment
- 8 Jan 2017
"text" removed - copy paste error . sorry
waader
- comment
- 8 Jan 2017
I have tested this item
Works with mssql and postgres.
Thanks!
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/13513.
alikon
- comment
- 9 Jan 2017
I have tested this item
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/13513.
zero-24
- | Milestone |
Added: |
||
| Status | Pending | ⇒ | Ready to Commit |
| Labels |
Added:
?
|
||
rdeutz
- | Status | Ready to Commit | ⇒ | Fixed in Code Base |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2017-01-10 13:58:41 |
| Closed_By | ⇒ | rdeutz | |
| Labels | |||
Works for mssql and postgres apart from the update file for postgres. I deleted "TEXT" in the following lines and then it worked:
ALTER TABLE "#__ucm_content" ALTER COLUMN "core_body" SET DEFAULT '';
ALTER TABLE "#__ucm_content" ALTER COLUMN "core_params" SET DEFAULT '';
ALTER TABLE "#__ucm_content" ALTER COLUMN "core_metadata" SET DEFAULT '';
ALTER TABLE "#__ucm_content" ALTER COLUMN "core_images" SET DEFAULT '';
ALTER TABLE "#__ucm_content" ALTER COLUMN "core_urls" SET DEFAULT '';
ALTER TABLE "#__ucm_content" ALTER COLUMN "core_metakey" SET DEFAULT '';
ALTER TABLE "#__ucm_content" ALTER COLUMN "core_metadesc" SET DEFAULT '';