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.
_______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
