Home » Forums » MythDora » Updating

repeating "wants to upgrade your database schema from 1177 to 1214"

  • user warning: Table './drupal_gding/cache_filter' is marked as crashed and should be repaired query: SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '1:79b7bad6448dce161f5102d70c8d8c37' in /var/www/mythdora/html/includes/cache.inc on line 26.
  • user warning: Table './drupal_gding/cache_filter' is marked as crashed and should be repaired query: UPDATE cache_filter SET data = '<p>I upgraded from 4 to 5 today and everything seemed to go alright. When I tried to run mythTV setup from the desktop I got the mythtv wants to upgrade the database schema like I expected and it was on the pretty new blue backgroud.</p>\n<p>Then I tried to run the setup again to check that all my settings were correct and change the IP address and now everytime (5 or 6 so far) I run the setup from the desktop it just repeats the \"mythtv wants to upgrade your database schema\" windows. But this time they are back to the grey backgroud from Mythdora 4. </p>\n<p>Anyone else having this? I couldn\'t find any articles in the forums.</p>\n<p>-Andy</p>\n<p>Here\'s a sample log entry (makes the same one each time I try)</p>\n<p>2008-08-12 18:48:42.807 Using runtime prefix = /usr, libdir = /usr/lib<br />\n2008-08-12 18:48:42.816 Unable to read configuration file mysql.txt<br />\n2008-08-12 18:48:42.817 Empty LocalHostName.<br />\n2008-08-12 18:48:42.818 Using localhost value of mythserver<br />\n2008-08-12 18:48:42.835 New DB connection, total: 1<br />\n2008-08-12 18:48:42.843 Connected to database \'mythconverg\' at host: localhost<br />\n2008-08-12 18:48:42.845 Closing DB connection named \'DBManager0\'<br />\n2008-08-12 18:48:42.848 Connected to database \'mythconverg\' at host: localhost<br />\n2008-08-12 18:48:42.850 New DB connection, total: 2<br />\n2008-08-12 18:48:42.853 Connected to database \'mythconverg\' at host: localhost<br />\n2008-08-12 18:48:42.859 Current Schema Version: 1177<br />\n2008-08-12 18:48:42.869 New DB connection, total: 3<br />\n2008-08-12 18:48:42.872 Connected to database \'mythconverg\' at host: localhost<br />\n2008-08-12 18:48:42.875 Backing up database to file: /storage/recordings/mythconverg-1177-20080812184842.sql<br />\n2008-08-12 18:48:46.969 Compressing database backup file.<br />\n2008-08-12 18:48:49.527 Database Backup filename: /storage/recordings/mythconverg-1177-20080812184842.sql.gz<br />\n2008-08-12 18:48:49.528 Database Backup complete. <br />\nConsole is not interactive, cannot ask user about upgrading database schema.<br />\nUpgrading.<br />\n2008-08-12 18:48:49.538 Newest Schema Version : 1214<br />\n2008-08-12 18:48:49.542 Upgrading to schema version 1178<br />\n2008-08-12 18:48:49.621 DB Error (Performing database upgrade): <br />\nQuery was: ALTER TABLE program DROP INDEX programid; <br />\nError was: Driver error was [2/1091]:<br />\nQMYSQL3: Unable to execute query<br />\nDatabase error was:<br />\nCan\'t DROP \'programid\'; check that column/key exists</p>\n<p>new version: 1178<br />\n2008-08-12 18:48:49.625 Database Schema upgrade FAILED, unlocking.<br />\n2008-08-12 18:48:49.627 Couldn\'t upgrade database to new schema</p>\n', created = 1368986999, expire = 1369073399, headers = '', serialized = 0 WHERE cid = '1:79b7bad6448dce161f5102d70c8d8c37' in /var/www/mythdora/html/includes/cache.inc on line 109.
  • user warning: Table './drupal_gding/cache_filter' is marked as crashed and should be repaired query: SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '1:a57e294c6b9bbfd54b49869630125932' in /var/www/mythdora/html/includes/cache.inc on line 26.
  • user warning: Table './drupal_gding/cache_filter' is marked as crashed and should be repaired query: UPDATE cache_filter SET data = '<p>I found this <a href=\"http://www.mythdora.com/?q=node/3753\">http://www.mythdora.com/?q=node/3753</a> and it looks like I\'m going to be screwed even if I get Mythdora 5 running, cause I use the XBMC mythtv.pl for my frontend and that is mythtv .20 anyway to downgrade back to mythdora 4 without losing recordings?</p>\n', created = 1368986999, expire = 1369073399, headers = '', serialized = 0 WHERE cid = '1:a57e294c6b9bbfd54b49869630125932' in /var/www/mythdora/html/includes/cache.inc on line 109.
  • user warning: Table './drupal_gding/cache_filter' is marked as crashed and should be repaired query: SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '1:42ec8505f3ef466ec64be1d116f34bc0' in /var/www/mythdora/html/includes/cache.inc on line 26.
  • user warning: Table './drupal_gding/cache_filter' is marked as crashed and should be repaired query: UPDATE cache_filter SET data = '<p>\n<div class=\"quote-msg\">\n<div class=\"quote-author\"><em>bleedingtechmonkey</em> wrote:</div>\n<p>I found this <a href=\"http://www.mythdora.com/?q=node/3753\">http://www.mythdora.com/?q=node/3753</a> and it looks like I\'m going to be screwed even if I get Mythdora 5 running, cause I use the XBMC mythtv.pl for my frontend and that is mythtv .20 anyway to downgrade back to mythdora 4 without losing recordings?</p></div>\n</p>\n<p>Did you back up your database before upgrading? If you did, then I am not sure why you would lose your recordings.</p>\n', created = 1368986999, expire = 1369073399, headers = '', serialized = 0 WHERE cid = '1:42ec8505f3ef466ec64be1d116f34bc0' in /var/www/mythdora/html/includes/cache.inc on line 109.
