Parentheses in file path breaks Video module of Mythweb

[anonymous]

Using brackets (i.e. '(' or ')') in file or directory names for video files breaks mythweb's video component. I am using the SVN 14091. I am also using the MySQL driver for mythweb.

For example, I have a directory of episodes of 'The Office (US)'. The path of the directories are:

/myth/video/The Office (US)/Season 1
/myth/video/The Office (US)/Season 2
/myth/video/The Office (US)/Season 3

When I click on 'Season 1' under 'Directory Structure' in mythweb, I get no video listings. The query being generated by modules/video/handler.php is:

SELECT videometadata.intid 
FROM videometadata 
LEFT JOIN videometadatagenre 
ON videometadata.intid = videometadatagenre.idvideo
WHERE  videometadata.filename RLIKE 
'/myth/video/The Office (US)/Season 1/[/]*[^/]*$' 
GROUP BY intid ORDER BY title;

This query fails due to the "(" and ")" characters. The query works if these characters are properly escaped (i.e "
(" instead of "(").

The correct query would be:

SELECT videometadata.intid 
FROM videometadata 
LEFT JOIN videometadatagenre 
ON videometadata.intid = videometadatagenre.idvideo
WHERE  videometadata.filename RLIKE 
'/myth/video/The Office \\(US\\)/Season 1/[/]*[^/]*$' 
GROUP BY intid ORDER BY title;

See attached patch for an example fix.

-- Joe Ripley vitaminjoe@…

[vitaminjoe@…]

Example patch to fix mythweb video module handler.php

[Joe Ripley <vitaminjoe@…>]

Proper patch generated by 'svn diff'

[Joe Ripley <vitaminjoe@…>]

This issue was fixed in [14537], was it not?

[Rob Smith]

Yes, it was