Closed GoogleCodeExporter closed 9 years ago
In episodes.php add the $sub, $day, and print lines after line 258 like this
while ($row = mysql_fetch_assoc($getSubtitles)) {
$recDate[] = date('Y-m-d', strtotime($row['starttime']));
$recEpisodes[] = strtolower($row['subtitle']);
$sub = strtolower($row['subtitle']);
$day = date('Y-m-d', strtotime($row['starttime']));
print "$sub - $day<br>";
}
Now click on the show again and see what gets printed out at the top. You
should see all of the episodes in lower case that you have recorded for the
show.
I don't record this series, however I did just record an episode and it shows
up as being recorded in mythepisode. I also, scheduled for recording the
episode you listed above and it shows within mythepisode that it is scheduled
for recording.
Let me know what you get from the output and I can help debug it further.
Original comment by chadopp@gmail.com
on 22 Mar 2011 at 3:03
Warning at /usr/share/mythweb/modules/episode/episodes.php, line 144:
!!NoTrans: Invalid argument supplied for foreach()!!
intervention/shelter island - 2009-02-16
the pineapple incident - 2010-12-29
the yips - 2009-12-08
the limo - 2011-01-04
the platinum rule - 2010-12-13
little minnesota/benefits - 2011-02-02
the wedding - 2011-01-05
no tomorrow - 2010-12-14
wait for it... - 2010-11-29
drumroll, please - 2011-01-10
ten sessions - 2010-12-15
jenkins - 2011-01-03
do i know you?/the best burger in new york - 2009-02-02
zip, zip, zip - 2011-01-11
the bracket - 2010-12-16
definitions/double date - 2010-11-04
game night - 2011-01-12
the stinsons/sorry, bro - 2011-02-08
rabbit or duck - 2011-01-04
big days/cleaning house - 2011-02-03
cupcake/life among the gorillas - 2010-10-07
stuff - 2009-04-13
sandcastles in the sand - 2010-12-20
hooked - 2011-01-05
the front porch/old king clancy - 2011-02-09
nothing good happens after 2 a.m./mary the paralegal - 2010-10-14
say cheese - 2011-01-06
everything must go - 2010-12-23
murtaugh/mosbius designs - 2011-02-14
best prom ever - 2010-10-21
showdown - 2010-11-07
miracles - 2010-12-24
home wreckers - 2011-01-10
milk/come on - 2010-10-28
twin beds - 2011-01-11
we're not from here - 2010-11-16
as fast as she can/the leap - 2011-02-16
the wedding bride - 2011-01-13
the best burger in new york/i heart nj - 2011-01-25
the leap - 2009-07-13
sweet taste of liberty - 2010-12-07
the third wheel - 2010-11-17
i heart nj/intervention - 2009-02-09
unfinished/subway wars - 2011-02-10
return of the shirt - 2010-12-08
little boys - 2008-04-03
okay awesome - 2010-12-14
how i met everyone else - 2010-11-21
duel citizenship/bagpipes - 2010-11-18
architect of destruction/baby talk - 2011-02-17
slutty pumpkin - 2010-12-15
dowisetrepla - 2010-11-24
happily ever after/not a fathers day - 2011-01-31
dowisetrepla - 2010-12-07
the rough patch - 2010-11-25
the duel - 2010-12-22
pilot - 2010-11-30
woooo!/the fight - 2011-02-01
the playbook - 2010-12-27
canning randy/natural history - 2011-02-24
belly full of turkey - 2010-12-28
Warning at /usr/share/mythweb/modules/_shared/tmpl/default/header.php, line 16:
!!NoTrans: Cannot modify header information - headers already sent by (output
started at /usr/share/mythweb/includes/errors.php:150)!!
Original comment by seven%se...@gtempaccount.com
on 22 Mar 2011 at 3:15
I'm also seeing the same thing with Scrubs aswell, not only How I Met Your
Mother
Original comment by seven%se...@gtempaccount.com
on 22 Mar 2011 at 3:17
mysql> select title, subtitle, seriesid from oldrecorded where title like 'How
I Met Your Mother%' order by subtitle;
+-----------------------+------------------------------------------------------+
-----------+
| title | subtitle
| seriesid |
+-----------------------+------------------------------------------------------+
-----------+
| How I Met Your Mother | Aldrin Justice
| 204725794 |
| How I Met Your Mother | Architect of Destruction
| 204725794 |
| How I Met Your Mother | Architect of Destruction/Baby Talk
| 204725794 |
| How I Met Your Mother | Arrivederci, Fiero
| 204725794 |
| How I Met Your Mother | As Fast As She Can
| 204725794 |
| How I Met Your Mother | As Fast As She Can/The Leap
| 204725794 |
| How I Met Your Mother | Atlantic City
| 204725794 |
| How I Met Your Mother | Baby Talk
| 204725794 |
| How I Met Your Mother | Bachelor Party
| 204725794 |
| How I Met Your Mother | Bad News
| 204725794 |
| How I Met Your Mother | Bagpipes
| 204725794 |
| How I Met Your Mother | Belly Full of Turkey
| 204725794 |
| How I Met Your Mother | Benefits
| 204725794 |
| How I Met Your Mother | Best Prom Ever
| 204725794 |
| How I Met Your Mother | Big Days
| 204725794 |
| How I Met Your Mother | Big Days/Cleaning House
| 204725794 |
| How I Met Your Mother | Blitzgiving
| 204725794 |
| How I Met Your Mother | Blitzgiving/The Mermaid Theory
| 204725794 |
| How I Met Your Mother | Brunch
| 204725794 |
| How I Met Your Mother | Canning Randy
| 204725794 |
| How I Met Your Mother | Canning Randy/Natural History
| 204725794 |
| How I Met Your Mother | Cleaning House
| 204725794 |
| How I Met Your Mother | Columns
| 204725794 |
| How I Met Your Mother | Come On
| 204725794 |
| How I Met Your Mother | Come On/Do I Know You?
| 204725794 |
| How I Met Your Mother | Cupcake
| 204725794 |
| How I Met Your Mother | Cupcake/Life among the Gorillas
| 204725794 |
| How I Met Your Mother | Definitions
| 204725794 |
| How I Met Your Mother | Definitions/Double Date
| 204725794 |
| How I Met Your Mother | Do I Know You?
| 204725794 |
| How I Met Your Mother | Do I Know You?/The Best Burger in New York
| 204725794 |
| How I Met Your Mother | Doppelgangers
| 204725794 |
| How I Met Your Mother | Doppelgangers/Wait for It
| 204725794 |
| How I Met Your Mother | Double Date
| 204725794 |
| How I Met Your Mother | Dowisetrepla
| 204725794 |
| How I Met Your Mother | Dowisetrepla
| 204725794 |
| How I Met Your Mother | Drumroll, Please
| 204725794 |
| How I Met Your Mother | Duel Citizenship
| 204725794 |
| How I Met Your Mother | Duel Citizenship/Bagpipes
| 204725794 |
| How I Met Your Mother | Everything Must Go
| 204725794 |
| How I Met Your Mother | False Positive
| 204725794 |
| How I Met Your Mother | False Positive/Bad News
| 204725794 |
| How I Met Your Mother | First Time in New York
| 204725794 |
| How I Met Your Mother | Game Night
| 204725794 |
| How I Met Your Mother | Girls Vs. Suits
| 204725794 |
| How I Met Your Mother | Girls Vs. Suits/Jenkins
| 204725794 |
| How I Met Your Mother | Glitter
| 204725794 |
| How I Met Your Mother | Happily Ever After
| 204725794 |
| How I Met Your Mother | Happily Ever After/Not a Father's Day
| 204725794 |
| How I Met Your Mother | Happily Ever After/Not a Fathers Day
| 204725794 |
| How I Met Your Mother | Home Wreckers
| 204725794 |
| How I Met Your Mother | Hooked
| 204725794 |
| How I Met Your Mother | How I Met Everyone Else
| 204725794 |
| How I Met Your Mother | How Lily Stole Christmas
| 204725794 |
| How I Met Your Mother | I Heart NJ
| 204725794 |
| How I Met Your Mother | I Heart NJ/Intervention
| 204725794 |
| How I Met Your Mother | I'm Not That Guy
| 204725794 |
| How I Met Your Mother | I'm Not That Guy/Dowisetrepla
| 204725794 |
| How I Met Your Mother | I'm Not That Guy/Dowisetrepla
| 204725794 |
| How I Met Your Mother | Intervention
| 204725794 |
| How I Met Your Mother | Intervention/Shelter Island
| 204725794 |
| How I Met Your Mother | Jenkins
| 204725794 |
| How I Met Your Mother | Last Cigarette Ever
| 204725794 |
| How I Met Your Mother | Life among the Gorillas
| 204725794 |
| How I Met Your Mother | Little Boys
| 204725794 |
| How I Met Your Mother | Little Minnesota
| 204725794 |
| How I Met Your Mother | Little Minnesota/Benefits
| 204725794 |
| How I Met Your Mother | Lucky Penny
| 204725794 |
| How I Met Your Mother | Mary the Paralegal
| 204725794 |
| How I Met Your Mother | Matchmaker
| 204725794 |
| How I Met Your Mother | Milk
| 204725794 |
| How I Met Your Mother | Milk/Come On
| 204725794 |
| How I Met Your Mother | Miracles
| 204725794 |
| How I Met Your Mother | Monday Night Football
| 204725794 |
| How I Met Your Mother | Monday Night Football
| 204725794 |
| How I Met Your Mother | Mosbius Designs
| 204725794 |
| How I Met Your Mother | Moving Day
| 204725794 |
| How I Met Your Mother | Murtaugh
| 204725794 |
| How I Met Your Mother | Murtaugh/Mosbius Designs
| 204725794 |
| How I Met Your Mother | Natural History
| 204725794 |
| How I Met Your Mother | Natural History/Glitter
| 204725794 |
| How I Met Your Mother | No Tomorrow
| 204725794 |
| How I Met Your Mother | Not a Father's Day
| 204725794 |
| How I Met Your Mother | Not a Fathers Day
| 204725794 |
| How I Met Your Mother | Nothing Good Happens after 2 A.M.
| 204725794 |
| How I Met Your Mother | Nothing Good Happens after 2 A.M./Mary the Paralegal
| 204725794 |
| How I Met Your Mother | Okay Awesome
| 204725794 |
| How I Met Your Mother | Old King Clancy
| 204725794 |
| How I Met Your Mother | Pilot
| 204725794 |
| How I Met Your Mother | Purple Giraffe
| 204725794 |
| How I Met Your Mother | Rabbit or Duck
| 204725794 |
| How I Met Your Mother | Rebound Bro
| 204725794 |
| How I Met Your Mother | Return of the Shirt
| 204725794 |
| How I Met Your Mother | Right Place Right Time
| 204725794 |
| How I Met Your Mother | Robin 101
| 204725794 |
| How I Met Your Mother | Robin 101/The Sexless Innkeeper
| 204725794 |
| How I Met Your Mother | Robots vs Wrestlers
| 204725794 |
| How I Met Your Mother | Robots vs Wrestlers/The Wedding Bride
| 204725794 |
| How I Met Your Mother | Robots vs. Wrestlers
| 204725794 |
| How I Met Your Mother | Robots vs. Wrestlers/Matchmaker
| 204725794 |
| How I Met Your Mother | Sandcastles in the Sand
| 204725794 |
| How I Met Your Mother | Say Cheese
| 204725794 |
| How I Met Your Mother | Say Cheese/Zoo or False
| 204725794 |
| How I Met Your Mother | Shelter Island
| 204725794 |
| How I Met Your Mother | Showdown
| 204725794 |
| How I Met Your Mother | Single Stamina
| 204725794 |
| How I Met Your Mother | Slap Bet
| 204725794 |
| How I Met Your Mother | Slapsgiving
| 204725794 |
| How I Met Your Mother | Slapsgiving 2: Revenge of the Slap
| 204725794 |
| How I Met Your Mother | Slutty Pumpkin
| 204725794 |
| How I Met Your Mother | Something Blue
| 204725794 |
| How I Met Your Mother | Something Borrowed
| 204725794 |
| How I Met Your Mother | Something Borrowed/Something Blue
| 204725794 |
| How I Met Your Mother | Something Borrowed/Something Blue
| 204725794 |
| How I Met Your Mother | Sorry, Bro
| 204725794 |
| How I Met Your Mother | Stuff
| 204725794 |
| How I Met Your Mother | Subway Wars
| 204725794 |
| How I Met Your Mother | Swarley
| 204725794 |
| How I Met Your Mother | Sweet Taste of Liberty
| 204725794 |
| How I Met Your Mother | Ted Mosby: Architect
| 204725794 |
| How I Met Your Mother | Ten Sessions
| 204725794 |
| How I Met Your Mother | The Best Burger in New York
| 204725794 |
| How I Met Your Mother | The Best Burger in New York/I Heart Nj
| 204725794 |
| How I Met Your Mother | The Bracket
| 204725794 |
| How I Met Your Mother | The Chain of Screaming
| 204725794 |
| How I Met Your Mother | The Duel
| 204725794 |
| How I Met Your Mother | The Fight
| 204725794 |
| How I Met Your Mother | The Fight/Monday Night Football
| 204725794 |
| How I Met Your Mother | The Front Porch
| 204725794 |
| How I Met Your Mother | The Front Porch/Old King Clancy
| 204725794 |
| How I Met Your Mother | The Goat
| 204725794 |
| How I Met Your Mother | The Leap
| 204725794 |
| How I Met Your Mother | The Limo
| 204725794 |
| How I Met Your Mother | The Mermaid Theory
| 204725794 |
| How I Met Your Mother | The Pineapple Incident
| 204725794 |
| How I Met Your Mother | The Platinum Rule
| 204725794 |
| How I Met Your Mother | The Playbook
| 204725794 |
| How I Met Your Mother | The Possimpible
| 204725794 |
| How I Met Your Mother | The Rough Patch
| 204725794 |
| How I Met Your Mother | The Scorpion and the Toad
| 204725794 |
| How I Met Your Mother | The Sexless Innkeeper
| 204725794 |
| How I Met Your Mother | The Stinsons
| 204725794 |
| How I Met Your Mother | The Stinsons/Sorry, Bro
| 204725794 |
| How I Met Your Mother | The Third Wheel
| 204725794 |
| How I Met Your Mother | The Three Days Rule
| 204725794 |
| How I Met Your Mother | The Three Days Rule/Right Place Right Time
| 204725794 |
| How I Met Your Mother | The Wedding
| 204725794 |
| How I Met Your Mother | The Wedding Bride
| 204725794 |
| How I Met Your Mother | The Window
| 204725794 |
| How I Met Your Mother | The Window/Last Cigarette Ever
| 204725794 |
| How I Met Your Mother | The Window/Last Cigarette Ever/Girls Vs. Suits
| 204725794 |
| How I Met Your Mother | The Yips
| 204725794 |
| How I Met Your Mother | The Yips/The Platinum Rule
| 204725794 |
| How I Met Your Mother | Third Wheel
| 204725794 |
| How I Met Your Mother | Three Days of Snow
| 204725794 |
| How I Met Your Mother | Twin Beds
| 204725794 |
| How I Met Your Mother | Unfinished
| 204725794 |
| How I Met Your Mother | Unfinished/Subway Wars
| 204725794 |
| How I Met Your Mother | Wait For It...
| 204725794 |
| How I Met Your Mother | We're Not From Here
| 204725794 |
| How I Met Your Mother | We're Not from Here/Third Wheel
| 204725794 |
| How I Met Your Mother | We're Not from Here/Third Wheel
| 204725794 |
| How I Met Your Mother | Where Were We?
| 204725794 |
| How I Met Your Mother | Woooo!
| 204725794 |
| How I Met Your Mother | Woooo!/Columns
| 204725794 |
| How I Met Your Mother | Woooo!/The Fight
| 204725794 |
| How I Met Your Mother | World's Greatest Couple
| 204725794 |
| How I Met Your Mother | Zip, Zip, Zip
| 204725794 |
| How I Met Your Mother | Zoo or False
| 204725794 |
+-----------------------+------------------------------------------------------+
-----------+
169 rows in set (0.00 sec)
Original comment by seven%se...@gtempaccount.com
on 22 Mar 2011 at 3:25
In your query can you also show the recstatus.
Original comment by chadopp@gmail.com
on 22 Mar 2011 at 3:58
Add the print statement below this query so we can see what it is searching
your db for.
// Check the DB for any episodes of the show previously recorded
$getSubtitles = mysql_query("SELECT subtitle,starttime
FROM oldrecorded
WHERE ($titleQuery)
AND (recstatus = '-2' OR recstatus = '-3')
Group BY programid");
print "SELECT subtitle,starttime
FROM oldrecorded
WHERE ($titleQuery)
AND (recstatus = '-2' OR recstatus = '-3')
Group BY programid<br>";
Original comment by chadopp@gmail.com
on 22 Mar 2011 at 4:10
mysql> select title, subtitle, seriesid, recstatus from oldrecorded where title
like 'How I Met Your Mother%' order by subtitle;
+-----------------------+------------------------------------------------------+
-----------+-----------+
| title | subtitle
| seriesid | recstatus |
+-----------------------+------------------------------------------------------+
-----------+-----------+
| How I Met Your Mother | Aldrin Justice
| 204725794 | -3 |
| How I Met Your Mother | Architect of Destruction
| 204725794 | 0 |
| How I Met Your Mother | Architect of Destruction/Baby Talk
| 204725794 | -3 |
| How I Met Your Mother | Arrivederci, Fiero
| 204725794 | -3 |
| How I Met Your Mother | As Fast As She Can
| 204725794 | 0 |
| How I Met Your Mother | As Fast As She Can/The Leap
| 204725794 | -3 |
| How I Met Your Mother | Atlantic City
| 204725794 | -3 |
| How I Met Your Mother | Baby Talk
| 204725794 | 0 |
| How I Met Your Mother | Bachelor Party
| 204725794 | -3 |
| How I Met Your Mother | Bad News
| 204725794 | 0 |
| How I Met Your Mother | Bagpipes
| 204725794 | 11 |
| How I Met Your Mother | Belly Full of Turkey
| 204725794 | -3 |
| How I Met Your Mother | Benefits
| 204725794 | -3 |
| How I Met Your Mother | Best Prom Ever
| 204725794 | -3 |
| How I Met Your Mother | Big Days
| 204725794 | 0 |
| How I Met Your Mother | Big Days/Cleaning House
| 204725794 | -3 |
| How I Met Your Mother | Blitzgiving
| 204725794 | 0 |
| How I Met Your Mother | Blitzgiving/The Mermaid Theory
| 204725794 | -3 |
| How I Met Your Mother | Brunch
| 204725794 | -3 |
| How I Met Your Mother | Canning Randy
| 204725794 | 0 |
| How I Met Your Mother | Canning Randy/Natural History
| 204725794 | -3 |
| How I Met Your Mother | Cleaning House
| 204725794 | 0 |
| How I Met Your Mother | Columns
| 204725794 | 0 |
| How I Met Your Mother | Come On
| 204725794 | 0 |
| How I Met Your Mother | Come On/Do I Know You?
| 204725794 | -3 |
| How I Met Your Mother | Cupcake
| 204725794 | 0 |
| How I Met Your Mother | Cupcake/Life among the Gorillas
| 204725794 | -3 |
| How I Met Your Mother | Definitions
| 204725794 | 0 |
| How I Met Your Mother | Definitions/Double Date
| 204725794 | -3 |
| How I Met Your Mother | Do I Know You?
| 204725794 | 0 |
| How I Met Your Mother | Do I Know You?/The Best Burger in New York
| 204725794 | -3 |
| How I Met Your Mother | Doppelgangers
| 204725794 | 11 |
| How I Met Your Mother | Doppelgangers/Wait for It
| 204725794 | -3 |
| How I Met Your Mother | Double Date
| 204725794 | 11 |
| How I Met Your Mother | Dowisetrepla
| 204725794 | -3 |
| How I Met Your Mother | Dowisetrepla
| 204725794 | -3 |
| How I Met Your Mother | Drumroll, Please
| 204725794 | -3 |
| How I Met Your Mother | Duel Citizenship
| 204725794 | 0 |
| How I Met Your Mother | Duel Citizenship/Bagpipes
| 204725794 | -3 |
| How I Met Your Mother | Everything Must Go
| 204725794 | -3 |
| How I Met Your Mother | False Positive
| 204725794 | 0 |
| How I Met Your Mother | False Positive/Bad News
| 204725794 | 11 |
| How I Met Your Mother | First Time in New York
| 204725794 | -3 |
| How I Met Your Mother | Game Night
| 204725794 | -3 |
| How I Met Your Mother | Girls Vs. Suits
| 204725794 | 0 |
| How I Met Your Mother | Girls Vs. Suits/Jenkins
| 204725794 | 11 |
| How I Met Your Mother | Glitter
| 204725794 | 0 |
| How I Met Your Mother | Happily Ever After
| 204725794 | 0 |
| How I Met Your Mother | Happily Ever After/Not a Father's Day
| 204725794 | -3 |
| How I Met Your Mother | Happily Ever After/Not a Fathers Day
| 204725794 | -3 |
| How I Met Your Mother | Home Wreckers
| 204725794 | -3 |
| How I Met Your Mother | Hooked
| 204725794 | -3 |
| How I Met Your Mother | How I Met Everyone Else
| 204725794 | -3 |
| How I Met Your Mother | How Lily Stole Christmas
| 204725794 | -3 |
| How I Met Your Mother | I Heart NJ
| 204725794 | 0 |
| How I Met Your Mother | I Heart NJ/Intervention
| 204725794 | -3 |
| How I Met Your Mother | I'm Not That Guy
| 204725794 | 0 |
| How I Met Your Mother | I'm Not That Guy/Dowisetrepla
| 204725794 | 11 |
| How I Met Your Mother | I'm Not That Guy/Dowisetrepla
| 204725794 | 2 |
| How I Met Your Mother | Intervention
| 204725794 | 0 |
| How I Met Your Mother | Intervention/Shelter Island
| 204725794 | -3 |
| How I Met Your Mother | Jenkins
| 204725794 | -3 |
| How I Met Your Mother | Last Cigarette Ever
| 204725794 | 0 |
| How I Met Your Mother | Life among the Gorillas
| 204725794 | 11 |
| How I Met Your Mother | Little Boys
| 204725794 | -3 |
| How I Met Your Mother | Little Minnesota
| 204725794 | -3 |
| How I Met Your Mother | Little Minnesota/Benefits
| 204725794 | -3 |
| How I Met Your Mother | Lucky Penny
| 204725794 | -3 |
| How I Met Your Mother | Mary the Paralegal
| 204725794 | 0 |
| How I Met Your Mother | Matchmaker
| 204725794 | 0 |
| How I Met Your Mother | Milk
| 204725794 | 0 |
| How I Met Your Mother | Milk/Come On
| 204725794 | -3 |
| How I Met Your Mother | Miracles
| 204725794 | -3 |
| How I Met Your Mother | Monday Night Football
| 204725794 | 0 |
| How I Met Your Mother | Monday Night Football
| 204725794 | 0 |
| How I Met Your Mother | Mosbius Designs
| 204725794 | -3 |
| How I Met Your Mother | Moving Day
| 204725794 | -3 |
| How I Met Your Mother | Murtaugh
| 204725794 | -3 |
| How I Met Your Mother | Murtaugh/Mosbius Designs
| 204725794 | -3 |
| How I Met Your Mother | Natural History
| 204725794 | 0 |
| How I Met Your Mother | Natural History/Glitter
| 204725794 | -3 |
| How I Met Your Mother | No Tomorrow
| 204725794 | -3 |
| How I Met Your Mother | Not a Father's Day
| 204725794 | 0 |
| How I Met Your Mother | Not a Fathers Day
| 204725794 | 0 |
| How I Met Your Mother | Nothing Good Happens after 2 A.M.
| 204725794 | 11 |
| How I Met Your Mother | Nothing Good Happens after 2 A.M./Mary the Paralegal
| 204725794 | -3 |
| How I Met Your Mother | Okay Awesome
| 204725794 | -3 |
| How I Met Your Mother | Old King Clancy
| 204725794 | -3 |
| How I Met Your Mother | Pilot
| 204725794 | -3 |
| How I Met Your Mother | Purple Giraffe
| 204725794 | 0 |
| How I Met Your Mother | Rabbit or Duck
| 204725794 | -3 |
| How I Met Your Mother | Rebound Bro
| 204725794 | 11 |
| How I Met Your Mother | Return of the Shirt
| 204725794 | -3 |
| How I Met Your Mother | Right Place Right Time
| 204725794 | 0 |
| How I Met Your Mother | Robin 101
| 204725794 | 0 |
| How I Met Your Mother | Robin 101/The Sexless Innkeeper
| 204725794 | 11 |
| How I Met Your Mother | Robots vs Wrestlers
| 204725794 | 0 |
| How I Met Your Mother | Robots vs Wrestlers/The Wedding Bride
| 204725794 | 11 |
| How I Met Your Mother | Robots vs. Wrestlers
| 204725794 | 0 |
| How I Met Your Mother | Robots vs. Wrestlers/Matchmaker
| 204725794 | -3 |
| How I Met Your Mother | Sandcastles in the Sand
| 204725794 | -3 |
| How I Met Your Mother | Say Cheese
| 204725794 | -3 |
| How I Met Your Mother | Say Cheese/Zoo or False
| 204725794 | 11 |
| How I Met Your Mother | Shelter Island
| 204725794 | 0 |
| How I Met Your Mother | Showdown
| 204725794 | -3 |
| How I Met Your Mother | Single Stamina
| 204725794 | -3 |
| How I Met Your Mother | Slap Bet
| 204725794 | -3 |
| How I Met Your Mother | Slapsgiving
| 204725794 | 0 |
| How I Met Your Mother | Slapsgiving 2: Revenge of the Slap
| 204725794 | 0 |
| How I Met Your Mother | Slutty Pumpkin
| 204725794 | -3 |
| How I Met Your Mother | Something Blue
| 204725794 | 0 |
| How I Met Your Mother | Something Borrowed
| 204725794 | 0 |
| How I Met Your Mother | Something Borrowed/Something Blue
| 204725794 | -3 |
| How I Met Your Mother | Something Borrowed/Something Blue
| 204725794 | 0 |
| How I Met Your Mother | Sorry, Bro
| 204725794 | -3 |
| How I Met Your Mother | Stuff
| 204725794 | -3 |
| How I Met Your Mother | Subway Wars
| 204725794 | 0 |
| How I Met Your Mother | Swarley
| 204725794 | -3 |
| How I Met Your Mother | Sweet Taste of Liberty
| 204725794 | -3 |
| How I Met Your Mother | Ted Mosby: Architect
| 204725794 | -3 |
| How I Met Your Mother | Ten Sessions
| 204725794 | -3 |
| How I Met Your Mother | The Best Burger in New York
| 204725794 | 0 |
| How I Met Your Mother | The Best Burger in New York/I Heart Nj
| 204725794 | -3 |
| How I Met Your Mother | The Bracket
| 204725794 | -3 |
| How I Met Your Mother | The Chain of Screaming
| 204725794 | 11 |
| How I Met Your Mother | The Duel
| 204725794 | -3 |
| How I Met Your Mother | The Fight
| 204725794 | 0 |
| How I Met Your Mother | The Fight/Monday Night Football
| 204725794 | -3 |
| How I Met Your Mother | The Front Porch
| 204725794 | -3 |
| How I Met Your Mother | The Front Porch/Old King Clancy
| 204725794 | -3 |
| How I Met Your Mother | The Goat
| 204725794 | 11 |
| How I Met Your Mother | The Leap
| 204725794 | -3 |
| How I Met Your Mother | The Limo
| 204725794 | -3 |
| How I Met Your Mother | The Mermaid Theory
| 204725794 | 0 |
| How I Met Your Mother | The Pineapple Incident
| 204725794 | -3 |
| How I Met Your Mother | The Platinum Rule
| 204725794 | -3 |
| How I Met Your Mother | The Playbook
| 204725794 | -3 |
| How I Met Your Mother | The Possimpible
| 204725794 | -3 |
| How I Met Your Mother | The Rough Patch
| 204725794 | -3 |
| How I Met Your Mother | The Scorpion and the Toad
| 204725794 | -3 |
| How I Met Your Mother | The Sexless Innkeeper
| 204725794 | 11 |
| How I Met Your Mother | The Stinsons
| 204725794 | -3 |
| How I Met Your Mother | The Stinsons/Sorry, Bro
| 204725794 | -3 |
| How I Met Your Mother | The Third Wheel
| 204725794 | -3 |
| How I Met Your Mother | The Three Days Rule
| 204725794 | -3 |
| How I Met Your Mother | The Three Days Rule/Right Place Right Time
| 204725794 | 11 |
| How I Met Your Mother | The Wedding
| 204725794 | -3 |
| How I Met Your Mother | The Wedding Bride
| 204725794 | -3 |
| How I Met Your Mother | The Window
| 204725794 | 0 |
| How I Met Your Mother | The Window/Last Cigarette Ever
| 204725794 | 11 |
| How I Met Your Mother | The Window/Last Cigarette Ever/Girls Vs. Suits
| 204725794 | -3 |
| How I Met Your Mother | The Yips
| 204725794 | -3 |
| How I Met Your Mother | The Yips/The Platinum Rule
| 204725794 | 11 |
| How I Met Your Mother | Third Wheel
| 204725794 | 0 |
| How I Met Your Mother | Three Days of Snow
| 204725794 | -3 |
| How I Met Your Mother | Twin Beds
| 204725794 | -3 |
| How I Met Your Mother | Unfinished
| 204725794 | 0 |
| How I Met Your Mother | Unfinished/Subway Wars
| 204725794 | -3 |
| How I Met Your Mother | Wait For It...
| 204725794 | -3 |
| How I Met Your Mother | We're Not From Here
| 204725794 | -3 |
| How I Met Your Mother | We're Not from Here/Third Wheel
| 204725794 | 11 |
| How I Met Your Mother | We're Not from Here/Third Wheel
| 204725794 | 2 |
| How I Met Your Mother | Where Were We?
| 204725794 | -3 |
| How I Met Your Mother | Woooo!
| 204725794 | 0 |
| How I Met Your Mother | Woooo!/Columns
| 204725794 | -3 |
| How I Met Your Mother | Woooo!/The Fight
| 204725794 | -3 |
| How I Met Your Mother | World's Greatest Couple
| 204725794 | -3 |
| How I Met Your Mother | Zip, Zip, Zip
| 204725794 | -3 |
| How I Met Your Mother | Zoo or False
| 204725794 | 0 |
+-----------------------+------------------------------------------------------+
-----------+-----------+
169 rows in set (0.00 sec)
Original comment by seven%se...@gtempaccount.com
on 22 Mar 2011 at 4:22
ok recstatus looks like the problem, I know some of these I've manually
inserted due to the dual episode airing, what do each of the recstatus's mean?
below is an example insert statement I would use
insert into oldrecorded (starttime, duplicate, chanid, seriesid, station,
title, subtitle) values (now(),1,4007, 204725794, '7 Digital', 'How I Met Your
Mother',"Third Wheel");
Original comment by seven%se...@gtempaccount.com
on 22 Mar 2011 at 4:30
typedef enum RecStatusTypes {
rsTuning = -10,
rsFailed = -9,
rsTunerBusy = -8,
rsLowDiskSpace = -7,
rsCancelled = -6,
rsMissed = -5,
rsAborted = -4,
rsRecorded = -3,
rsRecording = -2,
rsWillRecord = -1,
rsUnknown = 0,
rsDontRecord = 1,
rsPreviousRecording = 2,
rsCurrentRecording = 3,
rsEarlierShowing = 4,
rsTooManyRecordings = 5,
rsNotListed = 6,
rsConflict = 7,
rsLaterShowing = 8,
rsRepeat = 9,
rsInactive = 10,
rsNeverRecord = 11,
rsOffLine = 12,
rsOtherShowing = 13
} RecStatusType; // note stored in int8_t in ProgramInfo
Original comment by chadopp@gmail.com
on 22 Mar 2011 at 4:35
I would set the recstatus to -3 when you do the insert
Original comment by chadopp@gmail.com
on 22 Mar 2011 at 4:38
Still not showing after setting all recording to recstatus = '-3' the ones set
to never record were because I've seen them before
update oldrecorded set recstatus = '-3' where title = 'How I Met Your Mother'
AND recstatus IN ('0','11');
Adding
print "SELECT subtitle,starttime
FROM oldrecorded
WHERE ($titleQuery)
AND (recstatus = '-2' OR recstatus = '-3')
Group BY programid<br>";
didn't print any additional details
Warning at /usr/share/mythweb/modules/episode/episodes.php, line 144:
!!NoTrans: Invalid argument supplied for foreach()!!
intervention/shelter island - 2009-02-16
the pineapple incident - 2010-12-29
the yips - 2009-12-08
the limo - 2011-01-04
the platinum rule - 2010-12-13
little minnesota/benefits - 2011-02-02
the wedding - 2011-01-05
no tomorrow - 2010-12-14
wait for it... - 2010-11-29
drumroll, please - 2011-01-10
ten sessions - 2010-12-15
jenkins - 2011-01-03
do i know you?/the best burger in new york - 2009-02-02
zip, zip, zip - 2011-01-11
the bracket - 2010-12-16
definitions/double date - 2010-11-04
game night - 2011-01-12
the chain of screaming - 2010-12-16
the stinsons/sorry, bro - 2011-02-08
rabbit or duck - 2011-01-04
big days/cleaning house - 2011-02-03
cupcake/life among the gorillas - 2010-10-07
stuff - 2009-04-13
sandcastles in the sand - 2010-12-20
hooked - 2011-01-05
life among the gorillas - 2011-01-13
the front porch/old king clancy - 2011-02-09
nothing good happens after 2 a.m./mary the paralegal - 2010-10-14
say cheese - 2011-01-06
everything must go - 2010-12-23
murtaugh/mosbius designs - 2011-02-14
best prom ever - 2010-10-21
showdown - 2010-11-07
miracles - 2010-12-24
home wreckers - 2011-01-10
milk/come on - 2010-10-28
twin beds - 2011-01-11
we're not from here - 2010-11-16
as fast as she can/the leap - 2011-02-16
the wedding bride - 2011-01-13
the best burger in new york/i heart nj - 2011-01-25
the leap - 2009-07-13
sweet taste of liberty - 2010-12-07
the third wheel - 2010-11-17
i heart nj/intervention - 2009-02-09
unfinished/subway wars - 2011-02-10
return of the shirt - 2010-12-08
little boys - 2008-04-03
okay awesome - 2010-12-14
how i met everyone else - 2010-11-21
duel citizenship/bagpipes - 2010-11-18
architect of destruction/baby talk - 2011-02-17
slutty pumpkin - 2010-12-15
dowisetrepla - 2010-11-24
happily ever after/not a fathers day - 2011-01-31
dowisetrepla - 2010-12-07
the rough patch - 2010-11-25
the duel - 2010-12-22
pilot - 2010-11-30
woooo!/the fight - 2011-02-01
the playbook - 2010-12-27
canning randy/natural history - 2011-02-24
belly full of turkey - 2010-12-28
Warning at /usr/share/mythweb/modules/_shared/tmpl/default/header.php, line 16:
!!NoTrans: Cannot modify header information - headers already sent by (output
started at /usr/share/mythweb/includes/errors.php:150)!!
Original comment by seven%se...@gtempaccount.com
on 22 Mar 2011 at 5:13
You shouldn't be getting any errors at the top of the output. Verify that the
episodes.php matches what was originally contained in the tar file.
Also,
run this query and see if you get what you think you should have.
SELECT subtitle,starttime FROM oldrecorded
WHERE title like '%How I Met Your Mother'
AND (recstatus = '-2' OR recstatus = '-3')
Group BY programid
This is the same query I run to get previous recordings.
Original comment by chadopp@gmail.com
on 22 Mar 2011 at 5:40
You might also want to include programid in your query you are running above.
Since I'm doing an order by programid you might have issues if your programid
is messed up.
Original comment by chadopp@gmail.com
on 22 Mar 2011 at 5:49
rahter I'm doing a group by programid. run
select title, subtitle, seriesid, programid, recstatus from oldrecorded where
title like 'How I Met Your Mother%'
I would bet the programid's are out of whack.
Original comment by chadopp@gmail.com
on 22 Mar 2011 at 5:51
Yep alot of missing entries
| title | subtitle
| seriesid | programid |
+-----------------------+------------------------------------------------------+
-----------+----------------+
| How I Met Your Mother | Aldrin Justice
| 204725794 | |
| How I Met Your Mother | Architect of Destruction
| 204725794 | |
| How I Met Your Mother | Architect of Destruction/Baby Talk
| 204725794 | EP20472579456 |
| How I Met Your Mother | Arrivederci, Fiero
| 204725794 | |
| How I Met Your Mother | As Fast As She Can
| 204725794 | |
| How I Met Your Mother | As Fast As She Can/The Leap
| 204725794 | EP204725794234 |
| How I Met Your Mother | Atlantic City
| 204725794 | |
| How I Met Your Mother | Baby Talk
| 204725794 | |
| How I Met Your Mother | Bachelor Party
| 204725794 | |
| How I Met Your Mother | Bad News
| 204725794 | |
| How I Met Your Mother | Bagpipes
| 204725794 | |
| How I Met Your Mother | Belly Full of Turkey
| 204725794 | EP20472579491 |
| How I Met Your Mother | Benefits
| 204725794 | |
| How I Met Your Mother | Best Prom Ever
| 204725794 | EP204725794201 |
| How I Met Your Mother | Big Days
| 204725794 | |
| How I Met Your Mother | Big Days/Cleaning House
| 204725794 | EP20472579416 |
| How I Met Your Mother | Blitzgiving
| 204725794 | |
| How I Met Your Mother | Blitzgiving/The Mermaid Theory
| 204725794 | |
| How I Met Your Mother | Brunch
| 204725794 | |
| How I Met Your Mother | Canning Randy
| 204725794 | |
| How I Met Your Mother | Canning Randy/Natural History
| 204725794 | EP20472579486 |
| How I Met Your Mother | Cleaning House
| 204725794 | |
| How I Met Your Mother | Columns
| 204725794 | |
| How I Met Your Mother | Come On
| 204725794 | |
| How I Met Your Mother | Come On/Do I Know You?
| 204725794 | |
| How I Met Your Mother | Cupcake
| 204725794 | |
| How I Met Your Mother | Cupcake/Life among the Gorillas
| 204725794 | EP204725794161 |
| How I Met Your Mother | Definitions
| 204725794 | |
| How I Met Your Mother | Definitions/Double Date
| 204725794 | EP20472579415 |
| How I Met Your Mother | Do I Know You?
| 204725794 | |
| How I Met Your Mother | Do I Know You?/The Best Burger in New York
| 204725794 | EP20472579414 |
| How I Met Your Mother | Doppelgangers
| 204725794 | |
| How I Met Your Mother | Doppelgangers/Wait for It
| 204725794 | |
| How I Met Your Mother | Double Date
| 204725794 | |
| How I Met Your Mother | Dowisetrepla
| 204725794 | EP20472579463 |
| How I Met Your Mother | Dowisetrepla
| 204725794 | EP20472579473 |
| How I Met Your Mother | Drumroll, Please
| 204725794 | EP204725794131 |
| How I Met Your Mother | Duel Citizenship
| 204725794 | |
| How I Met Your Mother | Duel Citizenship/Bagpipes
| 204725794 | EP20472579455 |
| How I Met Your Mother | Everything Must Go
| 204725794 | EP204725794193 |
| How I Met Your Mother | False Positive
| 204725794 | |
| How I Met Your Mother | False Positive/Bad News
| 204725794 | |
| How I Met Your Mother | First Time in New York
| 204725794 | |
| How I Met Your Mother | Game Night
| 204725794 | EP204725794151 |
| How I Met Your Mother | Girls Vs. Suits
| 204725794 | |
| How I Met Your Mother | Girls Vs. Suits/Jenkins
| 204725794 | |
| How I Met Your Mother | Glitter
| 204725794 | |
| How I Met Your Mother | Happily Ever After
| 204725794 | |
| How I Met Your Mother | Happily Ever After/Not a Father's Day
| 204725794 | |
| How I Met Your Mother | Happily Ever After/Not a Fathers Day
| 204725794 | EP20472579464 |
| How I Met Your Mother | Home Wreckers
| 204725794 | EP204725794205 |
| How I Met Your Mother | Hooked
| 204725794 | EP204725794165 |
| How I Met Your Mother | How I Met Everyone Else
| 204725794 | EP20472579453 |
| How I Met Your Mother | How Lily Stole Christmas
| 204725794 | |
| How I Met Your Mother | I Heart NJ
| 204725794 | |
| How I Met Your Mother | I Heart NJ/Intervention
| 204725794 | EP20472579434 |
| How I Met Your Mother | I'm Not That Guy
| 204725794 | |
| How I Met Your Mother | I'm Not That Guy/Dowisetrepla
| 204725794 | |
| How I Met Your Mother | I'm Not That Guy/Dowisetrepla
| 204725794 | EP20472579443 |
| How I Met Your Mother | Intervention
| 204725794 | |
| How I Met Your Mother | Intervention/Shelter Island
| 204725794 | |
| How I Met Your Mother | Jenkins
| 204725794 | EP204725794135 |
| How I Met Your Mother | Last Cigarette Ever
| 204725794 | |
| How I Met Your Mother | Life among the Gorillas
| 204725794 | EP204725794171 |
| How I Met Your Mother | Little Boys
| 204725794 | EP20472579443 |
| How I Met Your Mother | Little Minnesota
| 204725794 | |
| How I Met Your Mother | Little Minnesota/Benefits
| 204725794 | EP204725794114 |
| How I Met Your Mother | Lucky Penny
| 204725794 | |
| How I Met Your Mother | Mary the Paralegal
| 204725794 | |
| How I Met Your Mother | Matchmaker
| 204725794 | |
| How I Met Your Mother | Milk
| 204725794 | |
| How I Met Your Mother | Milk/Come On
| 204725794 | EP204725794211 |
| How I Met Your Mother | Miracles
| 204725794 | EP204725794203 |
| How I Met Your Mother | Monday Night Football
| 204725794 | |
| How I Met Your Mother | Monday Night Football
| 204725794 | |
| How I Met Your Mother | Mosbius Designs
| 204725794 | |
| How I Met Your Mother | Moving Day
| 204725794 | |
| How I Met Your Mother | Murtaugh
| 204725794 | |
| How I Met Your Mother | Murtaugh/Mosbius Designs
| 204725794 | EP204725794194 |
| How I Met Your Mother | Natural History
| 204725794 | |
| How I Met Your Mother | Natural History/Glitter
| 204725794 | |
| How I Met Your Mother | No Tomorrow
| 204725794 | EP204725794123 |
| How I Met Your Mother | Not a Father's Day
| 204725794 | |
| How I Met Your Mother | Not a Fathers Day
| 204725794 | |
| How I Met Your Mother | Nothing Good Happens after 2 A.M.
| 204725794 | |
| How I Met Your Mother | Nothing Good Happens after 2 A.M./Mary the Paralegal
| 204725794 | EP204725794181 |
| How I Met Your Mother | Okay Awesome
| 204725794 | EP20472579451 |
| How I Met Your Mother | Old King Clancy
| 204725794 | |
| How I Met Your Mother | Pilot
| 204725794 | EP20472579483 |
| How I Met Your Mother | Purple Giraffe
| 204725794 | |
| How I Met Your Mother | Rabbit or Duck
| 204725794 | EP204725794155 |
| How I Met Your Mother | Rebound Bro
| 204725794 | |
| How I Met Your Mother | Return of the Shirt
| 204725794 | EP20472579441 |
| How I Met Your Mother | Right Place Right Time
| 204725794 | |
| How I Met Your Mother | Robin 101
| 204725794 | |
| How I Met Your Mother | Robin 101/The Sexless Innkeeper
| 204725794 | |
| How I Met Your Mother | Robots vs Wrestlers
| 204725794 | |
| How I Met Your Mother | Robots vs Wrestlers/The Wedding Bride
| 204725794 | |
| How I Met Your Mother | Robots vs. Wrestlers
| 204725794 | |
| How I Met Your Mother | Robots vs. Wrestlers/Matchmaker
| 204725794 | |
| How I Met Your Mother | Sandcastles in the Sand
| 204725794 | EP204725794163 |
| How I Met Your Mother | Say Cheese
| 204725794 | EP204725794185 |
| How I Met Your Mother | Say Cheese/Zoo or False
| 204725794 | |
| How I Met Your Mother | Shelter Island
| 204725794 | |
| How I Met Your Mother | Showdown
| 204725794 | EP204725794202 |
| How I Met Your Mother | Single Stamina
| 204725794 | |
| How I Met Your Mother | Slap Bet
| 204725794 | |
| How I Met Your Mother | Slapsgiving
| 204725794 | |
| How I Met Your Mother | Slapsgiving 2: Revenge of the Slap
| 204725794 | |
| How I Met Your Mother | Slutty Pumpkin
| 204725794 | EP20472579461 |
| How I Met Your Mother | Something Blue
| 204725794 | |
| How I Met Your Mother | Something Borrowed
| 204725794 | |
| How I Met Your Mother | Something Borrowed/Something Blue
| 204725794 | |
| How I Met Your Mother | Something Borrowed/Something Blue
| 204725794 | |
| How I Met Your Mother | Sorry, Bro
| 204725794 | |
| How I Met Your Mother | Stuff
| 204725794 | EP204725794162 |
| How I Met Your Mother | Subway Wars
| 204725794 | |
| How I Met Your Mother | Swarley
| 204725794 | |
| How I Met Your Mother | Sweet Taste of Liberty
| 204725794 | EP20472579431 |
| How I Met Your Mother | Ted Mosby: Architect
| 204725794 | |
| How I Met Your Mother | Ten Sessions
| 204725794 | EP204725794133 |
| How I Met Your Mother | The Best Burger in New York
| 204725794 | |
| How I Met Your Mother | The Best Burger in New York/I Heart Nj
| 204725794 | EP20472579424 |
| How I Met Your Mother | The Bracket
| 204725794 | EP204725794143 |
| How I Met Your Mother | The Chain of Screaming
| 204725794 | EP204725794153 |
| How I Met Your Mother | The Duel
| 204725794 | EP20472579481 |
| How I Met Your Mother | The Fight
| 204725794 | |
| How I Met Your Mother | The Fight/Monday Night Football
| 204725794 | |
| How I Met Your Mother | The Front Porch
| 204725794 | |
| How I Met Your Mother | The Front Porch/Old King Clancy
| 204725794 | EP204725794174 |
| How I Met Your Mother | The Goat
| 204725794 | |
| How I Met Your Mother | The Leap
| 204725794 | EP204725794244 |
| How I Met Your Mother | The Limo
| 204725794 | EP204725794111 |
| How I Met Your Mother | The Mermaid Theory
| 204725794 | |
| How I Met Your Mother | The Pineapple Incident
| 204725794 | EP204725794101 |
| How I Met Your Mother | The Platinum Rule
| 204725794 | EP204725794113 |
| How I Met Your Mother | The Playbook
| 204725794 | EP20472579485 |
| How I Met Your Mother | The Possimpible
| 204725794 | |
| How I Met Your Mother | The Rough Patch
| 204725794 | EP20472579475 |
| How I Met Your Mother | The Scorpion and the Toad
| 204725794 | |
| How I Met Your Mother | The Sexless Innkeeper
| 204725794 | |
| How I Met Your Mother | The Stinsons
| 204725794 | |
| How I Met Your Mother | The Stinsons/Sorry, Bro
| 204725794 | EP204725794154 |
| How I Met Your Mother | The Third Wheel
| 204725794 | EP20472579433 |
| How I Met Your Mother | The Three Days Rule
| 204725794 | |
| How I Met Your Mother | The Three Days Rule/Right Place Right Time
| 204725794 | |
| How I Met Your Mother | The Wedding
| 204725794 | EP204725794121 |
| How I Met Your Mother | The Wedding Bride
| 204725794 | EP204725794235 |
| How I Met Your Mother | The Window
| 204725794 | |
| How I Met Your Mother | The Window/Last Cigarette Ever
| 204725794 | |
| How I Met Your Mother | The Window/Last Cigarette Ever/Girls Vs. Suits
| 204725794 | |
| How I Met Your Mother | The Yips
| 204725794 | EP204725794103 |
| How I Met Your Mother | The Yips/The Platinum Rule
| 204725794 | |
| How I Met Your Mother | Third Wheel
| 204725794 | |
| How I Met Your Mother | Three Days of Snow
| 204725794 | |
| How I Met Your Mother | Twin Beds
| 204725794 | EP204725794215 |
| How I Met Your Mother | Unfinished
| 204725794 | |
| How I Met Your Mother | Unfinished/Subway Wars
| 204725794 | EP20472579436 |
| How I Met Your Mother | Wait For It...
| 204725794 | EP20472579413 |
| How I Met Your Mother | We're Not From Here
| 204725794 | EP20472579423 |
| How I Met Your Mother | We're Not from Here/Third Wheel
| 204725794 | |
| How I Met Your Mother | We're Not from Here/Third Wheel
| 204725794 | EP20472579423 |
| How I Met Your Mother | Where Were We?
| 204725794 | |
| How I Met Your Mother | Woooo!
| 204725794 | |
| How I Met Your Mother | Woooo!/Columns
| 204725794 | |
| How I Met Your Mother | Woooo!/The Fight
| 204725794 | EP20472579484 |
| How I Met Your Mother | World's Greatest Couple
| 204725794 | |
| How I Met Your Mother | Zip, Zip, Zip
| 204725794 | EP204725794141 |
| How I Met Your Mother | Zoo or False
| 204725794 | |
+-----------------------+------------------------------------------------------+
-----------+----------------+
169 rows in set (0.00 sec)
Original comment by seven%se...@gtempaccount.com
on 22 Mar 2011 at 6:53
mysql> SELECT subtitle,starttime FROM oldrecorded
WHERE title like '%How I Met Your Mother'
AND (recstatus = '-2' OR recstatus = '-3')
Group BY programid;
+------------------------------------------------------+---------------------+
| subtitle | starttime |
+------------------------------------------------------+---------------------+
| Intervention/Shelter Island | 2009-02-16 19:30:00 |
| The Pineapple Incident | 2010-12-29 19:30:00 |
| The Yips | 2009-12-08 19:00:00 |
| The Limo | 2011-01-04 19:30:00 |
| The Platinum Rule | 2010-12-13 19:00:00 |
| Little Minnesota/Benefits | 2011-02-02 19:30:00 |
| The Wedding | 2011-01-05 19:30:00 |
| No Tomorrow | 2010-12-14 19:00:00 |
| Wait For It... | 2010-11-29 19:00:00 |
| Drumroll, Please | 2011-01-10 19:30:00 |
| Ten Sessions | 2010-12-15 19:00:00 |
| Jenkins | 2011-01-03 19:00:00 |
| Do I Know You?/The Best Burger in New York | 2009-02-02 19:30:00 |
| Zip, Zip, Zip | 2011-01-11 19:30:00 |
| The Bracket | 2010-12-16 19:00:00 |
| Definitions/Double Date | 2010-11-04 21:30:00 |
| Game Night | 2011-01-12 19:30:00 |
| The Chain of Screaming | 2010-12-16 13:32:48 |
| The Stinsons/Sorry, Bro | 2011-02-08 19:30:00 |
| Rabbit or Duck | 2011-01-04 19:00:00 |
| Big Days/Cleaning House | 2011-02-03 19:30:00 |
| Cupcake/Life among the Gorillas | 2010-10-07 21:30:00 |
| Stuff | 2009-04-13 19:30:00 |
| Sandcastles in the Sand | 2010-12-20 19:00:00 |
| Hooked | 2011-01-05 19:00:00 |
| Life among the Gorillas | 2011-01-13 00:59:27 |
| The Front Porch/Old King Clancy | 2011-02-09 19:30:00 |
| Nothing Good Happens after 2 A.M./Mary the Paralegal | 2010-10-14 21:30:00 |
| Say Cheese | 2011-01-06 19:00:00 |
| Everything Must Go | 2010-12-23 19:00:00 |
| Murtaugh/Mosbius Designs | 2011-02-14 19:30:00 |
| Best Prom Ever | 2010-10-21 22:00:00 |
| Showdown | 2010-11-07 18:30:00 |
| Miracles | 2010-12-24 19:00:00 |
| Home Wreckers | 2011-01-10 19:00:00 |
| Milk/Come On | 2010-10-28 21:30:00 |
| Twin Beds | 2011-01-11 19:00:00 |
| We're Not From Here | 2010-11-16 19:30:00 |
| As Fast As She Can/The Leap | 2011-02-16 19:30:00 |
| The Wedding Bride | 2011-01-13 19:05:00 |
| The Best Burger in New York/I Heart Nj | 2011-01-25 19:30:00 |
| The Leap | 2009-07-13 19:30:00 |
| Sweet Taste of Liberty | 2010-12-07 19:30:00 |
| The Third Wheel | 2010-11-17 19:30:00 |
| I Heart NJ/Intervention | 2009-02-09 19:30:00 |
| Unfinished/Subway Wars | 2011-02-10 19:30:00 |
| Return of the Shirt | 2010-12-08 19:30:00 |
| Little Boys | 2008-04-03 20:00:00 |
| Okay Awesome | 2010-12-14 19:30:00 |
| How I Met Everyone Else | 2010-11-21 20:30:00 |
| Duel Citizenship/Bagpipes | 2010-11-18 21:30:00 |
| Architect of Destruction/Baby Talk | 2011-02-17 19:30:00 |
| Slutty Pumpkin | 2010-12-15 19:30:00 |
| Dowisetrepla | 2010-11-24 19:30:00 |
| Happily Ever After/Not a Fathers Day | 2011-01-31 19:30:00 |
| Dowisetrepla | 2010-12-07 19:00:00 |
| The Rough Patch | 2010-11-25 22:00:00 |
| The Duel | 2010-12-22 19:30:00 |
| Pilot | 2010-11-30 19:30:00 |
| Woooo!/The Fight | 2011-02-01 19:30:00 |
| The Playbook | 2010-12-27 19:00:00 |
| Canning Randy/Natural History | 2011-02-24 20:00:00 |
| Belly Full of Turkey | 2010-12-28 19:30:00 |
+------------------------------------------------------+---------------------+
63 rows in set (0.01 sec)
Original comment by seven%se...@gtempaccount.com
on 22 Mar 2011 at 6:53
The programid is used to determine if a program has been recorded when checking
for duplicate matches. You could assign some random programid and it would
work in mythepisode, however if the episode comes on tv again mythtv might
rerecord it as it doesn't see a match for the programid in the oldrecorded
table. But since you have a blank programid for some shows now this would be
the case anyway.
Original comment by chadopp@gmail.com
on 22 Mar 2011 at 2:39
I dont believe this is the case, the whole reason I started inserting these
records is so they dont get re-recorded when aired again and I can confirm this
works without having a programid, I do have duplicate checking using Subtitle
only though.
Original comment by seven%se...@gtempaccount.com
on 22 Mar 2011 at 9:26
You should be able to add a unique bogus programid for each of the shows and
they will show up in mythepisode as being recorded
Original comment by chadopp@gmail.com
on 23 Mar 2011 at 1:01
ok that works, guess I'll need to through and fill these in :(
Thanks for your help
Original comment by seven%se...@gtempaccount.com
on 23 Mar 2011 at 1:25
Glad I could help. I've been wanting to fix a small issue that I was seeing.
I just didn't feel like digging into the code. This gave me the opportunity to
do that. I'm going to close this ticket as "Not a problem" since it's really
not an issue with the code.
Original comment by chadopp@gmail.com
on 23 Mar 2011 at 1:48
The other issue is the errors below at the top of the page when going into a
show, do you want me to open a new issue for this?
Warning at /usr/share/mythweb/modules/episode/episodes.php, line 144:
!!NoTrans: Invalid argument supplied for foreach()!!
Warning at /usr/share/mythweb/modules/_shared/tmpl/default/header.php, line 16:
!!NoTrans: Cannot modify header information - headers already sent by (output
started at /usr/share/mythweb/includes/errors.php:150)!!
Original comment by seven%se...@gtempaccount.com
on 23 Mar 2011 at 10:14
Did you remove all of the print/echo statements I had you add? What version of
mythtv/mythweb are you running? Have you always gotten these error messages?
Is it only the first time you go to a show or everytime?
Original comment by chadopp@gmail.com
on 24 Mar 2011 at 1:34
Yes I did, was also having this before adding the echo statements, I cant
recall if this was an issue on the older version I was running I upgraded when
I had the missing episodes issue.
MythTV Version : 0.24-6.md12 (4af46b1f5d)
happens everytime I goto a show
Original comment by seven%se...@gtempaccount.com
on 24 Mar 2011 at 2:12
Did you make the required changes to episodes.php for use with .24?
The classes in lines 14-17 should be commented out.
The classes in lines 20-23 should be uncommented
Line 144 should be commented out.
Line 146 should be uncommented
Original comment by chadopp@gmail.com
on 24 Mar 2011 at 2:24
Opps Sorry must have missed that in the install instructions :(
its ashame you cant do a check on the perl or python bindings to automate these
changes or atleast variable to pickup the version
Original comment by seven%se...@gtempaccount.com
on 24 Mar 2011 at 2:38
I've thought about doing something like that but haven't had much interest in
doing anything lately. I'm still running .22 and have no desire to upgrade for
now. Maybe one of these days. If you come up with something just send it my
way.
Original comment by chadopp@gmail.com
on 24 Mar 2011 at 2:46
Configuration issue.
Original comment by chadopp@gmail.com
on 24 Mar 2011 at 4:48
I made a selection option for mythtv version. Since I don't run mythtv .24+ I
would appreciate if you could test this out and provide feedback.
All you need to do is move your old modules/episode version to episode_hold
tar -zxvf episode_test.tar.gz under the module directory.
run
- cd /usr/share/mythtv/mythweb/modules/_shared/lang
- ./build_translation.pl
In mythweb navigate to the mythepisode configuration options. Select .24+ for
mythtv version and save. Then navigate to one of your shows and see if it
displays the episodes.
Original comment by chadopp@gmail.com
on 28 Mar 2011 at 4:09
Attachments:
Still getting these errors
Warning at /usr/share/mythweb/modules/episode/episodes.php, line 154:
!!NoTrans: Invalid argument supplied for foreach()!!
Warning at /usr/share/mythweb/modules/_shared/tmpl/default/header.php, line 16:
!!NoTrans: Cannot modify header information - headers already sent by (output
started at /usr/share/mythweb/includes/errors.php:150)!!
Original comment by seven%se...@gtempaccount.com
on 28 Mar 2011 at 11:58
Thanks for testing it. It looks like I will have to wait to finish this when I
upgrade unless someone else fixes it first. It's difficult to test without
having a working version to test against.
Original comment by chadopp@gmail.com
on 29 Mar 2011 at 2:22
Ok, I couldn't give up that easily. Last test. If this doesn't do it I will
fix when I update to .24+. Same instructions as above.
Thanks.
Original comment by chadopp@gmail.com
on 29 Mar 2011 at 3:08
Attachments:
Still the same or very similar problem
Warning at /usr/share/mythweb/modules/episode/episodes.php, line 157:
!!NoTrans: Invalid argument supplied for foreach()!!
Warning at /usr/share/mythweb/modules/_shared/tmpl/default/header.php, line 16:
!!NoTrans: Cannot modify header information - headers already sent by (output
started at /usr/share/mythweb/includes/errors.php:150)!!
Original comment by seven%se...@gtempaccount.com
on 29 Mar 2011 at 11:17
ah..I thought that might work. Just to double check, you did go into the
mythweb/mythepisode configuration options and set/save the mythtv version as
.24+. I have the default set to .23. Anyway, thanks for taking the time to
test.
Original comment by chadopp@gmail.com
on 29 Mar 2011 at 2:33
I didn't but I have now but still getting the same problem, Didn't even know
that settings page existed :)
Original comment by seven%se...@gtempaccount.com
on 29 Mar 2011 at 7:44
well that stinks. I guess I will have to wait. Since you just discovered the
config options I recommend you read the configuration options in the
installation instructions. The override settings are very useful for
particular shows.
Original comment by chadopp@gmail.com
on 30 Mar 2011 at 1:32
I find this works better
$getSubtitles = mysql_query("SELECT subtitle,starttime
FROM oldrecorded
WHERE ($titleQuery)
AND (recstatus = '-2' OR recstatus = '-3')
Group BY subtitle");
your then not relying on progamid which appears depending on listing source was
not always provided
Original comment by seven%se...@gtempaccount.com
on 1 Apr 2011 at 1:58
The problem with grouping by subtitle is that many shows have the same subtitle
for different seasons. Usually reality shows like Hell's Kitchen, American
Idol, etc. There are also a number of shows that don't have subtitles. I
believe mythtv will create a programid for each show it records.
Original comment by chadopp@gmail.com
on 1 Apr 2011 at 5:53
Ahhh ok, where does mythepisode store its episode data for each show?
I'd like to populate my programid's from the series data
Original comment by seven%se...@gtempaccount.com
on 4 Apr 2011 at 4:51
All mythepisode related data is stored under your base mythweb directory under
data/episode. For my installation on ubuntu it is under
/var/www/mythweb/data/episode.
Original comment by chadopp@gmail.com
on 4 Apr 2011 at 5:17
[deleted comment]
Whats the naming convention for the shows data?
CSI: Miami appears as Csimiami
appears to be First Letter Uppercase then all lowercase and spaces and special
characters removed....
Would this hold true for all shows?
Original comment by seven%se...@gtempaccount.com
on 11 Apr 2011 at 4:17
That is correct.
Original comment by chadopp@gmail.com
on 11 Apr 2011 at 4:30
I've created a perl script to populate any missing programids from the episode
data provided from Tvrage/ttvdb this might be helpful for others
Original comment by seven%se...@gtempaccount.com
on 20 Apr 2011 at 12:34
Attachments:
Cool...A couple of recommendations if you don't mind.
- I would either prompt for the password or pass it in as an argument so that
it doesn't have to be hardcoded
- Instead of hardcoding the path /storage/recordings/episode/shows I would
suggest either prompting for the path or passing in as an argument.
- Although you are only using episode and subtitle I would update this to make
it correct and possibly usable for future things.
col_names => 'episode,airdate,subtitle,description' should be
col_names => 'episode,airdate,subtitle,link,description'
I've never used DBI::AnyData but it's pretty cool and will use in the future.
- Some systems don't come with DBD::mysql or DBD::AnyData so I would update the
script header to let the potential user know that they need to be installed on
their system, otherwise they might get errors when attempting to run the script
and not understand why. I use Ubuntu and I have DBD::mysql, but not
DBD::AnyData
Thanks for providing the script. I will include it in my next build. One of
the things I hope to do in the future is to add the ability from the episode
page to mark an episode as recorded which would use the same data that you are
using to update the DB.
Original comment by chadopp@gmail.com
on 20 Apr 2011 at 3:13
Original comment by chadopp@gmail.com
on 15 May 2011 at 3:43
I installed mythtv .24 on another system. Here is a test version of
mythepisode that allows you to choose your version of mythtv in the config
options. you can just mv your current copy to episode_orig and extract this
version under modules.
Original comment by chadopp@gmail.com
on 28 May 2011 at 3:34
Attachments:
If you try it let me know how it goes. Thanks!
Original comment by chadopp@gmail.com
on 28 May 2011 at 3:35
Yep looks good.
Thank You
PS. I'm still looking at applying the changes you recommended in the
update_programid.pl script I think the only change left to implement is the
command line arguements which I haven't had time yet
Original comment by se...@seven.dorksville.net
on 29 May 2011 at 10:50
Let me know when you finish. I will probably create a new version of
mythepisode for release.
Original comment by chadopp@gmail.com
on 31 May 2011 at 6:22
Original issue reported on code.google.com by
seven%se...@gtempaccount.com
on 21 Mar 2011 at 11:11