I've been running 0.27 on Ubuntu 14.04 for some time without problems. I was thinking to upgrade to 0.28 so went to check on my automatic database backups. They were all there - but just 807 Bytes which looked suspicious so ran a manual backup and found it crashed due to missing pidcache table. Checking the database in Mythweb also gives:
Can't find file: 'pidcache' (errno: 2)
I ran Repair Tables from Mythweb but no fix. I've no idea what pidcache is for or how I might fix it. I have no clue as far as mysql goes!
I repeat - MythTV works fine despite this error. Does it matter? Am I going to hit problems if I try to upgrade to 0.28?
Whatever, I'd like to fix this as I don't like having a working backup after the grief Ubuntu and MythTV has given me in the past!
backup crashing - missing pidcache table ?
Moderator: Forum Moderators
Re: backup crashing - missing pidcache table ?
If you are competent with Mysql you could recreate the table using the info here
https://github.com/MythTV/mythtv/blob/m ... .cpp#L3929
https://github.com/MythTV/mythtv/blob/m ... .cpp#L3929