Opened 13 years ago

Closed 13 years ago

#2082 closed defect (fixed)

Seconds in "starttime" are being set to 00 during querys.

Reported by: spam@… Owned by: skamithi
Priority: minor Milestone: 0.20
Component: mythtv Version: head
Severity: low Keywords: starttime query
Cc: Ticket locked: no

Description

I have a recording created from a PVR-150 composite port. I bring up livetv, then select the AUX input with the "c" key the press "r" to record. After the recording is finished I then try to rename the recording but it fails to update the name.

In this log you can see the error. The seconds part of starttime is set to 00 instead of 30 in the UPDATE mysql command.

2006-07-21 13:35:39.410 MSqlQuery: SELECT maxepisodes FROM record WHERE recordid = 0 ;
2006-07-21 13:35:39.412 MSqlQuery: SELECT autoexpire FROM recorded WHERE chanid = '20460' AND starttime = '2006-07-21T11:15:30' ;
2006-07-21 13:35:41.236 MSqlQuery: SELECT icon FROM channel WHERE chanid = '20460' ;
2006-07-21 13:35:41.313 MSqlQuery: SELECT icon FROM channel WHERE chanid = '20460' ;
2006-07-21 13:35:42.905 MSqlQuery: SELECT icon FROM channel WHERE chanid = '20460' ;
2006-07-21 13:35:42.981 MSqlQuery: SELECT icon FROM channel WHERE chanid = '20460' ;
2006-07-21 13:35:53.783 MSqlQuery: UPDATE recorded SET title = 'yollaine and annie', subtitle = '' WHERE chanid = '20460' AND starttime = '20060721111500' ;
2006-07-21 13:35:53.798 MSqlQuery: SELECT recgroup, password FROM recgrouppassword WHERE password is not null AND password <> '' ;
2006-07-21 13:35:53.798 write -> 17 21      QUERY_RECORDINGS Play

Manual update on the backend.

mysql>  UPDATE recorded SET title = 'yollaine and annie', subtitle = '' WHERE chanid = '20460' AND starttime = '20060721111530' ;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Attachments (1)

rectitlechange.diff (600 bytes) - added by skamithi 13 years ago.

Download all attachments as: .zip

Change History (4)

comment:1 Changed 13 years ago by spam@…

mysql version: 5.0.22-Debian_3

gcc version: gcc (GCC) 4.1.2 20060715 (prerelease) (Debian 4.1.1-9) mythtv version:

Library API version: 0.19.20060708-1
Source code version: 10615M
Options compiled in:
 linux release using_v4l using_oss using_alsa using_hdhr using_ip_rec using_freebox using_live using_lirc using_dvb using_x11 using_xv using_xrandr using_xvmc using_xvmc_pbuffer using_frontend using_backend

Changed 13 years ago by skamithi

Attachment: rectitlechange.diff added

comment:2 Changed 13 years ago by skamithi

Owner: changed from Isaac Richards to skamithi
Status: newassigned

comment:3 Changed 13 years ago by skamithi

Resolution: fixed
Status: assignedclosed

(In [10625]) Fixes #2082. starttime seconds set to 00 when a recorded title is renamed.

Note: See TracTickets for help on using tickets.