Kodi Community Forum
Solved [Wiki change] Update video library SQL - Printable Version

Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Discussions (https://forum.kodi.tv/forumdisplay.php?fid=222)
+--- Forum: Website and Forum Issues or Suggestions (https://forum.kodi.tv/forumdisplay.php?fid=35)
+---- 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:

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!

This forum uses Lukasz Tkacz MyBB addons.