[#24595] - [SQL] fix field home of #__template_styles table
- Fixed in Code Base
- 16 Jun 2019
- Medium
- Build: staging
- # 24595
- Diff
- alikon:patch-113
- 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
- Success continuous-integration/appveyor/pr AppVeyor build succeeded Details
User tests: Successful: Unsuccessful:
Pull Request for Issue #23188.
Summary of Changes
respect docs & logic
https://docs.joomla.org/Tables/template_styles
| Status | New | ⇒ | Pending |
| Title |
|
||||||
| Title |
|
||||||
joomla-cms-bot
- | Category | ⇒ | SQL Administration com_admin Postgresql MS SQL Installation |
| Labels |
Added:
?
|
||
Maybe the following is an issue when using PatchTester.
Run the Database fix the first time:
Database schema version (3.9.3-2019-02-07) does not match CMS version (3.9.6-2019-04-15).
Table 'nu7mb_template_styles' should not have index 'idx_home'. (From file 3.9.6-2019-04-15.sql.)
Table 'nu7mb_template_styles' has the wrong type or attributes for column 'home' with type tinyint(1) unsigned. (From file 3.9.6-2019-04-15.sql.)
Then the result, but idx_home is not created.
Table 'nu7mb_template_styles' does not have index 'idx_home'. (From file 3.9.6-2019-04-15.sql.)
Run the Database fix again, then idx_home is created, however, this message remains:
Table 'nu7mb_template_styles' does not have index 'idx_home'. (From file 3.9.6-2019-04-15.sql.)
ummm maybe splitting the last "CREATE INDEX" in a new file .... i'll give it a try
I have tested this item
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/24595.
I have tested this item
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/24595.
@GarryMoveOut please test > https://docs.joomla.org/Testing_Joomla!_patches
Sorry for not responding for long time. I didn't have time. I will test soon, maybe this in week.
I have tested this item
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/24595.
| Status | Pending | ⇒ | Ready to Commit |
RTC
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/24595.
| Labels |
Added:
?
|
||
| Status | Ready to Commit | ⇒ | Fixed in Code Base |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2019-06-16 10:23:24 |
| Closed_By | ⇒ | HLeithner |
thx
@GarryMoveOut please test.