[mythtv] MySQL problem

[Matt Zimmerman]

On Sun, Jan 26, 2003 at 04:13:21PM -0500, Jason Ramey wrote:

> DB Error: Program insertion failed, SQL query was:
> INSERT INTO program
> (chanid,starttime,endtime,title,subtitle,description,category)
> VALUES(1010, Mon Jan 27 00:00:00 2003, Mon Jan 27 01:00:00 2003, "The
> Outer
>  Limits", "Music of the Spheres", "Interstellar transmissions mutate
> pubescents.", "");
> 
> The DB Errors and everything below there repeats many times, I believe
> once for each program entry for the day. I am running Debian testing
> with mysql-server, mysql-common, and mysql-client. I made sure to set
> the root password for mysql with mysqladmin. I ran "mysql -uroot -p <
> mc.sql" after that. This is a fresh debian and mythtv install. Is there
> a step I'm missing? Thanks.

Update to current CVS and try again; I added more verbose error reporting to
that code.  That will explain what the exact error is.

-- 
 - mdz