LinHES Forums
http://forum.linhes.org/

Listings date drop down in web UI has every day until 2035!
http://forum.linhes.org/viewtopic.php?f=6&t=17338		 Page 1 of 1
Author:  ssteward [ Tue Nov 27, 2007 3:47 am ]
Post subject:  Listings date drop down in web UI has every day until 2035!
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.
Author:  tjc [ Tue Nov 27, 2007 7:41 am ]
Post subject: 
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.
Author:  ssteward [ Tue Nov 27, 2007 7:55 am ]
Post subject: 
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.
Author:  khrusher [ Tue Nov 27, 2007 12:27 pm ]
Post subject: 
can you peek at the listings and tell me the Patriots schedule for 2021

Thanks :D
Author:  tjc [ Tue Nov 27, 2007 6:17 pm ]
Post subject: 
Alright, sounds like you've got a bad value coming across for one of the dates. You might want to try something like this:
Code:
delete from program where starttime > now() + interval 15 day

You can run this like this:
Code:
mysql mythconverg -u root -e "delete from program where starttime > now() + interval 15 day"
Author:  ssteward [ Wed Nov 28, 2007 6:04 am ]
Post subject: 
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
Author:  mattshaw [ Mon Dec 17, 2007 6:33 pm ]
Post subject: 
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;
Author:  tjc [ Mon Dec 17, 2007 7:06 pm ]
Post subject: 
:oops: 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.
Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/