[OtheA]

Wow I did have a typo haha Thank you I have updated it
This just removes bookmarks of deleted files no biggie just keeping things tidy.

That's fine if your only using 5 of the 9 or increased it to 20 or whatever.
you will just need to remove lines from the tiggers and not run the user setup of the other. can leave the other cols within the "global_files" table or drop them it wont change anything.

within the database "Kodi_U01_Video_116" do you have a view called "files", this must be a view and not a table. You should also have a table "global_files" but if your missing "files" run the following

sql:
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8mb4 */;



    CREATE ALGORITHM=MERGE DEFINER=`KODI_18`@`%` SQL SECURITY DEFINER VIEW `files`

    AS SELECT

      `global_files`.`idFile` AS `idFile`,

      `global_files`.`idPath` AS `idPath`,

      `global_files`.`strFilename` AS `strFilename`,

      `global_files`.`playCount_U01` AS `playCount`,

      `global_files`.`lastPlayed_U01` AS `lastPlayed`,

      `global_files`.`dateAdded` AS `dateAdded`

    FROM `global_files`;



/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

I have a view called "files" and a table called "global_files" in U01.  I did a search for one of my movies and it is indeed listed twice in the database.  I'll run the above query tonight and report back.  Thanks again!

Yup.  SQL responded with #1050 - Table 'files' already exists.   

Sorry for the delay,
Two other thoughts about this
check the permissions of the user "KODI_18"

sql:
GRANT ALL PRIVILEGES ON `Kodi\_U01\_Video\_116`.* TO 'KODI_18'@'%' WITH GRANT OPTION;

FLUSH PRIVILEGES;

then try a cleanup again.

and/or try and do the task manually for one of the id's if able log into the database as the KODI_18 user.

sql:
USE `Kodi_U01_Video_116`;

DELETE FROM files WHERE idFile IN (334);

just to confirm the table is working  

Thanks BigMong.  No need to apologize.  Still not working for me.  I ran the query from SQL and got the following:

#1146 - Table 'Kodi_U06_Video_116.bookmark' doesn't exist

Which is correct, because I didn't create anything past U05, so I expect this would be a normal error.

Okay, that fixed it.  I didn't realize I needed to remove the users I didn't create from the cleanup.  The query was halting at the first user that didn't exist so it couldn't complete.  I went back and removed the users I didn't configure and cleaned the library and that got rid of the extras.  Thanks again BigMong.  I appreciate you again.