[mythtv-users] mythfilldatabase - date problem

Sean Burlington sean at uncertainty.org.uk
Tue Oct 5 14:14:27 UTC 2004


Hi all,
	I've just set up mythtv and it's fantastic - and all seems to be 
working OK ...but

I get loads of mysql errors each night and looking more closely it seems 
that mythfilldatabase deletes a days program data - then inserts it - 
except that in  my case it seems to be deleting the wrong day

I haven't managed to find report so this in the archive - anyone got any 
ideas ?

DELETE FROM program WHERE starttime >= '20041018000000' AND starttime < 
'2 0041019000000' AND chanid = 1002
DELETE FROM programrating WHERE starttime >= '20041018000000'  AND 
starttime < '20041019000000' AND chanid = 1002
DELETE FROM credits WHERE starttime >= '20041018000000' AND starttime < 
'20041019000000' AND chanid = 1002
DELETE FROM programgenres WHERE starttime >= '20041018000000' AND 
starttime < '20041019000000' AND chanid = 1002

INSERT INTO program (chanid,starttime,endtime,title, 
title_pronounce,subtitle,description,category, 
category_type,airdate,stars,previouslyshown) 
VALUES(1002,'20041005060000','20041005092500','GMTV','','','6.00 GMTV 
News Hour with John Stapleton and Penny Smith. 7.00 GMTV Today: Eamonn 
Holmes and Fiona Phillips with the latest news, views and chat. Plus 
Black History Week and Richard Arnold''s TV Pick of the Day. 8.35 LK 
Today: Lorraine Kelly with fashion, showbiz and lifestyle 
news.','Entertainment','','2004',' 0',0)


More information about the mythtv-users mailing list