+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Discussions (https://forum.kodi.tv/forumdisplay.php?fid=222)
+--- Forum: Wiki (https://forum.kodi.tv/forumdisplay.php?fid=262)
+--- Thread: Solved [Wiki change] Update video library SQL (/showthread.php?tid=171083)
[Wiki change] Update video library SQL - evanpurkhiser - 2013-08-12
Hey guys,
I wanted to add something to this wiki page, but since the accounts were lost I need to wait for my account to be activated.
Since I didn't want to forget the change that I wanted to make I figured I would post here, and someone else with wiki access could do it, or I would find this thread later and do it.
Under "Updating your video library" there should be one extra SQL line as this:
Code:
UPDATE tvshow SET c16 = REPLACE(c16,'smb://my_nas/old_share', 'smb://my_nas/new_share');(This fixes an issue where TV shows listed in the "Files" on XBMC will properly show their meta-data instead of just looking like folders)
Edit: Done!