Hi all, (this is with an R5B7 system)

My web UI takes a long time to load which I've traced to the fact that the date drop down list contains every day until September 2035! The backend status view also says "There's guide data until 2035-09-01 02:00 (10140 days)". I'm in the UK and getting my data over the air so really there is just data until next Tuesday.

Can you tell me what I need to check to try to fix this.

Thanks
-S

PS I have searched the forum for a similar issue but wasn't able to find anything.

Dropping your "video source" (listings), recreating it, and reloading the program data should clear the problem. If not, do a search here requiring all the terms "select from program" with me as the author. I helped someone with a similar "wild date" problem about a year or so back.

Hi, thanks for that. I've re-done the video sources a few times and I'm pretty sure this problem has gone across those re-builds. But I will try again.

I may need to read the other post you suggest. I tried the search but nothing seemed directly relevant. Sorry to be a pain but can you be more specific re the post?

Thanks.

can you peek at the listings and tell me the Patriots schedule for 2021

Thanks

_________________
R5F1 - Dell P4 2.4Ghz 500MB - PVR250 x 2 - GeForce FX 5200 - Onboard sound/NIC 80GB ATA/250GB ATA/400GB SATA

Alright, sounds like you've got a bad value coming across for one of the dates. You might want to try something like this:

You can run this like this:

Thanks for the SQL. In the end re-doing the video sources did fix it. Sorry to put you to the bother of the extra post.

Btw, I'm creating a really cool mobile phone app that is based around TV schedules that gives recommendations, social networking around the shows and mobile video on demand. Now that I've sorted out the date issue I've done a basic integration with mythweb to allow the app to set a show to record. I'd be interested to get a few UK myth users try it out.

-S

tjc, you are a diamond !!!

Thanks for that sql above. I was getting the same problem, and used the sql as above with a slight change, the required table to modify is called 'program', so the command to be used should be firstly

mysql -H mythconverg

then at the mysql prompt

delete from program where starttime > now() + interval 15 day;

_________________
Thanks in advance
Matt Shaw
matt@shagshaw.com

AMD Sempron 2400+ on Via Motherboard,
512MB Ram, 160GB IDE HDD,
Nvidia Geforce FX5500 128MB TV-Out,
2 x Twinhan DVB-T BT878 (Freeview UK)
KnoppMYTH R5F27

Corrected.

Most DB shops I've encountered use a standard naming convention that table/view names are plural and column names are singular to avoid certain types of confusion. It always throws me that the MythConverg schema doesn't follow this.