Just confirmed this a bug by installing a fresh Joomla 3.4.1 (with default content), FLEXIcontent v3.0.0 Beta6b and latest Falang version.
After this, I installed an additional language and activated the following in FC configuration:
- Activate Falang support (for items) YES
- Edit Falang Translations YES
Then, I edited the only default item installed by Joomla.
If I change the item language from ALL to another language (let's call it B with the default language being A) and then back to ALL, there is no problem whatsoever.
But, when the item is set to language ALL, if I fill the item description with some content in both language A and language B and then change the item language to either A or B, two mistakes happen:
- The description of the new item language ( A or B ) becomes overriden with the description of language ALL
- The legend of the tab of the language ALL becomes empty
The legend becoming empty happens because the language ALL record is not being deleted from Falang database table as it should, which also causes the next error.
So now, if we change the language of the item back from A or B to language ALL, the following SQL is thrown:
Code:
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND reference_table='content' AND reference_id=1' at line 1 SQL=DELETE FROM joomla_falang_content WHERE language_id= AND reference_table='content' AND reference_id=1
Hope the explanation was clear enough, but please ask should you have any questions.