Cannot put two content languages with "No image"

[andrepereiradasilva]

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

[brianteeman]

I can confirm this

---

_{This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/12907.}

[brianteeman]

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.}

[mbabker]

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

[brianteeman]

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.

[andrepereiradasilva]

Imho It can still check for the same image except when no image.

[andrepereiradasilva]

please test #12949