[mythtv-users] Problem Recording

[Colin Armstrong]

So, I did find the error on the mailing list and it did tell me what to
do, but now I am having trouble running the command. It told me to do a
database dump, which I did, and then to run mc.sql. After I did the
database dump, all of the files in mythconverg were still there and
mc.sql complained about there already being a database. Then, because of
this, I moved the bad file, recordmarkup.MYD to a different directory.
Then I ran "mysql > mc.sql" and it just sits there it does not give me
another terminal prompt but it goes done one line and the cursor just
blinks. It seems like it is doing something but I don't think it is,
because it has been going for 5 min and it has not stopped. One time I
stopped and checked to see if it had created recordmarkup.MYD and it had
not. Any ideas?
Thanks,
Colin
On Fri, 2003-08-22 at 07:18, Rob Minerick wrote:
> > DB Error (WriteRecordedToDB):
> > Query was:
> > INSERT INTO recorded
> > (chanid,starttime,endtime,title,subtitle,description,hostname,category)
> > VALUES(1004,"20030821160000","20030821163000","KRON 4 News at
> > 4","","Sinkovitz, Liviakis.","conf-pc.ca.sandia.gov","News");
> > Driver error was [2/-1]:
> > QMYSQL3: Unable to execute query
> > Database error was:
> > Duplicate entry '1004-20030821160000' for key 1
> 
> Colin,
> 	You should probably try to search the mythTV archives @ 
> http://www.gossamer-threads.com/archive/MythTV_C2. Someone had an 
> identical (or very close) problem a few months back. Just search for 
> recordedmarkup.MYD in the user archives and I think you'll find your 
> answer.
> 
> Cheers,
> Rob
> 
> 
> ______________________________________________________________________
> 
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users