[mythtv-users] mythburn.py fail

[Paul Harrison]

Barry Quiel wrote:
>> Barry Quiel wrote:
>>     
>> Its choking on the information from the DB for that file.
>>
>> Does the plot for that video contain any funny characters?
>>
>> Could you run this query in MySql and report the results.
>>
>> select title, director, plot, rating, inetref, year,
>>                         userrating, length, coverfile from videometadata
>>                         where filename= '/mythtv/videos/TV/Battlestar 
>> Galactica/S03/BSG-S03E01.mpeg';
>>
>> That should all be on one line.
>>
>> Paul H.
>>
>>
>> _______________________________________________
>> mythtv-users mailing list
>> mythtv-users at mythtv.org
>> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>>     
>
> It returned basically nothing.   The only data is there looks like the 
> absolute minimum for an entry in that table.  They were added to the 
> collection using "scan collection" from mythweb.
>
> |title|director|plot|rating|inetref|year|userrating|length|coverfile 
>
>
>
> |BSG-S03E01|     | NULL |        |       |    0 |    0 |   0|        |
>
> I trimmed the whitespace, non-printable characters won't copy and paste 
> anyway.
>
>
>
>   

It seems MythVideo and MythWeb disagree on what value should be inserted 
into the DB for a blank plot.

Anyway MythArchive can now cope with both methods.

You can either update to latest svn from trunk or the fixes branch or 
alternatively you could change the NULL values that MythWeb inserted for 
the plot field to 'None' or even an empty field just as long as it isn't 
NULL.

Paul H.