doctrine/archived-orm
1
0
Fork 0
mirror of https://github.com/doctrine/orm.git synced 2026-03-23 22:42:18 +01:00
Code Issues 5.3k Packages Projects Releases 100 Wiki Activity

[PR #9370] Fix "Illegal mix of collations" in MultiTableDeleteExecutor #11567

New Issue
Open
opened 2026-01-22 16:11:10 +01:00 by admin · 0 comments
admin commented 2026-01-22 16:11:10 +01:00
Owner
Copy Link

Original Pull Request: https://github.com/doctrine/orm/pull/9370

State: closed
Merged: No

When database tables use a collation that's not the default database one, MultiTableDeleteExecutor fails with this error:

In AbstractMySQLDriver.php line 128:
                                                                                                                                                    
  [Doctrine\DBAL\Exception\DriverException]                                                                                                         
  An exception occurred while executing 'DELETE FROM MessengerTaskProcesses WHERE (id) IN (SELECT id FROM MessengerProcesses_id_tmp)':              
                                                                                                                                                    
  SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='

This issue should be fixed by using the configured charset/collation.

**Original Pull Request:** https://github.com/doctrine/orm/pull/9370 **State:** closed **Merged:** No --- When database tables use a collation that's not the default database one, MultiTableDeleteExecutor fails with this error: ``` In AbstractMySQLDriver.php line 128: [Doctrine\DBAL\Exception\DriverException] An exception occurred while executing 'DELETE FROM MessengerTaskProcesses WHERE (id) IN (SELECT id FROM MessengerProcesses_id_tmp)': SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '=' ``` This issue should be fixed by using the configured charset/collation.
admin added the pull-request label 2026-01-22 16:11:10 +01:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
BC Break
Bug
Can't Fix
Deprecation
Documentation
DQL
Duplicate
Failing Test
Hacktoberfest
Improvement
Improvement
Incomplete
Invalid
Missing Tests
New Feature
PR Created
pull-request
Mirrored from GitHub Pull Request
 Question
Regression
Status: Waiting feedback
Waiting feedback
WIP
Won't Fix
No Label pull-request
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
admin
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: doctrine/archived-orm#11567
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?