Reply to thread

Message

<blockquote data-quote="JimCatMP" data-source="post: 1306768" data-attributes="member: 103549">Given ID.tvdb doesn't work for me, thought I'd do the harder way - direct sql.So&nbsp; [using SQLITE3 installed on seperate host - just copied DB over, edited, saved and copied back to actual media server].update local_series set ID=427281 where ID=-588; #Series is FUBAR, TVDB_ID is 427281 and -588 is the ID it was given on import.update season set SeriesID=427281 where SeriesID=-588; # 2 seasons installed, both season entries updated in one query.update season set ID=427281_s1 where ID=-588_s1;# Update the index ID, one query per season.update season set ID=427281_s2 where ID=-588_s2;#Fix up the LOCAL file info.update local_episodes set SeriesID=427281, OriginalComposite=&quot;427281_1x1&quot;,CompositeID=&quot;427281_1x1&quot; where CompsiteID=&quot;-588_1x1&quot;; # Repeat this 8 times [8 episodes per series] as 1x2, 1x3 ...........update local_episodes set SeriesID=427281, OriginalComposite=&quot;427281_2x1&quot;,CompositeID=&quot;427281_2x1&quot; where CompsiteID=&quot;-588_2x1&quot;;# As above but now it's for Season 2, so 2x2, 2x3.........#Fix up the ONLINE file info.online_episodes set SeriesID=427281 ,CompositeID=&quot;427281_1x1&quot; where CompositeID=&quot;-588_1x1&quot;; #As above for Seasons 1 &amp; 2.Open Conf, do an import [for all the missing online cont] and it's now all looking good.NOTE - this only works for FAILED import where some suitable data exists in the table.Possibly, that may help someone:-?TTFN _ J.</blockquote>

[QUOTE="JimCatMP, post: 1306768, member: 103549"] Given ID.tvdb doesn't work for me, thought I'd do the harder way - direct sql. So [using SQLITE3 installed on seperate host - just copied DB over, edited, saved and copied back to actual media server]. update local_series set ID=427281 where ID=-588; #Series is [B]FUBAR[/B], TVDB_ID is [B]427281[/B] and [B]-588[/B] is the ID it was given on import. update season set SeriesID=427281 where SeriesID=-588; # 2 seasons installed, both season entries updated in one query. update season set ID=427281_s1 where ID=-588_s1;# Update the index ID, one query per season. update season set ID=427281_s2 where ID=-588_s2; #Fix up the LOCAL file info. update local_episodes set SeriesID=427281, OriginalComposite="427281_1x1",CompositeID="427281_1x1" where CompsiteID="-588_1x1"; # Repeat this 8 times [8 episodes per series] as [B]1x2[/B], 1x3 ........... update local_episodes set SeriesID=427281, OriginalComposite="427281_2x1",CompositeID="427281_2x1" where CompsiteID="-588_2x1";# As above but now it's for Season 2, so [B]2x2[/B], 2x3......... #Fix up the ONLINE file info. online_episodes set SeriesID=427281 ,CompositeID="427281_1x1" where CompositeID="-588_1x1"; #As above for Seasons 1 & 2. Open Conf, do an import [for all the missing online cont] and it's now all looking good. NOTE - this only works for FAILED import where some suitable data exists in the table. Possibly, that may help someone:-? TTFN _ J. [/QUOTE]

Verification