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

Command icon 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

Anybody created an issue. See original summary.

anybody’s picture

anybody’s picture

Strange, but indeed the further nested select solves it ...

  • Anybody committed a1deaa3 on 1.0.x
    Issue #3280374: General error: 1093 You can't specify target table for...
anybody’s picture

Status: Active » Fixed

Adding a follow-up for tests...

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.