[#12907] - Cannot put two content languages with "No image"
- Closed
- 20 Nov 2016
- Medium
- Build: master
- # 12907
Steps to reproduce the issue
Add two content languages with no image.
Expected result
Two content languages with no image.
Actual result
SQL Error
System information (as much as possible)
latest
Additional comments
there seems to be an unique index idx_image for image field in #__languages table
probably a missing part from #12051
joomla-cms-bot
- | Labels |
Added:
?
|
||
| Status | New | ⇒ | Confirmed |
Removing the unique index resolves it - does this even need an index?
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/12907.
https://github.com/joomla/joomla-cms/blob/staging/libraries/joomla/table/language.php#L71
The code requires a unique image per language. It's not just the table indexes. I never understood it but for whatever reason I got conned to adding it onto https://developer.joomla.org/joomlacode-archive/issue-27196.html
The argument for it being unique is to prevent a user being stupid and
having two or more languages with the same image. You can't fix stupid. If
you accidentally select the same image you will quickly see you've been
stupid and change it.
Imho It can still check for the same image except when no image.
| Category | ⇒ | com_languages |
| Status | Confirmed | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2016-11-20 20:42:48 |
| Closed_By | ⇒ | andrepereiradasilva |
I can confirm this
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/12907.