[mythtv] can't delete recordings

[Cougar]

On Mon, 28 Aug 2006, Cougar wrote:

> When I try to delete recording from view recordings menu I get such error:
> 
> 2006-08-27 21:11:18.102 MSqlQuery: UPDATE recorded SET deletepending = 1 WHERE chanid = '21520' AND starttime = '2006-08-27T00:39:00' ;
> 2006-08-27 21:11:21.133 MSqlQuery: SELECT recorded.chanid,starttime,endtime,title, subtitle,description,channel.channum, channel.callsign,channel.name,channel.commfree, channel.outputfilters,seriesid,programid,filesize, lastmodified,stars,previouslyshown,originalairdate, hostname,recordid,transcoder,playgroup, recorded.recpriority,progstart,progend,basename,recgroup FROM recorded LEFT JOIN channel ON recorded.chanid = channel.chanid WHERE recorded.chanid = '21520' AND starttime = '2006-08-27T00:39:00' ;
> 2006-08-27 21:11:21.134 ERROR retrieving program info when trying to delete program for chanid 21520 recorded at Sun Aug 27 00:39:00 2006. Recording will NOT be deleted.
> 2006-08-27 21:11:21.275 MSqlQuery: INSERT INTO mythlog (module, priority, logdate, host, message, details) values ('mythbackend', 3, now(), 'mythfrontend', 'Delete Recording', 'Unable to retrieve program info for chanid 21520 at Sun Aug 27 00:39:00 2006. Program will NOT be deleted.' );
> 2006-08-27 21:11:21.321 MSqlQuery: SELECT logid FROM mythlog WHERE module= 'mythbackend' ORDER BY logdate ASC ;
> 2006-08-27 21:11:21.381 MSqlQuery: DELETE FROM mythlog WHERE logid= 82349 ;
> 2006-08-27 21:11:21.382 mythbackend: Delete Recording: Unable to retrieve program info for chanid 21520 at Sun Aug 27 00:39:00 2006. Program will NOT be deleted.
> 
> This happens with two different recordings right now. Both are recorded 
> with slave backend to the common NFS storage. Any idea what is wrong?
> I run SVN 10931 at the moment.

Fixed now. The reason was wrong timezone in slave backend (actually no 
timezone at all but UTC). After setting up right timezone it was possible 
to delete all old recordings. So, slave backend and master backend MUST be 
configured in the same timezone. Somebody may put it into the 
documentation.

-- 
Cougar