Issue with load_data_from_po() with MySQL database

[kbultman]

OperationalError: (1093, "You can't specify target table 'translation_manager_translationentry' for update in FROM clause")

caused by: TranslationEntry.objects.filter(original__in=published.values_list('original', flat=True)).update(is_published=True)

MySQL doesn't allow updating the table you are already using in an inner select as the update criteria.
Fix is to wrap published values in list:
TranslationEntry.objects.filter(original__in=list(published.values_list('original', flat=True))).update(is_published=True)

[Krakenus]

@kbultman Hello, do you know which django or mysql version did this? I wasn't able to replicate the issue.