Feeling Lucky
?
[#13252] - Drop index idx_image in #__languages table
- Fixed in Code Base
- 18 Dec 2016
- Medium
- Build: staging
- # 13252
- Diff
- andrepereiradasilva:patch-19
- Success continuous-integration/drone the build was successful Details
- Success continuous-integration/travis-ci/pr The Travis CI build passed Details
- Success JTracker/HumanTestResults Human Test Results: 3 Successful 0 Failed. Details
User tests: Successful: Unsuccessful:
Pull Request for Issue #13122.
Summary of Changes
Drop index idx_image in #__languages table
This index is dropped because ordering by this field is only used very rarely in backend content languages view.
Testing Instructions
- Apply patch
- Install joomla clean install form staging
- Check if don't have a non unique idx_image index in
#__languagestable - Check the db schema checker now work fine.
Documentation Changes Required
None.
| Status | New | ⇒ | Pending |
joomla-cms-bot
- | Category | ⇒ | SQL Administration com_admin Postgresql MS SQL Installation |
| Title |
|
||||||
| Title |
|
||||||
alikon
- comment
- 18 Dec 2016
I have tested this item
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/13252.
ghazal
- comment
- 18 Dec 2016
I have tested this item
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/13252.
| Status | Pending | ⇒ | Ready to Commit |
infograf768
- comment
- 18 Dec 2016
RTC. Thanks.
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/13252.
zero-24
- | Milestone |
Added: |
||
rdeutz
- | Status | Ready to Commit | ⇒ | Fixed in Code Base |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2016-12-18 12:36:53 |
| Closed_By | ⇒ | rdeutz | |
| Labels |
Added:
?
?
|
||
cpfeifer
- 
twister65
- comment
- 27 Apr 2017
Update 3.7.0-2016-11-21.sql (e021f69) does not work with a postgreSQL database.
Perhaps, you could replace the SQL request by :
ALTER TABLE "#__languages" DROP CONSTRAINT "#__languages_idx_image";
I can't test it, because update with a zip file does not work.
I have tested this item✅ successfully on e021f69
OK here with mysql
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/13252.