Description
After running a DELETE query an error of the following kind is reported:
SQLSTATE[HY000]: General error
…but it seems the delete runs fine.
Steps to reproduce
I am Executing the following pattern:
DELETE FROM craft_elements
WHERE `type` = 'craft\\elements\\User'
AND `id` NOT IN (n,m … z)
…where n through z is a comma separated list of user IDs to retain.
Additional info
- Craft version: 3.6.4.1
- PHP version: 7.3.1
- Database driver & version: MySQL 5.7.25