View unanswered posts    View active topics

Board index Linux MythTV

All times are UTC - 6 hours





Post new topic Reply to topic  Page 1 of 1
  [ 3 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
severedspirit
 Post subject: Database Schema Issue
PostPosted: Sun Apr 06, 2008 7:21 am 
Offline
Joined: Tue Jun 20, 2006 12:25 pm
Posts: 12
Hello all,
I've been using the most recent copy of knoppmyth now with no major issues, apart from this morning when I switched on my tv to see that it had lost connection to the backend so I run mythbackend this morning to see the following error

Code:
2008-04-06 06:18:20.289 Using runtime prefix = /usr
2008-04-06 06:18:20.334 New DB connection, total: 1
2008-04-06 06:18:31.370 Connected to database 'mythconverg' at host: 192.168.1.2
2008-04-06 06:18:31.376 Current Schema Version:
2008-04-06 06:18:31.381 New DB connection, total: 2
2008-04-06 06:18:39.542 Connected to database 'mythconverg' at host: 192.168.1.2
2008-04-06 06:18:39.544 Newest Schema Version : 1160
2008-04-06 06:18:39.546 New DB connection, total: 3
2008-04-06 06:18:48.630 Connected to database 'mythconverg' at host: 192.168.1.2
2008-04-06 06:18:48.631 Setting Lock for Database Schema upgrade. If you see a l                                             ong pause here it means the Schema is already locked and is being upgraded by an                                             other Myth process.
2008-04-06 06:18:48.633 New DB connection, total: 4
2008-04-06 06:18:57.191 Connected to database 'mythconverg' at host: 192.168.1.2
2008-04-06 06:18:57.195 Told to create a NEW database schema, but the database
already has 80 tables.
If you are sure this is a good mythtv database, verify
that the settings table has the DBSchemaVer variable.

2008-04-06 06:18:57.196 Database Schema upgrade FAILED, unlocking.
2008-04-06 06:18:57.196 Couldn't upgrade database to new schema


I've been looking on google for most of the day trying to find some reasoning for this, and havent found one, I've tried repairing the database but it found no problems.
The error report informs me that I should look for the DBSchemaVer variable in the settings table which somehow doesnt exist.
I haven't done anything recently that would have caused this, any help on this will be much appreciated, thanks[/code]
Top
 Profile  
 
slowtolearn
PostPosted: Sun Apr 06, 2008 8:16 am 
Offline
Joined: Wed Nov 16, 2005 8:55 pm
Posts: 1381
Location: Farmington, MI USA
severedspirit wrote:
The error report informs me that I should look for the DBSchemaVer variable in the settings table which somehow doesnt exist.
Which doesn't exist, the settings table or the DBSchemaVer? Assuming DBSchemaVer (and R5F27), you can recreate it with
Code:
INSERT INTO settings VALUES ("DBSchemaVer", "1170", "");

severedspirit wrote:
I haven't done anything recently that would have caused this, any help on this will be much appreciated, thanks
Be sure to go through the logs, something isn't right.
Top
 Profile  
 
severedspirit
 Post subject:
PostPosted: Sun Apr 06, 2008 9:54 am 
Offline
Joined: Tue Jun 20, 2006 12:25 pm
Posts: 12
slowtolearn,
thanks for getting back to me, it was the dbschema ortion that wasnt there, it is now (thanks) but I'm still getting the same problem

Going therough the logs nothing seems to be showing any errors
Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 1 of 1
  [ 3 posts ] 


Board index Linux MythTV

All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 95 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu