[mythtv] MySQL problem
Jason Ramey
webmaster at permutation.org
Sun Jan 26 16:45:16 EST 2003
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
More information about the mythtv-dev
mailing list