Tag : sql

post image

Kodi retrieve missing (unparseable) files

This simple SQL query might save you some time if you need to get a list of files that Kodi 14.0 (former XBMC) cannot parse during a library update. The resulting list can then be used to fix/add the metadata for these files as described on http://kodi.wiki/view/Incorrect_and_missing_videos.

SELECT *
FROM `files` f
INNER JOIN `path` p ON f.idPath = p.idPath
WHERE f.dateAdded IS NULL
	AND p.strPath LIKE "nfs://%"  # value to be replaced by the protocol/path used
	AND LENGTH(f.strFileName) > 0

More information about Kodi’s database structure can be found on http://kodi.wiki/view/Databases.