| LinHES Forums http://forums.linhes.org/ |
|
| Database Schema Issue http://forums.linhes.org/viewtopic.php?f=17&t=18143 |
Page 1 of 1 |
| Author: | severedspirit [ Sun Apr 06, 2008 7:21 am ] |
| Post subject: | Database Schema Issue |
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] |
|
| Author: | slowtolearn [ Sun Apr 06, 2008 8:16 am ] |
| Post subject: | Re: Database Schema Issue |
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.
|
|
| Author: | severedspirit [ Sun Apr 06, 2008 9:54 am ] |
| Post subject: | |
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 |
|
| Page 1 of 1 | All times are UTC - 6 hours |
| Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |
|