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

[Noel Leistad - MythTV]

Ben Lancaster wrote:
> Hi all,
>
> I'm running latest atrpms-bleeding packages for MythTV on FC6, with  
> MySQL 5.0.16
>
> When attempting to burn DVDs with MythArchive, I'm encountering a  
> couple of errors. It looks to me like there's TWO problems here;  
> one's a problem with my system, the other is a bug:
>
> **ERROR: [mpeg2enc] mpeg2enc is currently broken.  If you really want  
> to use it delete this line and recompile
> ************************************************************
> ERROR: Failed while running jpeg2yuv - jpeg2yuv -n 375 -v0 -I p -f 25  
> -j '/usr/share/mythtv/mytharchive_tmp/work/background-1.jpg' |  
> mpeg2enc -b 5000 -a 3 -v 1 -f 8 -o '/usr/share/mythtv/mytharchive_tmp/ 
> work/temp.m2v'
> ************************************************************
>
> ------------------------------------------------------------
> Traceback (most recent call last):
>    File "/usr/share/mythtv/mytharchive/scripts/mythburn.py", line  
> 4037, in ?
>      processJob(job)
>    File "/usr/share/mythtv/mytharchive/scripts/mythburn.py", line  
> 3804, in processJob
>      createMenu(format, dpi, files.length)
>    File "/usr/share/mythtv/mytharchive/scripts/mythburn.py", line  
> 2839, in createMenu
>      aspect_ratio)
>    File "/usr/share/mythtv/mytharchive/scripts/mythburn.py", line  
> 339, in encodeMenu
>      fatalError("Failed while running jpeg2yuv - %s" % command)
>    File "/usr/share/mythtv/mytharchive/scripts/mythburn.py", line  
> 171, in fatalError
>      saveSetting("MythArchiveLastRunResult", "Failed: " + msg);
>    File "/usr/share/mythtv/mytharchive/scripts/mythburn.py", line  
> 638, in saveSetting
>      cursor.execute(query)
>    File "/usr/lib64/python2.4/site-packages/MySQLdb/cursors.py", line  
> 163, in execute
>      self.errorhandler(self, exc, value)
>    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...

Noel Leistad