[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