On 5-Nov-05, at 4:42 PM, Steve & Laurie Sanders wrote:
You don't happen to have any ideas about my database
seeming to be messed up do you? do you think the earlier version might
fix
it? Or am I looking at starting over with a new database?
This query appeared when the problem first surfaced:
UPDATE recorded SET basename =
CONCAT(chanid, '_', DATE_FORMAT(starttime,
'%Y%m%d%H%i00'), '_',
DATE_FORMAT(endtime, '%Y%m%d%H%i00'), '.nuv');
I would add a "WHERE basename IS NULL clause at the end to protect any
new recordings you've created since the upgrade. Oh, it might have to
be WHERE basename = '', I forget which worked for me but there seemed
to be a difference.
- George
_______________________________________________
mythtv-dev mailing list
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
