[mythtv-users] SQL Error from MythArchive, or is it mpeg2enc, or both?

[Mr. Myth]

Noel Leistad - MythTV wrote:
>
>>    File "/usr/lib64/python2.4/site-packages/MySQLdb/connections.py",  
>> line 35, in defaulterrorhandler
>>      raise errorclass, errorvalue
>> ProgrammingError: (1064, "You have an error in your SQL syntax; check  
>> the manual that corresponds to your MySQL server version for the  
>> right syntax to use near 'jpg' | mpeg2enc -b 5000 -a 3 -v 1 -f 8 -o '/ 
>> usr/share/mythtv/mytharchive_tmp/wor' at line 1")
>>
>> So, from what I can see, it looks like mpeg2enc is b0rked somehow -  
>> which I'm hoping reinstalling it will have fixed (too early to tell  
>> atm), and also a problem with the query not being escaped properly  
>> prior to it being executed, does that sound right?
>>
>> Ben
>> _______________________________________________
>> mythtv-users mailing list
>> mythtv-users at mythtv.org
>> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>>
>>   
>>     
> Never got as far as second error on my system. Found item suggesting 
> rollback to mjpegtools-1.9.1-14_cvs20061009.fc6.at
>
> I'm using atrpms.net repo
>
> Worked for me. I DID try the re-install before finding above 
> recommendation. Ideal would be to notify Axel or check bugzilla...
>
>   

I too was having the same problem.  I rolled back to

mjpegtools-1.9.1-14_cvs20061009.fc6.at based on this suggestion.  I can now burn DVDs again.

Michael