[mythtv-users] Upgraded to 0.15: MySQL error and transcoding problem

[Xavier Hervy]

Asciimonster wrote:
> Firstly, I recently upgraded to mythtv 0.15. But in mythfrontend there 
> are no recorded shows in the playlist, although there are plenty .nuv's 
> on the harddisk. This is a MySQL problem:
> 
> ~> mythfrontend
> 2004-05-31 10:36:51 mythfrontend version: 0.15.20040525-1 www.mythtv.org
> 2004-05-31 10:36:51 Enabled verbose msgs : important general
> DB Error (simpledbstorage update):
> Query was:
> INSERT INTO settings SET value = 'DisplayRecGroup', data = 'Alle 
> programma's', hostname = 'linux';
> Driver error was [2/1064]:
> QMYSQL3: Unable to execute query
> Database error was:
> 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 's', 
> hostname = 'linux'' at line 1
> 
> 2004-05-31 10:36:52 Registering Internal as a media playback plugin.
> 2004-05-31 10:36:54 Connecting to backend server: 127.0.0.1:6543 (try 1 
> of 5)
> 2004-05-31 10:36:54 Using protocol version 8
> 2004-05-31 10:36:54 Using protocol version 8
> Not removing top-most widget
> 
> 
> Secondly, it seems like transcoding is broken too... In the backend log 
> there are dozens of entries that read something like:
> [datetime stamp] Starting transcoding of ****.nuv
> [Same datetime stamp] Transcoding  of ****.nuv aborted because of 
> cutlist update
> 
> Does anybody know how to solve this?

I know what is the error, you have ' character in data fields (Alle
  programma's) then  mysql try data = 'Alle programma' and don't 
understand s'. You should make patch that replace "'" character by "\'"
xavier