Opened 18 years ago
Closed 18 years ago
#3848 closed defect (fixed)
SQL error
| Reported by: | anonymous | Owned by: | xris |
|---|---|---|---|
| Priority: | major | Milestone: | unknown |
| Component: | mythweb | Version: | unknown |
| Severity: | medium | Keywords: | |
| Cc: | Ticket locked: | no |
Description
When clicking on a channel name from inside the program detail window, I receive a Fatal Error saying that 'endtime' cannot be null. Full backtrace attached.
Attachments (1)
Change History (9)
comment:1 by , 18 years ago
Replying to anonymous:
When clicking on a channel name from inside the program detail window, I receive a Fatal Error saying that 'endtime' cannot be null. Full backtrace attached.
Component should be mythweb, my mistake
comment:2 by , 18 years ago
| Component: | mythtv → mythweb |
|---|---|
| Owner: | changed from to |
comment:3 by , 18 years ago
This is most likely an error in the SQL database, not mythweb. Do:
select * from program where endtime is null
To see what program has the NULL endtime. Not sure how something like this would occur. How does the frontend deal with this program (as opposed to mythweb)?
-- Joe Ripley vitaminjoe@…
comment:4 by , 18 years ago
It returns an empty set. As for the frontend, there are absolutely no problems.
comment:5 by , 18 years ago
Does this problem still exist for you? I can't reproduce it.
-- Joe Ripley vitaminjoe@…
comment:6 by , 18 years ago
Yeah, still having it, although with the discontinuation of the free zap2it service, I'm not sure how much longer I'll be using the mythweb anyway
comment:7 by , 18 years ago
fyi, this seems to have happened because for some reason the user was requesting a time in the distant past (likely from corrupt EIT data). I'll put in a simple workaround for this to prevent the error in the future.
Backtrace