i noticed little while mythtv setup starting screw things up. hardware setup primary , secondary backend, pchdtv-5500 tuner on primary , 2 hauppauge pvr-150s , pvr-350 on secondary. secondary still seems working fine tuners. primary backend working fine until few weeks ago. primary backend record right show, descriptive blurb in "watch recordings" screen totally different show. descriptions in "schedule recordings" screen seemed ok. noticed starting on november 1st, every recording on pchdtv-5500 wound recording @ wrong time. instead of family guy seinfield (shudder). or many of them can't find recording file @ all! now, mind secondary backend 3 tuner cards still working fine.
searching backend logs, noticed lot of entries like:
i've guessed (and google searching seems confirm) database error, i've found little in solving problem, , recommendations did find went way on head. can me fix this? can follow command line instructions if spelled out, advice "dump mysql tables , repair" needs lot more detail. understand theory of mysql databases have barely more 0 experience them , code-foo weak.code:2009-11-04 03:53:12.648 db error (change_program): query was: update program set starttime = '2009-11-06t00:00:00', endtime = '2009-11-06t00:37:00' chanid = 1111 , starttime = '2009-11-05t23:35:00' driver error [2/1062]: qmysql3: unable execute query database error was: duplicate entry '1111-2009-11-06 00:00:00-0' key 1
takers?
-will
Forum The Ubuntu Forum Community Ubuntu Official Flavours Support General Help [mythbuntu] MythTV database gone screwy
Ubuntu
Comments
Post a Comment