[mythtv-users] new recordings missing basename field in recorded table

Leo Kliger lkliger at bigpond.net.au
Tue Apr 4 12:28:44 UTC 2006


Hi All,

Sorry for this long post and thanks in advance to anyone to takes the
time to read it and reply.

After some hardware trouble, subtle changes to ninemsn (and that
annoying daylight savings shift in NSW Australia!!!) I have been slowly
resolving a number of compounded issues on my mythtv box.... and I think
I am finally down to the last one. 
But it seems to be a mysql issue and I am no dba by any stretch of the
imagination.....

It's like this.

All new recordings are missing the basename entry in the recorded table,
this came to my attention because nuvexport was exiting when trying to
select episodes to encode with (BTW nuvexport used to work 100%):-

'x' outside of string in unpack at /usr/local/bin/mythtv/nuvinfo.pm line
49, <STDIN> line 2.

This seems to have only been the case in the last few weeks. I'm not
quite sure how long because I read the following thread:- 

http://www.gossamer-threads.com/lists/mythtv/users/157061?search_string=basename%20missing;#157061On

and ran:-

UPDATE recorded SET basename = 
CONCAT(chanid, '_', DATE_FORMAT(starttime, 
'%Y%m%d%H%i00'), '_', 
DATE_FORMAT(endtime, '%Y%m%d%H%i00'), '.nuv');

The above populated the basename field in the table.... but as discussed
in the thread subsequent recordings have the same problem:(....

The thing is I never upgraded anything - so I suspect that my problem is
different to the thread. Though the system went through a depressingly
unstable period due to hard drive problems....

The mythbackend is running on Ubuntu Breezy Badger:-
libmyth-0.18.1  0.18.1-5  Common library code for MythTV and add-on  mo
mythdvd         0.18.1-3  DVD add-on module for MythTV
mythtv          0.18.1-5  A personal video recorder application (cli en
mythtv-backend  0.18.1-5  A personal video recorder application (ser ve
mythtv-common   0.18.1-5  A personal video recorder application (com mo
mythtv-database 0.18.1-5  A personal video recorder application (dat ab
mythtv-frontend 0.18.1-5  A personal video recorder application (cli en
mythweb         0.18.1-3  Web interface add-on module for MythTV

And, the two frontends are running Fedora Core 4;-
mythtv-0.18.1-117.rhfc4.at
mythtv-frontend-0.18.1-117.rhfc4.at
mythtv-themes-0.18.1-117.rhfc4.at
libmyth-0.18.1-117.rhfc4.at

While I guess I could run the mysql update periodically I'd really
rather fix the problem.... If anyone has any suggestions, experienced
the same thing or wants more information please let me know.

Regards,

Leo





More information about the mythtv-users mailing list