[mythtv-users] mythvideo file ordering weirdness

George Nassas gnassas at mac.com
Mon Apr 23 15:17:50 UTC 2007


On 23-Apr-07, at 5:36 AM, Nick Rout wrote:

> a directory listing of season 2 of SG-1 looks (in part) like this:
>
> Stargate SG-1 [2x01] The Serpent's Lair.avi
> Stargate SG-1 [2x02] In the Line of Duty.avi
>
> However when listed in mythvideo the bits inside the [ ] are omitted,
>
> Stargate SG-1 In the Line of Duty
> Stargate SG-1 The Serpent's Lair
>
> This annoying me and it only seems to have started today, although it
> *could* be related to the switch to 0.20.

It's definitely due to the 0.20 switch, the code that converts  
filenames to titles changed for .20 and the new approach drops  
anything between [] characters. A few people have complained but it  
remains as is. If you're willing to pop into sql you have it your way  
with a command like:

update videometadata
set title = substring_index(substring_index(filename, '/', -1), '.', 1)
where title like 'Stargate SG-1%';

- George



More information about the mythtv-users mailing list