As mentioned earlier, I have tried to run the database repair, but the problem comes back. Mythweb shows all the tables as OK. The problem seems to be alleviated if I run the backend setup and just go through the menus for the tuners (but actually change nothing, just next>next>next>finish type of navigation).
Not sure what is going on. I'm starting to debate either trying 0.26 to see if it is better or blowing away my database and starting over or both. I'd rather not have to rebuild the database as not only would I lose the ability to use the frontend to view the mpg files, but it would be tedious to have to re-setup all my settings that I have customized. -- You received this bug notification because you are a member of Mythbuntu Bug Team, which is subscribed to Mythbuntu. https://bugs.launchpad.net/bugs/1097868 Title: After upgrade, recordings table is corrupted and new recordings are not working Status in Mythbuntu, Ubuntu derivative focused upon MythTV: New Bug description: I just updated my mythbuntu and after the last update mythtv is unable to record scheduled recordings anymore. The symptom is that in the "Watch Recordings", there are 2 entries for each program that are grayed out. For example, I have Sesame Street set to record each day and only keep 2 recordings maximum for my girls. Today, when this attempted to record the 10AM showing, I ended up with two entries in the mythfrondend. Both show "Sesame Street - Elmo and Zoe's Hat Contest" on Jan 9 10:00 AM. Both are grayed out with the X by the title. Logging into the mysql database, I ran this query: select * from recorded where subtitle like 'Elmo and Zoe%'; Please see the attached "recordings.sql" file for the two results. In that table, the basename column value for the two records is 1121_20130109100001.mpg and 1121_20130109100000.mpg Looking at my /var/lib/mythtv/recordings, I see what it should be: $ ls -lh /var/lib/mythtv/recordings/1121_20130109* -rw-r--r-- 1 mythtv mythtv 1.4G Jan 9 09:05 /var/lib/mythtv/recordings/1121_20130109083000.mpg -rw-rw-rw- 1 mythtv mythtv 8.1K Jan 9 10:00 /var/lib/mythtv/recordings/1121_20130109083000.mpg.-1.100x75.png -rw-rw-rw- 1 mythtv mythtv 71K Jan 9 09:05 /var/lib/mythtv/recordings/1121_20130109083000.mpg.png -rw-r--r-- 1 mythtv mythtv 1.4G Jan 9 09:35 /var/lib/mythtv/recordings/1121_20130109090000.mpg -rw-rw-rw- 1 mythtv mythtv 13K Jan 9 10:00 /var/lib/mythtv/recordings/1121_20130109090000.mpg.-1.100x75.png -rw-rw-rw- 1 mythtv mythtv 101K Jan 9 09:35 /var/lib/mythtv/recordings/1121_20130109090000.mpg.png So, for some reason, it seems, that the record in the database is using 2013-01-09 @10 but the file is being save with @9. I'm thinking that I may have to delete my whole database and re- configure mythtv. Since I can't record programs and view them using mythfrontend anymore, this is a major issue for me. I've never had a problem like this with mythtv in the 4 or so years I have been using it. Any help would be greatly appreciated. ProblemType: Bug DistroRelease: Ubuntu 12.04 Package: mythtv-backend 2:0.25.3+fixes.20130104.010e576-0ubuntu0mythbuntu3 [origin: LP-PPA-mythbuntu-0.25] ProcVersionSignature: Ubuntu 3.2.0-35.55-generic 3.2.34 Uname: Linux 3.2.0-35-generic x86_64 NonfreeKernelModules: nvidia .var.log.mythtv.mythavtest.log: .var.log.mythtv.mythccextractor.log: .var.log.mythtv.mythjobqueue.log: .var.log.mythtv.mythlcdserver.log: .var.log.mythtv.mythmediaserver.log: .var.log.mythtv.mythshutdown.log: .var.log.mythtv.mythtranscode.log: .var.log.mythtv.mythutil.log: .var.log.mythtv.mythwelcome.log: ApportVersion: 2.0.1-0ubuntu15.1 Architecture: amd64 CrashDB: mythbuntu Date: Wed Jan 9 11:00:23 2013 InstallationMedia: Mythbuntu 12.04.1 "Precise Pangolin" - Release amd64 (20120818.1) Installed_mythtv_dbg: 0.0 MarkForUpload: True ProcEnviron: TERM=screen PATH=(custom, no user) LANG=en_US.UTF-8 SHELL=/bin/bash SourcePackage: mythtv UpgradeStatus: No upgrade log present (probably fresh install) To manage notifications about this bug go to: https://bugs.launchpad.net/mythbuntu/+bug/1097868/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~mythbuntu-bugs Post to : mythbuntu-bugs@lists.launchpad.net Unsubscribe : https://launchpad.net/~mythbuntu-bugs More help : https://help.launchpad.net/ListHelp