Strapi SQL query error when trying to delete multiple entries from the collection types

Questions and Answers Database-SQL
1
System Information
  • Strapi Version: 4.4.1
  • Operating System: macOS
  • Database: mySQL
  • Node Version: 18.17.1
  • NPM Version: 9.6.7
  • Yarn Version:

I want to delete multiple entries from a collection type called fragments, but when I try to select and delete multiple entries of fragments from the strapi admin dashboard the dashboard shows an error: “An error occurred while record deletion”

image
image2662×226 22.9 KB

On checking server logs, I got the underlying sql error for this issue:

error: delete `fragments` from `fragments` left join `admin_users` as `t1` on `t0`.`created_by_id` = `t1`.`id` where ((`id` in (4022) and (((((`t1`.`id` = 34)) and `locale` in ('en'))) or ((`locale` in ('en')))))) - ER_NON_UNIQ_ERROR: Column 'id' in where clause is ambiguous
2024-05-09T10:25:42: Error: ER_NON_UNIQ_ERROR: Column 'id' in where clause is ambiguous

can someone please tell me a fix to this issue?

Thanks in advance!

2

Is it just me who has encountered such a problem? Seems like it’d take quite some time for me to find out what part of code needs fixes!