Opened 8 years ago

Closed 8 years ago

Last modified 8 years ago

#12878 closed Bug Report - General (fixed)

Activate a show that was set to never record.

Reported by: matt@… Owned by: Stuart Auchterlonie
Priority: minor Milestone: 0.28.1
Component: Plugin - MythWeb Version: 0.28.0
Severity: medium Keywords:
Cc: Ticket locked: no

Description

I accedently marked an episode to never record and when I select activate it throws the error

!NoTrans: SQL Error: Incorrect datetime value: '1473904800' for column 'starttime' at row 1 #1292!!

Attached the full error.

Attachments (1)

Error.txt (13.1 KB) - added by anonymous 8 years ago.

Download all attachments as: .zip

Change History (5)

Changed 8 years ago by anonymous

Attachment: Error.txt added

comment:1 Changed 8 years ago by Stuart Auchterlonie

Component: MythTV - GeneralPlugin - MythWeb
Milestone: unknown0.28.1
Owner: set to Stuart Auchterlonie

This looks a bit different to the other recently reported errors in mythweb. Reproduced it too in my first attempt

Last edited 8 years ago by Stuart Auchterlonie (previous) (diff)

comment:2 Changed 8 years ago by Stuart Auchterlonie

This seems to occur when there is no oldrecorded record for the program being activated.

UPDATE: Well there is an oldrecorded record for the program, it's just offset by the current offset to UTC

Workaround is to use "default" rather than "activate"

Last edited 8 years ago by Stuart Auchterlonie (previous) (diff)

comment:3 Changed 8 years ago by Stuart Auchterlonie <stuarta@…>

Resolution: fixed
Status: newclosed

In 07441af9ee7bd5371323309b32456f510b7106ec/mythweb:

Fixes #12878. Use mythtv time, not unixtime to 'activate' a recording

comment:4 Changed 8 years ago by Stuart Auchterlonie <stuarta@…>

In 32147cf4ce6ea55946c11135ebc81552d71c919c/mythweb:

Fixes #12878. Use mythtv time, not unixtime to 'activate' a recording

(cherry picked from commit 07441af9ee7bd5371323309b32456f510b7106ec)

Note: See TracTickets for help on using tickets.