Problem/Motivation
Clicking "Clear translations of all listed equal translations" on the equal translation remover leads to:
SQLSTATE[HY000]: General error: 1093 You can't specify target table 'locales_target' for update in FROM clause: DELETE FROM "locales_target" WHERE (lid IN (SELECT ls.lid FROM "locales_source" ls INNER JOIN "locales_target" lt WHERE ls.lid=lt.lid AND CONVERT(ls.source USING utf8) = CONVERT(lt.translation USING utf8) AND lt.customized = :onlyCustomized)); Array ( [:onlyCustomized] => 1 )
Datenbank
Version
5.7.38-1
System
MySQL, Percona Server, or equivalent
Steps to reproduce
See above
Proposed resolution
Remaining tasks
User interface changes
API changes
Data model changes
Issue fork l10n_tools-3280374
Show commands
Start within a Git clone of the project using the version control instructions.
Or, if you do not have SSH keys set up on git.drupalcode.org:
Comments
Comment #2
anybodyPerhaps this workaround helps:
https://stackoverflow.com/questions/5816840/delete-i-cant-specify-target...
Comment #3
anybodyStrange, but indeed the further nested select solves it ...
Comment #6
anybodyAdding a follow-up for tests...