[mythtv] MySQL problem

[Jason Ramey]

Ok, did that. Here's what I got:

Driver error was:
QMYSQL3: Unable to execute query
Database error was:
You have an error in your SQL syntax near 'Jan 27 22:00:00 2003, Mon Jan
27 22:30:00 2003, "FOX News at 10", "", "", "News"' at line 1
DB Error (program insert):
was:
INSERT INTO program
(chanid,starttime,endtime,title,subtitle,description,category)
VALUES(1009, Mon Jan 27 22:30:00 2003, Mon Jan 27 23:00:00 2003, "FOX 41
Sports", "", "", "Talk");

Jason Ramey
webmaster at permutation.org

-----Original Message-----
From: mythtv-dev-bounces at snowman.net
[mailto:mythtv-dev-bounces at snowman.net] On Behalf Of Matt Zimmerman
Sent: Sunday, January 26, 2003 4:25 PM
To: Mythtv-dev
Subject: Re: [mythtv] MySQL problem


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
_______________________________________________
mythtv-dev mailing list
mythtv-dev at snowman.net
http://www.snowman.net/mailman/listinfo/mythtv-dev
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3271 bytes
Desc: not available
Url : /pipermail/attachments/20030126/74869e54/smime.bin