Re: [mythtv-users] Movie & Category lists empty...
Jules Gosnell wrote: Bruce Markey wrote: Jules Gosnell wrote: Since upgrading my server to FC4 and moving up to 0.18, I seem to have lost the contents of these two under manageRecordings/ScheduleRecordings/SearchLists mythfilldatabase seems to be working happily and regularly and all my other program listing views are fully populated - maybe whatever is used to tag these has changed or somehow got broken in my installation ? Movies are selected by checking the program.category_type field and the Category lists are based on the program.category field. Look at the frontend output messages when you go to these pages to see if there are any database errors reported. You could highlight some shows from any of the scheduling pages and press "U" to see the program details and look to see if there are values for these fields. You could also try: mysql -u mythtv -pmythtv mythconverg mysql> select category_type,category from program; I enclose a log of this - things look OK, columns seem to be populated... Many are blank but that shouldn't matter. The strings look valid. running the frontend with -v all - ... asking for the Entertainment category : I forgot to ask but this implies that the popup did include the list of category names. 2005-09-16 12:26:23.732 write->8 19 QUERY_GETALLPENDING: 2005-09-16 12:26:30.921 write->8 36 QUERY_IS_ACTIVE_BACKEND[]:[]smilodon: So it didn't print a DBError for "ProgramList::FromProgram". both queries result in "No listings found for this program" being displayed other queries like 'New Titles', 'Channels' and 'Time' all find plenty of programs, as does the Program Guide... Well, unfortunately this doesn't make a lot of sense. The query to get the category names suceeded and the query for matching results didn't fail but returned no matches. The other similar queries worked which probably eliminates a damaged database table, all channels marked as invisible, or some general syntax error. In short, it shoudda worked. One other question, after your system upgrade, did you make sure to do a "make distclean" and recompile myth againts the current system libraries? If that doesn't fix it, please do the following: $ mysql -u mythtv -pmythtv mythconverg mysql> truncate program; then run "mythfilldatabase" again. If the problem still presists, run: $ mysqldump -ct -u mythtv -pmythtv mythconverg channel program > catquery.sql $ gzip catquery.sql and attach the file in an email to me. -- bjm ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Movie & Category lists empty...
Bruce Markey wrote: Jules Gosnell wrote: Since upgrading my server to FC4 and moving up to 0.18, I seem to have lost the contents of these two under manageRecordings/ScheduleRecordings/SearchLists mythfilldatabase seems to be working happily and regularly and all my other program listing views are fully populated - maybe whatever is used to tag these has changed or somehow got broken in my installation ? Movies are selected by checking the program.category_type field and the Category lists are based on the program.category field. Look at the frontend output messages when you go to these pages to see if there are any database errors reported. You could highlight some shows from any of the scheduling pages and press "U" to see the program details and look to see if there are values for these fields. You could also try: mysql -u mythtv -pmythtv mythconverg mysql> select category_type,category from program; I enclose a log of this - things look OK, columns seem to be populated... to see of these fields are populated or blank. If blank, there is a problem with your grabber or mythfilldatabase getting this info into the program table. If populated then there is a problem with mythfrontend querying for these values. running the frontend with -v all - asking for the movie list : 2005-09-16 12:25:38.499 Connecting to backend server: 192.168.0.2:6543 (try 1 of 5) 2005-09-16 12:25:38.499 write->8 21 MYTH_PROTO_VERSION 15: 2005-09-16 12:25:38.504 Using protocol version 15 2005-09-16 12:25:38.505 write->8 23 ANN Playback smilodon 0: 2005-09-16 12:25:38.579 write->8 19 QUERY_GETALLPENDING: 2005-09-16 12:25:38.697 23 ANN Playback smilodon 1 asking for the Entertainment category : 2005-09-16 12:26:23.732 write->8 19 QUERY_GETALLPENDING: 2005-09-16 12:26:30.921 write->8 36 QUERY_IS_ACTIVE_BACKEND[]:[]smilodon: both queries result in "No listings found for this program" being displayed other queries like 'New Titles', 'Channels' and 'Time' all find plenty of programs, as does the Program Guide... Thanks for the help, The server and client are both running 0.18.1-*.at I'm using the UK RadioTimes (alternate?) grabber. Jules -- bjm ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users -- "Open Source is a self-assembling organism. You dangle a piece of string into a super-saturated solution and a whole operating-system crystallises out around it." /** * Jules Gosnell * Partner * Core Developers Network (Europe) * *www.coredevelopers.net * * Open Source Training & Support. **/ myth.log.gz Description: GNU Zip compressed data ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Movie & Category lists empty...
Jules Gosnell wrote: Since upgrading my server to FC4 and moving up to 0.18, I seem to have lost the contents of these two under manageRecordings/ScheduleRecordings/SearchLists mythfilldatabase seems to be working happily and regularly and all my other program listing views are fully populated - maybe whatever is used to tag these has changed or somehow got broken in my installation ? Movies are selected by checking the program.category_type field and the Category lists are based on the program.category field. Look at the frontend output messages when you go to these pages to see if there are any database errors reported. You could highlight some shows from any of the scheduling pages and press "U" to see the program details and look to see if there are values for these fields. You could also try: mysql -u mythtv -pmythtv mythconverg mysql> select category_type,category from program; to see of these fields are populated or blank. If blank, there is a problem with your grabber or mythfilldatabase getting this info into the program table. If populated then there is a problem with mythfrontend querying for these values. -- bjm ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
[mythtv-users] Movie & Category lists empty...
Since upgrading my server to FC4 and moving up to 0.18, I seem to have lost the contents of these two under manageRecordings/ScheduleRecordings/SearchLists mythfilldatabase seems to be working happily and regularly and all my other program listing views are fully populated - maybe whatever is used to tag these has changed or somehow got broken in my installation ? I'd be grateful for any ideas... regards, Jules -- "Open Source is a self-assembling organism. You dangle a piece of string into a super-saturated solution and a whole operating-system crystallises out around it." /** * Jules Gosnell * Partner * Core Developers Network (Europe) * *www.coredevelopers.net * * Open Source Training & Support. **/ ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
