| Author |
Message |
|
jkm
|
 Posted: Sat Dec 06, 2008 5:18 pm |
|
|
Joined: Wed Dec 07, 2005 2:13 am
Posts: 13
Location:
Denmark
|
|
Hi,
I have been using Knoppmyth for a while now. It is very good.
But today I suddenly lost the possibility to schedule recordings (Apparently I could schedule, but it would not go into "Upcomming Recordings" on the web).
This made me begin searching. And in the mythbackend.log I found this:
----------
2008-12-06 21:26:17.345 New DB connection, total: 3
2008-12-06 21:26:17.348 Connected to database 'mythconverg' at host: localhost
2008-12-06 21:26:17.356 Database Schema upgrade complete, unlocking.
Starting up as the master server.
ERROR: no valid capture cards are defined in the database.
Perhaps you should read the installation instructions?
----------
Then I tried mythtv-setup to enable the capturecard (again). This was not possible and I got messages like this:
----------
2008-12-06 23:43:11.832 DB Error (CaptureCard::fillSelections):
Query was:
SELECT cardid, cardtype, videodevice FROM capturecard WHERE hostname = 'mythtv' AND parentid='0'
Driver error was [2/1054]:
QMYSQL3: Unable to execute query
Database error was:
Unknown column 'parentid' in 'where clause'
----------
I am not able to add the lost capturecard. Anyone able to guide me on this one?
Thanks for a great product!
Br jkm (KnoppMyth R5F1)
|
|
| Top |
|
 |
|
slowtolearn
|
Posted: Sat Dec 06, 2008 5:24 pm |
|
|
Joined: Wed Nov 16, 2005 8:55 pm
Posts: 1381
Location:
Farmington, MI USA
|
|
| Top |
|
|
|
jkm
|
Posted: Sat Dec 06, 2008 5:37 pm |
|
|
Joined: Wed Dec 07, 2005 2:13 am
Posts: 13
Location:
Denmark
|
|
Thanks. I also thought it is the database being the problem. I have already tried to repair the DB using the link You provided, but this gave no result.
I still am not able to add the capturecard, - and I get the DB error messages.
Would an upgrade "repair" the database?
Br jkm (KnoppMyth R5F1)
|
|
| Top |
|
|
|
slowtolearn
|
Posted: Sun Dec 07, 2008 9:04 am |
|
|
Joined: Wed Nov 16, 2005 8:55 pm
Posts: 1381
Location:
Farmington, MI USA
|
I would give it a shot, can't cause any more damage 
Assuming you originally performed an auto install:
* Perform a backup (see http://knoppmyth.net/phpBB2/viewtopic.php?t=16384 - "Phase 0 - Before you upgrade" for version and backup info)
* Perform an Auto upgrade to the same version you are currently on
Hopefully that's all there is to it.
|
|
| Top |
|
|
|
jkm
|
Posted: Sun Apr 26, 2009 3:38 pm |
|
|
Joined: Wed Dec 07, 2005 2:13 am
Posts: 13
Location:
Denmark
|
|
Hi again,
I still have this problem. Tried to upgrade to same version, but without luck. Should I try to upgrade to a newer/newest version?
|
|
| Top |
|
|
|
goofee
|
Posted: Sun Apr 26, 2009 5:18 pm |
|
|
Joined: Sat Feb 03, 2007 12:52 am
Posts: 187
Location:
Manitoba, Canada
|
Quote: Unknown column 'parentid' in 'where clause'
Are you still running R5F1 as per you sig? I noticed that F27 has a 'parentid' column in the capturecard table but R5.5 does not. Did you connect a newer version of mythtv to that datadase? it looks like the database schema may have been updated. or the table got screwed up somehow. try to restore a backup made before this problem occured.
|
|
| Top |
|
|
|
jkm
|
Posted: Mon Apr 27, 2009 5:35 pm |
|
|
Joined: Wed Dec 07, 2005 2:13 am
Posts: 13
Location:
Denmark
|
|
Yes to both!
I realized I have been doing some testing with Mythtv on Ubuntu - and this gave me a lot of troubles.
I have tried a lot of threads to try to fix this again. Now I have my capturecard back, but all my old recordings are not in the database...
Is there a way to get these back?
|
|
| Top |
|
|
|
goofee
|
Posted: Mon Apr 27, 2009 7:25 pm |
|
|
Joined: Sat Feb 03, 2007 12:52 am
Posts: 187
Location:
Manitoba, Canada
|
I wish I had an easy solution. A bunch of people got bit by this when mythtv.21 became available on ubuntu. The best solution is if you have a current backup that you could restore to BEFORE the ubuntu box connected and upgraded the DB. I didn't have a current backup so just fixed the capture card table and though it was fixed. Had major troubles the next time I tried to upgrade. There are a few threads about it. http://mysettopbox.tv/phpBB2/viewtopic.php?p=114188 http://mysettopbox.tv/phpBB2/viewtopic.php?t=18480
I did a lot of work trying to repair the DB but every time I turned around something else didn't work. Mythmusic, Mytharchive, Mythweather...
From the mythtv wiki Quote: If a backup of the mythconverg database was not made before upgrading, a downgrade will likely be impossible without recreating the database (thereby losing all recordings, settings etc in the process - basically starting from scratch). See the "Miscellaneous" section of the MythTV Documentation for more details. Newer versions of MythTV often upgrade the database schema (tables & columns change structure etc) and older code is unlikely to work with newer database schemas.
If a pre-upgrade database backup is available, dump the current database and reinsert the old one.
While it may seem that MythTV works fine after downgrading versions, any data being added to the mythconverg database is likely being corrupted. And--if nothing else--new data is being inserted into the database in the old format. Therefore, running MythTV with the "upgraded" database after downgrading versions is a time-bomb. While MythTV may work fine now with the older version, it will surely fail when you upgrade later. So, the longer it is run in this broken state, the more data will need to be fixed (or the more data will be lost) upon later upgrades. Therefore, regardless of whether it seems to be working, the pre-upgrade database (from your backup) should always be reverted when downgrading MythTV versions.
I ended up doing a fresh install on a spare hard drive and copying it over my root partition, then restoring only the recordings information into the DB. I basically followed this http://knoppmyth.net/phpBB2/viewtopic.php?t=18672 this is another way of doing it. http://mysettopbox.tv/phpBB2/viewtopic.php?t=17867
Hope you have a good backup.  Good luck.
|
|
| Top |
|
|
|
cecil
|
Posted: Sun May 03, 2009 11:57 pm |
|
 |
| Site Admin |
Joined: Fri Sep 19, 2003 6:37 pm
Posts: 2659
Location:
Whittier, Ca
|
|
| Top |
|
|
View unanswered posts
View active topics
Print view
Previous topic Next topic 
LinHES Home
Board index
FAQ
Search
Login 
Register