Submitted by bleedingtechmonkey on August 12, 2008 - 5:54pm

I upgraded from 4 to 5 today and everything seemed to go alright. When I tried to run mythTV setup from the desktop I got the mythtv wants to upgrade the database schema like I expected and it was on the pretty new blue backgroud.

Then I tried to run the setup again to check that all my settings were correct and change the IP address and now everytime (5 or 6 so far) I run the setup from the desktop it just repeats the "mythtv wants to upgrade your database schema" windows. But this time they are back to the grey backgroud from Mythdora 4.

Anyone else having this? I couldn't find any articles in the forums.

-Andy

Here's a sample log entry (makes the same one each time I try)

2008-08-12 18:48:42.807 Using runtime prefix = /usr, libdir = /usr/lib
2008-08-12 18:48:42.816 Unable to read configuration file mysql.txt
2008-08-12 18:48:42.817 Empty LocalHostName.
2008-08-12 18:48:42.818 Using localhost value of mythserver
2008-08-12 18:48:42.835 New DB connection, total: 1
2008-08-12 18:48:42.843 Connected to database 'mythconverg' at host: localhost
2008-08-12 18:48:42.845 Closing DB connection named 'DBManager0'
2008-08-12 18:48:42.848 Connected to database 'mythconverg' at host: localhost
2008-08-12 18:48:42.850 New DB connection, total: 2
2008-08-12 18:48:42.853 Connected to database 'mythconverg' at host: localhost
2008-08-12 18:48:42.859 Current Schema Version: 1177
2008-08-12 18:48:42.869 New DB connection, total: 3
2008-08-12 18:48:42.872 Connected to database 'mythconverg' at host: localhost
2008-08-12 18:48:42.875 Backing up database to file: /storage/recordings/mythconverg-1177-20080812184842.sql
2008-08-12 18:48:46.969 Compressing database backup file.
2008-08-12 18:48:49.527 Database Backup filename: /storage/recordings/mythconverg-1177-20080812184842.sql.gz
2008-08-12 18:48:49.528 Database Backup complete.
Console is not interactive, cannot ask user about upgrading database schema.
Upgrading.
2008-08-12 18:48:49.538 Newest Schema Version : 1214
2008-08-12 18:48:49.542 Upgrading to schema version 1178
2008-08-12 18:48:49.621 DB Error (Performing database upgrade):
Query was: ALTER TABLE program DROP INDEX programid;
Error was: Driver error was [2/1091]:
QMYSQL3: Unable to execute query
Database error was:
Can't DROP 'programid'; check that column/key exists

new version: 1178
2008-08-12 18:48:49.625 Database Schema upgrade FAILED, unlocking.
2008-08-12 18:48:49.627 Couldn't upgrade database to new schema

‹ MD4 --> MD5: yum upgrade fails Could someone provide recent fglrx kmod for MD 5.0 kernel? ›

found a similar one now

Submitted by bleedingtechmonkey on August 12, 2008 - 5:57pm.

I found this http://www.mythdora.com/?q=node/3753 and it looks like I'm going to be screwed even if I get Mythdora 5 running, cause I use the XBMC mythtv.pl for my frontend and that is mythtv .20 anyway to downgrade back to mythdora 4 without losing recordings?

»

question

Submitted by dvpatel on August 17, 2008 - 1:43pm.

bleedingtechmonkey wrote:

I found this http://www.mythdora.com/?q=node/3753 and it looks like I'm going to be screwed even if I get Mythdora 5 running, cause I use the XBMC mythtv.pl for my frontend and that is mythtv .20 anyway to downgrade back to mythdora 4 without losing recordings?

Did you back up your database before upgrading? If you did, then I am not sure why you would lose your recordings.

»