Corrupted mythtv database table [SOLVED]

Started seeing “No seektable” when trying to edit recordings – to set cut points…After investigation turned out the table recordedseek in mythconverg was corrupt. Tried to fix with this but didn’t work. mysqlcheck –databases mythconverg –auto-repair Ended up with this solution. Export database excluding bad table, purge database, rebuild and then replay export file on… Continue reading Corrupted mythtv database table [SOLVED]

Categorized as geek Tagged

Ubuntu 14.04 Mythtv box setup notes

# extra repos sudo apt-add-repository ppa:ehoover/compholio sudo add-apt-repository ppa:jon-hedgerows/get-iplayer wget -q -O – | sudo apt-key add – sudo sh -c ‘echo “deb stable main” >> /etc/apt/sources.list.d/google.list’ # update sudo apt-get update sudo apt-get dist-upgrade # essentials apt-get install openssh-server emacs # static IP address sudo emacs /etc/network/interfaces auto eth0 iface eth0 inet… Continue reading Ubuntu 14.04 Mythtv box setup notes

13.04 Mythtv with minimal ubuntu desktop upgrade

Yes… I know about mythbuntu, however I prefer to roll-my-own and use the a standard minimal ubuntu-desktop for consistency, and also use netflix / chrome from the media-centre PC. # pre-setup # – backup home, etc and mysqldump # – minimal install using mini.iso from # – install. select only open SSH server apt-get… Continue reading 13.04 Mythtv with minimal ubuntu desktop upgrade

Mythweb broken in Ubuntu 12.10 [solved]

HTTP 500s when trying to visit mythweb after upgrade to 12.10. Cause, removal of allow-call-time-pass-reference option in PHP 5.4 adam@brimstone$ tail -f /var/log/apache2/error.log [Sun Dec 02 16:59:29 2012] [error] [client] PHP Fatal error: Call-time pass-by-reference has been removed in /usr/share/mythtv/bindings/php/MythBase.php on line 50 [Sun Dec 02 17:03:53 2012] [error] [client] PHP Fatal error:… Continue reading Mythweb broken in Ubuntu 12.10 [solved]

Ubuntu 12.04 – minor updates

Slight change in syntax to mythfilldatabase, not really ubuntu 12.04 related, but that’s when the version changed. # before ubuntu 11.10 /usr/bin/mythfilldatabase –file 1 grab.xml # after ubuntu 12.04 /usr/bin/mythfilldatabase –file –sourceid 1 –xmlfile grab.xml

UK DVB-T audio IDs issue [solved]

Symptoms: Some files sourced from freeview DVB re-encoded using mencoder have silent soundtracks. Analysis: The MPEG-TS stream often contains additional sountracks, for example “audio commentaries” for blind viewers. mencoder incorrectly selects these tracks, even if switch -alang en is given. It seems mencoder will give up trying to find the requested soundtrack and go with… Continue reading UK DVB-T audio IDs issue [solved]

Categorized as geek Tagged ,

Converting mythtv mpg files

In order to use TV programs recorded by mythtv with a video editor such as Final Cut Pro some conversion needs to be done. The first step is to fix the video using mythtranscode. Raw mpeg TS files recorded by mythtv will only play with mplayer/VLC but crash most other programs mythtranscode –mpeg2 –infile input.mpg… Continue reading Converting mythtv mpg files

xmltv manip timezone fail [solved]

Fail When trying to use xmltv with mythtv, specifically tv_grab_uk_rt, with Ubuntu 10.4 the following error is seen. XMLTV requires a Date::Manip timezone of +0000 to work properly. Current Date::Manip timezone is 1. Fix Use the latest version and dependencies from debian. This is prob. simplest, although same result can be achieved with messing with… Continue reading xmltv manip timezone fail [solved]