Mythexport file URLs missing part of the file extension

Bug #1010080 reported by Thomas Pontoppidan
12
This bug affects 2 people
Affects Status Importance Assigned to Milestone
mythexport (Ubuntu)
In Progress
Undecided
rhpot1991

Bug Description

MythExport creates files with .m4v extension. When the filenane is long it is truncated to 63 chars + the extension.

However, the links are truncated to 63 characters including extension.

I have experimentally changed the daemon script (line 424) from
    my $x = 63 - $extension;
to
    my $x = 61 - $extension;
which seems to solve the issue.

 mythexport-daemon v2.2.3

rhpot1991 (rhpot1991)
Changed in mythexport (Ubuntu):
status: New → Incomplete
Revision history for this message
rhpot1991 (rhpot1991) wrote :

I haven't been able to reproduce this. Are you using the default configs or a custom one?

Is there any chance you can post the results of this query:
SELECT rec.title, rec.subtitle, rec.description, pg.syndicatedepisodenumber, pg.showtype, rec.programid, rec.basename, rec.starttime
    FROM recorded rec LEFT JOIN program pg ON pg.starttime = rec.starttime AND pg.chanid = rec.chanid
    WHERE rec.chanid=? AND rec.starttime=?"

You'll need to figure out the chanid and starttime for that specific recording. You can also enable debugging and the query will be in your log then, copy it and execute.

Revision history for this message
rhpot1991 (rhpot1991) wrote :

Scratch that, I see now that the issue is in the name stored in the db and displayed on the web interface.

Changed in mythexport (Ubuntu):
assignee: nobody → rhpot1991 (rhpot1991)
status: Incomplete → Confirmed
Revision history for this message
Thomas Pontoppidan (spam1-pontoppidan) wrote :

This is the result of the query for one recording. Sorry if the format is not right - I'm not good at consoles so it's an export from myphpadmin:

"Rejseholdet (3:32)","Dansk dramaserie fra 2000.","Serie Dansk dramaserie fra 2000. Det lykkes Fischer og la Cour at få fat fat i rockerlederen Grue, som kører rundt med et oversavet jagtgevær, der svarer til mordvåbnet - men den afsløring, der følger er ikke, hvad de har ventet. Ingrid vender tilbage og har en plan, som hverken passer Ulf eller den lokale politimester. Fischer får uventet hjælp, da han kommer i voldsomt klammeri med et par mistænkte, og la Cour finder et afgørende spor. IP lider jalousiens kvaler, mens noget er undervejs mellem Gaby og Johnny Olsen. Medvirkende: Ingrid Dahl: Charlotte Fich. IP: Waage Sandø. La Cour: Lars Brygmann. Fischer: Mads Mikkelsen. Gaby: Trine Pallesen. Ulf Thomsen: Erik Wedersøe. Johnny Olsen: Lars Bom. Endvidere medvirker: Mikkel Vadsholt, Sarah Boberg, Timm Vladimir, Claus Bue, Niels Olsen, Lisbet Lundquist, Sebastian V. Ottensten, Claus Nissen m.fl. Manuskript: Iben Gylling og Peter Thorsboe. Instruktion: Niels Arden Oplev. Foto: Lars Vestergaard, dff. Scenografi: Kirsten Koch..... Features: TTV, S, (G), 16:9",NULL,NULL,,"1001_20120603195800.mpg","2012-06-03 19:58:00"

I had the same behaviour for all recordings - all had the ".m" extension in the XML podcast as well as in all other links in the web interface. The only actual example of the bad references I have left is this from another recording (I deleted the useless files):

<enclosure length="" url="http://*host-IP*/mythexport/video/TV-2-Desperate_Housewives_86_-Amerikansk_dramaserie_-2012060412.m" type="video/mpeg" />

My count was incorrect - the filename is 63 + 2 for the extension, but after the change I get valid file references - not sure if it breaks something else, though...

Revision history for this message
rhpot1991 (rhpot1991) wrote :

Try changing
   my $x = 63 - $extension;

to:
   my $x = 63 - length($extension);

Revision history for this message
Thomas Pontoppidan (spam1-pontoppidan) wrote :

Yes - looks fine!

Revision history for this message
danstowell (danstowell) wrote :

Just to comment that I had this issue (MP3 export job gave me an ".mp3" but the RSS feed was linking to ".m") and the change in comment #4 fixes it for me too - thanks

rhpot1991 (rhpot1991)
Changed in mythexport (Ubuntu):
status: Confirmed → In Progress
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.