I have some entries in MySQL where the file no longer exists. I used the clean database feature in Kodi, and the entries are still there.
I can select the file using
SELECT * FROM files RIGHT JOIN path ON path.idPath = files.idPath WHERE files.idPath = 372
I know I can use a select to delete table rows, but I'm getting an error.
When I run this in MyPHPAdmin, I see
Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.
I did a quick Google on the error message, and people are talking about a missing index, but both tables have a primary key. Plus I don't want to change table scheme. Any suggestions?