[mythtv-users] TVWish Updates

[Brad Templeton]

On Fri, Mar 11, 2005 at 11:01:15PM -0500, Scott Minneman wrote:
> Brad:
> 
> This all looks wonderful, but I'm having a problem getting it to run.  
> All of the test runs work fine, but when I sh personal/runwish, it 
> doesn't set anything to run, and gives me the following error for every 
> movie:
> 
> DBD::mysql::st execute failed: 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 ' , , ,   )' at line 8 at tvwish line 785.
> DBD::mysql::st fetchrow_hashref failed: 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 ' , , ,   )' at line 8 at tvwish line 579.
> 
> In case it helps, running  mysql --version reports:
> 
> mysql  Ver 12.22 Distrib 4.0.22, for pc-linux-gnu (i686)
> 
> Any ideas?
> 
> -Scott

Apparently a problem with perl DBI and mysql4 when it comes to booleans.
I have made sure they are expressed as 0 or 1 and that appears to fix it.
The tar file is updated.