Epic #90050: Translation wizard improvements and issues
Translation as non-admin user fails after first translation-wizard process
When a non-admin user tries to translate records from the original language to another language via translate-button, the first time it works.
After the first time, when the translate-button is used, the Translation-Wizard gets stuck at step 2 (getting the original-language).
This Problem has been introduced in TYPO3 9.5.10.
Information about the installation:
Default-Language is german. 1. Language french, 2nd language english, 3rd language italian.
Steps to reproduce:
- Create page
- Create translation to page (for example french)
- Create content elements
- Use Translation-Button (Wizard)
- In step 2, use default language as original language
- Finish wizard
- Create new content element
- Use Translation-Button (Wizard) again
- Rotating-Icon at Step 2 gets stuck.
Inspecting via developer Tools you get a error 500 page with following Message:
An exception occurred while executing 'SELECT `tt_content_orig`.`sys_language_uid` FROM `tt_content` INNER JOIN `tt_content` `tt_content_orig` ON `tt_content`.`l10n_source` = `tt_content_orig`.`uid` WHERE (`tt_content`.`pid` = ?) AND (`tt_content`.`sys_language_uid` = ?) AND (`sys_language_uid` IN (?, ?, ?, ?, ?)) AND (((`tt_content`.`deleted` = 0) AND (`tt_content_orig`.`deleted` = 0)) AND (((`tt_content`.`t3ver_wsid` = 0) OR (`tt_content`.`t3ver_state` <= 0)) AND ((`tt_content_orig`.`t3ver_wsid` = 0) OR (`tt_content_orig`.`t3ver_state` <= 0)))) GROUP BY `tt_content_orig`.`sys_language_uid`' with params [770, 1, -1, 0, 1, 2, 3]: Column 'sys_language_uid' in where clause is ambiguous
Upon inspecting i saw the error happens in https://github.com/TYPO3/TYPO3.CMS/blob/9.5/typo3/sysext/backend/Classes/Domain/Repository/Localization/LocalizationRepository.php , in the method "fetchOriginLanguage"
When reverting to TYPO3 9.5.9, or changing the Changes from aa20c0f and f66df41 back to ef62fac (or at least part of it), it works again.
I hope this helps, please correct me if i created the issue wrong and/or you need additional information, this is my first issue.