[#21796] - Widen table field of #__content_types (#21395)
- Closed
- 10 May 2021
- Medium
- Build: staging
- # 21796
- Diff
- webstackdev:staging
- Success Hound No violations found. Woof! Details
- Success continuous-integration/travis-ci/pr The Travis CI build passed Details
- Success continuous-integration/drone/pr the build was successful Details
- Failure continuous-integration/appveyor/pr AppVeyor build failed Details
User tests: Successful: Unsuccessful:
Widen default "table" field of "#__content_types" table in install scripts
Pull Request for Issue #21395 .
Summary of Changes
Changed width of "table" field in "#__content_types" table from VARCHAR(255) to VARCHAR(2048) for MySQL, PostgreSQL, and Azure install scripts. Provides room for parameters and longer values.
Testing Instructions
-
Follow instructions in Joomla! documentation to enable content history for a third-party component. For the "table" JSON key, use a wide vendor-prefixed value for the "dbtable" key of configuration for "special", e.g.:
"dbtable":"#__mylongvendorprefixname_mylongcustomcomponentname",
-
Apply this PR.
-
Install third-party component.
Expected result
No database errors
Actual result
No database errors
Documentation Changes Required
None.
| Status | New | ⇒ | Pending |
joomla-cms-bot
- | Category | ⇒ | SQL Installation Postgresql MS SQL |
You will need to create an update script as well.
They are located in the administrator\components\com_admin\sql\updates folder
and they should be new files with todays date
@calligraphic will you create an update script as @brianteeman comment above?
no decision no update script
@calligraphic If you still need this for staging please add update SQL like suggested in the comments above.
Clsoing this - no update after more than a year
| Status | Pending | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2021-05-10 17:30:48 |
| Closed_By | ⇒ | chmst | |
| Labels |
Added:
?
|
||
yuo should add the update sql too