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

[spam@…]

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

[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

[skamithi]

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