[cj3322]

I have a couple movies "Four Christmases" and Harry Potter Chamber of Secrets. Kodi is not picking them up after scrapping. I do a force update library and says Movie not found. I deleted all the .nfo files in my movie folders, the only thing in each movie file is just the movie itself. 
The only thing every movie has in common is they are all 480p movies. I don't think that should matter. 
I've tried the universal movie scrapper and the Python scrapper. 
I debugged and got this code 
Full log is here juhafopafe.kodi (paste)

debug <CAddonSettings[0@metadata.universal]>: trying to load setting definitions from old format... 2024-12-02 07:44:36.792 T:6168 warning <CAddonSettings[0@metadata.universal]>: cannot reference separator setting in old setting condition "eq(-2,1)" for "tmdbtitlelanguage" 2024-12-02 07:44:36.792 T:6168 warning <CAddonSettings[0@metadata.universal]>: failed to parse visible condition "eq(-2,1)" of old setting definition for "tmdbtitlelanguage"

I don't know what that means. Any suggestions?

[Karellen]

I have a couple movies "Four Christmases" and Harry Potter Chamber of Secrets.

Your log is overwhelmed with errors.
1. You have no audio drivers installed.

2. The scraper settings for Universal seem corrupted, somehow.
Can you go to C:\Users\Adminstrator\AppData\Roaming\Kodi\userdata\addon_data\, find the Universal Movie Scraper folder and delete it.
When you start Kodi again, go to your scraper settings and redo them, if you changed them from the default.
Then go to each source that uses that scraper, change to a different scraper, and then change back to Universal, and the corrected settings will be loaded for the Source.

3. Now for your scraping problem.
I checked Four Christmases, and MySQL is rejecting the transaction. You can see this on Lines 3936-3940. The error being...
SQL: [kodi_video131] Undefined MySQL error: Code (1062) Query: INSERT INTO videoversion (idFile, idMedia, media_type, itemType, idType) VALUES(12638, 4404, 'movie', 0, 40400)
Seems there is some corruption in your database with an attempt to add a duplicate entry.
I don't know of any fix for that as it is not meant to happen. How big is your movie and tv show library?

[Karellen]

One other thing you can try is to change the folder or filename for the movie, so Kodi sees it as a new movie.
Try renaming it Four Christmases (2008)/Four Christmases (2008).mkv and scraping again.

[cj3322]

I have about 700 plus movies and only about 640 are scrapping. I had a massive hard drive failure improper shutdowns, I upgraded to win11, etc , so that's probably where the corruption came from.

The system is a headless system, it just streams to a bunch of fire TV boxes. So I never bothered with audio drivers.

I'm gonna do what you recommended with the scrapper, try to fix it, but it kinda sounds like might be easier to wipe mysql and let Kodi rebuild it.
That's my weekend project I'll let you know the results.

[Karellen]

but it kinda sounds like might be easier to wipe mysql and let Kodi rebuild it.

Yea, I think that would be better. Who knows what other "junk" entries might be in there.

[scott967]

From the look of things it seems like the file must have been added to the files table and that's where it got the idFile of 12638, but some how the videoversion table already had a row with that idFile.  Agree that that suggests some corruption unless there's a bug in movie version code, but I think we would have seen that by now.

scott s.
.