2019-10-12, 13:08
(2019-08-28, 05:36)OtheA Wrote:Having exact same issue at the moment. Can you explain exact steps you took to fix this? Cheers in advance.(2019-08-27, 21:35)BigMong Wrote:(2019-08-25, 22:03)OtheA Wrote: 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"
then try a cleanup again.sql:GRANT ALL PRIVILEGES ON `Kodi\_U01\_Video\_116`.* TO 'KODI_18'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
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.
just to confirm the table is workingsql:USE `Kodi_U01_Video_116`;
DELETE FROM files WHERE idFile IN (334);
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.