[mythtv] MySQL problem

[Jason Ramey]

I installed MythTV 0.8 from CVS today and everything has gone well
except for one thing. Upon running mythfilldatabase, I receive this:

Fetching data for Mon Jan 27 2003...
----------------- Start of XMLTV output -----------------

checking provider information for postal/zip code 40208, be patient..
double checking channel information, be patient..
writing listings to /tmp/mythIgbrOh
Day 2003-1-27 schedule for station 2 WAVE has:25 programs
Day 2003-1-27 schedule for station 3 TWC has:21 programs
Day 2003-1-27 schedule for station 4 WHAS has:24 programs
Day 2003-1-27 schedule for station 5 WLKY has:29 programs
Day 2003-1-27 schedule for station 7 WBKI has:35 programs
Day 2003-1-27 schedule for station 8 FWTKR8 has:41 programs
Day 2003-1-27 schedule for station 9 WDRB has:35 programs
Day 2003-1-27 schedule for station 10 WFTE has:36 programs
Day 2003-1-27 schedule for station 12 TLC has:38 programs
Day 2003-1-27 schedule for station 20 WGNSAT has:35 programs
Day 2003-1-27 schedule for station 21 WBNA has:38 programs
Day 2003-1-27 schedule for station 26 AMC has:11 programs
Day 2003-1-27 schedule for station 27 TBS has:31 programs
Day 2003-1-27 schedule for station 28 FX has:31 programs
Day 2003-1-27 schedule for station 29 DISN has:46 programs
Day 2003-1-27 schedule for station 31 FNC has:26 programs
Day 2003-1-27 schedule for station 32 OXYGEN has:35 programs
Day 2003-1-27 schedule for station 33 USA has:19 programs
Day 2003-1-27 schedule for station 34 CNN has:22 programs
Day 2003-1-27 schedule for station 35 LIFE has:31 programs
Day 2003-1-27 schedule for station 36 ARTS has:18 programs
Day 2003-1-27 schedule for station 37 MTV has:24 programs
Day 2003-1-27 schedule for station 38 DSC has:28 programs
Day 2003-1-27 schedule for station 39 CNBC has:18 programs
Day 2003-1-27 schedule for station 40 FAM has:37 programs
Day 2003-1-27 schedule for station 41 TNN has:32 programs
Day 2003-1-27 schedule for station 42 NIK has:42 programs
Day 2003-1-27 schedule for station 43 TNT has:19 programs
Day 2003-1-27 schedule for station 45 MSNBC has:20 programs
Day 2003-1-27 schedule for station 46 FOOD has:44 programs
Day 2003-1-27 schedule for station 47 VH1 has:22 programs
Day 2003-1-27 schedule for station 48 CNNH has:6 programs
Day 2003-1-27 schedule for station 49 BET has:19 programs
Day 2003-1-27 schedule for station 51 HGTV has:46 programs
Day 2003-1-27 schedule for station 52 TOON has:48 programs
Day 2003-1-27 schedule for station 53 COURT has:30 programs
Day 2003-1-27 schedule for station 54 HISTORY has:25 programs
Day 2003-1-27 schedule for station 55 FSOH5 has:34 programs
Day 2003-1-27 schedule for station 56 ETV has:29 programs
Day 2003-1-27 schedule for station 57 TVG has:31 programs
Day 2003-1-27 schedule for station 58 BRAVO has:33 programs
Day 2003-1-27 schedule for station 59 COMEDY has:37 programs
Day 2003-1-27 schedule for station 60 ANIMAL has:38 programs
Day 2003-1-27 schedule for station 61 TECHTV has:40 programs
Day 2003-1-27 schedule for station 62 TRAV has:39 programs
Day 2003-1-27 schedule for station 63 TBN has:36 programs
Day 2003-1-27 schedule for station 64 SCIFI has:29 programs
Day 2003-1-27 schedule for station 65 TVLAND has:34 programs
Grabbed 1467 programs on 48 channels over 1 day(s) in 100 seconds
  not too bad, that's 14.67 programs/sec and 2.08 seconds/www page
------------------ End of XMLTV output ------------------
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.


Jason Ramey
webmaster at permutation.org
-------------- 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/55103e14/smime.bin