Bug #89486

Epic #90050: Translation wizard improvements and issues

Translation as non-admin user fails after first translation-wizard process

Added by Michael Besek over 1 year ago. Updated over 1 year ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Localization
Target version:
-
Start date:
2019-10-23
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
9
PHP Version:
7.2
Tags:
Complexity:
Is Regression:
Yes
Sprint Focus:

Description

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:

(1/2) Doctrine\DBAL\Exception\NonUniqueFieldNameException

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.


Related issues

Related to TYPO3 Core - Bug #89442: [BREAKING] Error "Column 'sys_language_uid' in where clause is ambiguous" when trying to translate CEs as non-admin userClosed2019-10-17

Actions
#1

Updated by Tymoteusz Motylewski over 1 year ago

  • Parent task set to #90050
#2

Updated by Riccardo De Contardi over 1 year ago

I've not understood how to reproduce this issue. Could you add a more detailed step-by-step example? Thank you!

#3

Updated by Christian Eßl over 1 year ago

This has already been fixed in: https://forge.typo3.org/issues/89442

#4

Updated by Christian Eßl over 1 year ago

  • Related to Bug #89442: [BREAKING] Error "Column 'sys_language_uid' in where clause is ambiguous" when trying to translate CEs as non-admin user added
#5

Updated by Riccardo De Contardi over 1 year ago

  • Status changed from New to Closed

@Christian Eßl thank you for your finding, I am closing this issue as solved

If you think that this is the wrong decision or experience the issue again please reopen it or ping me. Thanks.

Also available in: Atom PDF