[mythtv-users] 0.23 to 0.24 upgrade; database wont upgrade

Richard Morton richard.e.morton at gmail.com
Fri Dec 31 09:37:52 UTC 2010


sorry, i posted to the wrong thread; reposting.
restore was completed successfully

ok, heres a log from the restore and then re-running mythbackend
--verbose database




$ mythbackend --verbose database
2010-12-31 09:32:43.601 mythbackend version: fixes/0.24 [2f3a2f8] www.mythtv.org
2010-12-31 09:32:43.601 Using runtime prefix = /usr
2010-12-31 09:32:43.601 Using configuration directory = /home/myth/.mythtv
2010-12-31 09:32:43.602 Empty LocalHostName.
2010-12-31 09:32:43.602 Using localhost value of myth-server
2010-12-31 09:32:43.602 Clearing Settings Cache.
2010-12-31 09:32:43.602 Clearing Settings Cache.
2010-12-31 09:32:43.610 New DB connection, total: 1
2010-12-31 09:32:43.613 Connected to database 'mythconverg' at host: localhost
2010-12-31 09:32:43.623 Closing DB connection named 'DBManager0'
2010-12-31 09:32:43.623 Clearing Settings Cache.
2010-12-31 09:32:43.624 Connected to database 'mythconverg' at host: localhost
2010-12-31 09:32:43.624 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'language' AND hostname = 'myth-server' <<<<
Returns 1 row(s)
2010-12-31 09:32:43.625 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'country' AND hostname = 'myth-server' <<<<
Returns 0 row(s)
2010-12-31 09:32:43.626 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'country' AND hostname IS NULL <<<< Returns 0
row(s)
2010-12-31 09:32:43.626 Current locale en_US
2010-12-31 09:32:43.626 Reading locale defaults from
/usr/share/mythtv//locales/en_us.xml
2010-12-31 09:32:43.627 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'freqtable' AND hostname = 'myth-server' <<<<
Returns 0 row(s)
2010-12-31 09:32:43.627 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'freqtable' AND hostname IS NULL <<<< Returns 1
row(s)
2010-12-31 09:32:43.628 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'iso639language0' AND hostname = 'myth-server'
<<<< Returns 1 row(s)
2010-12-31 09:32:43.629 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'iso639language1' AND hostname = 'myth-server'
<<<< Returns 1 row(s)
2010-12-31 09:32:43.629 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'tvformat' AND hostname = 'myth-server' <<<<
Returns 0 row(s)
2010-12-31 09:32:43.630 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'tvformat' AND hostname IS NULL <<<< Returns 1
row(s)
2010-12-31 09:32:43.630 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'vbiformat' AND hostname = 'myth-server' <<<<
Returns 0 row(s)
2010-12-31 09:32:43.631 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'vbiformat' AND hostname IS NULL <<<< Returns 1
row(s)
2010-12-31 09:32:43.631 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'country' AND hostname = 'myth-server' <<<<
Returns 0 row(s)
2010-12-31 09:32:43.631 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'country' AND hostname IS NULL <<<< Returns 0
row(s)
2010-12-31 09:32:43.632 MSqlQuery::exec(DBManager0) DELETE FROM
settings WHERE value = 'Country' AND hostname = 'myth-server' ;
2010-12-31 09:32:43.632 MSqlQuery::exec(DBManager0) INSERT INTO
settings (value,data,hostname) VALUES ( 'Country', 'US', 'myth-server'
);
2010-12-31 09:32:43.633 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'dateformat' AND hostname = 'myth-server' <<<<
Returns 1 row(s)
2010-12-31 09:32:43.633 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'language' AND hostname = 'myth-server' <<<<
Returns 1 row(s)
2010-12-31 09:32:43.634 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'mytharchivedateformat' AND hostname =
'myth-server' <<<< Returns 1 row(s)
2010-12-31 09:32:43.634 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'mytharchivetimeformat' AND hostname =
'myth-server' <<<< Returns 1 row(s)
2010-12-31 09:32:43.635 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'mytharchivevideoformat' AND hostname =
'myth-server' <<<< Returns 1 row(s)
2010-12-31 09:32:43.635 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'shortdateformat' AND hostname = 'myth-server'
<<<< Returns 1 row(s)
2010-12-31 09:32:43.636 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'timeformat' AND hostname = 'myth-server' <<<<
Returns 1 row(s)
2010-12-31 09:32:43.636 Enabling Settings Cache.
2010-12-31 09:32:43.636 Clearing Settings Cache.
2010-12-31 09:32:43.636 Disabling Settings Cache.
2010-12-31 09:32:43.636 Clearing Settings Cache.
2010-12-31 09:32:43.636 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'dbschemaautoupgrade' AND hostname =
'myth-server' <<<< Returns 0 row(s)
2010-12-31 09:32:43.637 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'dbschemaautoupgrade' AND hostname IS NULL <<<<
Returns 0 row(s)
2010-12-31 09:32:43.637 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'dbschemaver' AND hostname = 'myth-server' <<<<
Returns 0 row(s)
2010-12-31 09:32:43.638 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'dbschemaver' AND hostname IS NULL <<<< Returns
1 row(s)
2010-12-31 09:32:43.638 Current MythTV Schema Version (DBSchemaVer): 1254
2010-12-31 09:32:43.638 MythTV database schema is old. Waiting to see
if DB is being upgraded.
2010-12-31 09:32:44.638 New DB connection, total: 2
2010-12-31 09:32:44.639 Connected to database 'mythconverg' at host: localhost
2010-12-31 09:32:44.639 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdblastrunstart' AND hostname =
'myth-server' <<<< Returns 0 row(s)
2010-12-31 09:32:44.640 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdblastrunstart' AND hostname IS NULL
<<<< Returns 1 row(s)
2010-12-31 09:32:44.640 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdblastrunend' AND hostname =
'myth-server' <<<< Returns 0 row(s)
2010-12-31 09:32:44.640 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdblastrunend' AND hostname IS NULL <<<<
Returns 1 row(s)
2010-12-31 09:32:44.641 DBUtil::BackupInProgress(): Database backup
started at 2010-10-19T21:58:43, but has not ended yet.  The backup
started 6266042 seconds ago and should have finished by now therefore
it appears it is not running
2010-12-31 09:32:44.641 MSqlQuery::exec(DBManager0) CREATE TABLE IF
NOT EXISTS schemalock ( schemalock int(1));
2010-12-31 09:32:44.641 MSqlQuery::exec(DBManager0) LOCK TABLE schemalock WRITE;
2010-12-31 09:32:44.641 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'dbschemaver' AND hostname = 'myth-server' <<<<
Returns 0 row(s)
2010-12-31 09:32:44.642 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'dbschemaver' AND hostname IS NULL <<<< Returns
1 row(s)
2010-12-31 09:32:44.642 Current MythTV Schema Version (DBSchemaVer): 1254
2010-12-31 09:32:44.642 MSqlQuery::exec(DBManager0) UNLOCK TABLES;
2010-12-31 09:32:45.642 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdblastrunstart' AND hostname =
'myth-server' <<<< Returns 0 row(s)
2010-12-31 09:32:45.642 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdblastrunstart' AND hostname IS NULL
<<<< Returns 1 row(s)
2010-12-31 09:32:45.643 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdblastrunend' AND hostname =
'myth-server' <<<< Returns 0 row(s)
2010-12-31 09:32:45.643 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdblastrunend' AND hostname IS NULL <<<<
Returns 1 row(s)
2010-12-31 09:32:45.643 DBUtil::BackupInProgress(): Database backup
started at 2010-10-19T21:58:43, but has not ended yet.  The backup
started 6266043 seconds ago and should have finished by now therefore
it appears it is not running
2010-12-31 09:32:45.643 MSqlQuery::exec(DBManager0) CREATE TABLE IF
NOT EXISTS schemalock ( schemalock int(1));
2010-12-31 09:32:45.643 MSqlQuery::exec(DBManager0) LOCK TABLE schemalock WRITE;
2010-12-31 09:32:45.644 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'dbschemaver' AND hostname = 'myth-server' <<<<
Returns 0 row(s)
2010-12-31 09:32:45.644 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'dbschemaver' AND hostname IS NULL <<<< Returns
1 row(s)
2010-12-31 09:32:45.644 Current MythTV Schema Version (DBSchemaVer): 1254
2010-12-31 09:32:45.644 MSqlQuery::exec(DBManager0) UNLOCK TABLES;
2010-12-31 09:32:46.645 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdblastrunstart' AND hostname =
'myth-server' <<<< Returns 0 row(s)
2010-12-31 09:32:46.645 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdblastrunstart' AND hostname IS NULL
<<<< Returns 1 row(s)
2010-12-31 09:32:46.645 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdblastrunend' AND hostname =
'myth-server' <<<< Returns 0 row(s)
2010-12-31 09:32:46.645 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdblastrunend' AND hostname IS NULL <<<<
Returns 1 row(s)
2010-12-31 09:32:46.645 DBUtil::BackupInProgress(): Database backup
started at 2010-10-19T21:58:43, but has not ended yet.  The backup
started 6266044 seconds ago and should have finished by now therefore
it appears it is not running
2010-12-31 09:32:46.646 MSqlQuery::exec(DBManager0) CREATE TABLE IF
NOT EXISTS schemalock ( schemalock int(1));
2010-12-31 09:32:46.646 MSqlQuery::exec(DBManager0) LOCK TABLE schemalock WRITE;
2010-12-31 09:32:46.646 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'dbschemaver' AND hostname = 'myth-server' <<<<
Returns 0 row(s)
2010-12-31 09:32:46.646 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'dbschemaver' AND hostname IS NULL <<<< Returns
1 row(s)
2010-12-31 09:32:46.646 Current MythTV Schema Version (DBSchemaVer): 1254
2010-12-31 09:32:46.646 MSqlQuery::exec(DBManager0) UNLOCK TABLES;
2010-12-31 09:32:47.647 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdblastrunstart' AND hostname =
'myth-server' <<<< Returns 0 row(s)
2010-12-31 09:32:47.647 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdblastrunstart' AND hostname IS NULL
<<<< Returns 1 row(s)
2010-12-31 09:32:47.648 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdblastrunend' AND hostname =
'myth-server' <<<< Returns 0 row(s)
2010-12-31 09:32:47.648 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdblastrunend' AND hostname IS NULL <<<<
Returns 1 row(s)
2010-12-31 09:32:47.648 DBUtil::BackupInProgress(): Database backup
started at 2010-10-19T21:58:43, but has not ended yet.  The backup
started 6266045 seconds ago and should have finished by now therefore
it appears it is not running
2010-12-31 09:32:47.648 MSqlQuery::exec(DBManager0) CREATE TABLE IF
NOT EXISTS schemalock ( schemalock int(1));
2010-12-31 09:32:47.648 MSqlQuery::exec(DBManager0) LOCK TABLE schemalock WRITE;
2010-12-31 09:32:47.649 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'dbschemaver' AND hostname = 'myth-server' <<<<
Returns 0 row(s)
2010-12-31 09:32:47.649 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'dbschemaver' AND hostname IS NULL <<<< Returns
1 row(s)
2010-12-31 09:32:47.649 Current MythTV Schema Version (DBSchemaVer): 1254
2010-12-31 09:32:47.649 MSqlQuery::exec(DBManager0) UNLOCK TABLES;
2010-12-31 09:32:48.649 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdblastrunstart' AND hostname =
'myth-server' <<<< Returns 0 row(s)
2010-12-31 09:32:48.650 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdblastrunstart' AND hostname IS NULL
<<<< Returns 1 row(s)
2010-12-31 09:32:48.650 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdblastrunend' AND hostname =
'myth-server' <<<< Returns 0 row(s)
2010-12-31 09:32:48.650 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdblastrunend' AND hostname IS NULL <<<<
Returns 1 row(s)
2010-12-31 09:32:48.650 DBUtil::BackupInProgress(): Database backup
started at 2010-10-19T21:58:43, but has not ended yet.  The backup
started 6266046 seconds ago and should have finished by now therefore
it appears it is not running
2010-12-31 09:32:48.651 MSqlQuery::exec(DBManager0) CREATE TABLE IF
NOT EXISTS schemalock ( schemalock int(1));
2010-12-31 09:32:48.651 MSqlQuery::exec(DBManager0) LOCK TABLE schemalock WRITE;
2010-12-31 09:32:48.651 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'dbschemaver' AND hostname = 'myth-server' <<<<
Returns 0 row(s)
2010-12-31 09:32:48.651 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'dbschemaver' AND hostname IS NULL <<<< Returns
1 row(s)
2010-12-31 09:32:48.651 Current MythTV Schema Version (DBSchemaVer): 1254
2010-12-31 09:32:48.651 MSqlQuery::exec(DBManager0) UNLOCK TABLES;
2010-12-31 09:32:48.651 Timed out waiting.
2010-12-31 09:32:48.652 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'disableautomaticbackup' AND hostname =
'myth-server' <<<< Returns 0 row(s)
2010-12-31 09:32:48.652 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'disableautomaticbackup' AND hostname IS NULL
<<<< Returns 1 row(s)
2010-12-31 09:32:48.655 MSqlQuery::exec(DBManager0) SELECT CONCAT('`',
INFORMATION_SCHEMA.TABLES.TABLE_SCHEMA,               '`.`',
INFORMATION_SCHEMA.TABLES.TABLE_NAME,               '`') AS
`TABLE_NAME`   FROM INFORMATION_SCHEMA.TABLES  WHERE
INFORMATION_SCHEMA.TABLES.TABLE_SCHEMA = DATABASE()    AND
INFORMATION_SCHEMA.TABLES.TABLE_TYPE = 'BASE TABLE' <<<< Returns 110
row(s)
2010-12-31 09:32:48.655 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'databasebackupscript' AND hostname =
'myth-server' <<<< Returns 0 row(s)
2010-12-31 09:32:48.656 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'databasebackupscript' AND hostname IS NULL
<<<< Returns 0 row(s)
2010-12-31 09:32:48.656 MSqlQuery::exec(DBManager1) DELETE FROM
settings WHERE value = 'BackupDBLastRunStart' AND hostname is NULL;
2010-12-31 09:32:48.657 MSqlQuery::exec(DBManager1) INSERT INTO
settings (value,data ) VALUES ( 'BackupDBLastRunStart', '2010-12-31
09:32:48' );
2010-12-31 09:32:48.657 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'dbschemaver' AND hostname = 'myth-server' <<<<
Returns 0 row(s)
2010-12-31 09:32:48.658 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'dbschemaver' AND hostname IS NULL <<<< Returns
1 row(s)
2010-12-31 09:32:48.658 MSqlQuery::exec(DBManager1) SELECT DISTINCT
dirname FROM storagegroup WHERE groupname = 'DB Backups' AND hostname
= 'myth-server' <<<< Returns 1 row(s)
2010-12-31 09:32:48.659 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdbscriptargs' AND hostname =
'myth-server' <<<< Returns 0 row(s)
2010-12-31 09:32:48.659 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'backupdbscriptargs' AND hostname IS NULL <<<<
Returns 0 row(s)
2010-12-31 09:32:48.660 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'dbschemaver' AND hostname = 'myth-server' <<<<
Returns 0 row(s)
2010-12-31 09:32:48.660 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'dbschemaver' AND hostname IS NULL <<<< Returns
1 row(s)
2010-12-31 09:32:48.660 Backing up database with script:
'/usr/share/mythtv/mythconverg_backup.pl'
2010-12-31 09:33:06.474 Database Backup complete.
2010-12-31 09:33:06.475 Backed up database to file:
'/var/lib/mythtv/backups/mythconverg-1254-20101231093248.sql.gz'
2010-12-31 09:33:06.476 MSqlQuery::exec(DBManager1) DELETE FROM
settings WHERE value = 'BackupDBLastRunEnd' AND hostname is NULL;
2010-12-31 09:33:06.476 MSqlQuery::exec(DBManager1) INSERT INTO
settings (value,data ) VALUES ( 'BackupDBLastRunEnd', '2010-12-31
09:33:06' );
2010-12-31 09:33:06.476 MSqlQuery::exec(DBManager0) DELETE FROM
housekeeping WHERE tag = 'BackupDB' ;
2010-12-31 09:33:06.477 MSqlQuery::exec(DBManager0) INSERT INTO
housekeeping(tag,lastrun) values('BackupDB' ,now()) ;
2010-12-31 09:33:06.489 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'dbmsversionoverride' AND hostname =
'myth-server' <<<< Returns 0 row(s)
2010-12-31 09:33:06.489 MSqlQuery::exec(DBManager1) SELECT data FROM
settings WHERE value = 'dbmsversionoverride' AND hostname IS NULL <<<<
Returns 0 row(s)
2010-12-31 09:33:06.490 MSqlQuery::exec(DBManager0) SELECT VERSION();
<<<< Returns 1 row(s)
2010-12-31 09:33:06.490 Console is non-interactive, can't prompt user...
2010-12-31 09:33:06.490 Upgrading.
2010-12-31 09:33:06.490 MSqlQuery::exec(DBManager1) ALTER DATABASE
mythconverg DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
2010-12-31 09:33:06.490 Newest MythTV Schema Version : 1264
2010-12-31 09:33:06.491 MSqlQuery::exec(DBManager1) CREATE TABLE IF
NOT EXISTS schemalock ( schemalock int(1));
2010-12-31 09:33:06.491 MSqlQuery::exec(DBManager1) LOCK TABLE schemalock WRITE;
2010-12-31 09:33:06.491 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'dbschemaver' AND hostname = 'myth-server' <<<<
Returns 0 row(s)
2010-12-31 09:33:06.492 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'dbschemaver' AND hostname IS NULL <<<< Returns
1 row(s)
2010-12-31 09:33:06.494 MSqlQuery::exec(DBManager0) SELECT CONCAT('`',
INFORMATION_SCHEMA.TABLES.TABLE_SCHEMA,               '`.`',
INFORMATION_SCHEMA.TABLES.TABLE_NAME,               '`') AS
`TABLE_NAME`   FROM INFORMATION_SCHEMA.TABLES  WHERE
INFORMATION_SCHEMA.TABLES.TABLE_SCHEMA = DATABASE()    AND
INFORMATION_SCHEMA.TABLES.TABLE_TYPE = 'BASE TABLE' <<<< Returns 110
row(s)
2010-12-31 09:33:06.494 Upgrading to MythTV schema version 1255
2010-12-31 09:33:06.595 MSqlQuery::exec(DBManager0) ALTER TABLE
cardinput DROP COLUMN shareable;
2010-12-31 09:33:06.595 New DB connection, total: 3
2010-12-31 09:33:06.596 Connected to database 'mythconverg' at host: localhost
2010-12-31 09:33:06.596 MSqlQuery::exec(DBManager2) DELETE FROM
settings WHERE value='DBSchemaVer';
2010-12-31 09:33:06.596 MSqlQuery::exec(DBManager2) INSERT INTO
settings (value, data, hostname) VALUES ('DBSchemaVer', 1255, NULL);
2010-12-31 09:33:06.597 Upgrading to MythTV schema version 1256
2010-12-31 09:33:06.597 MSqlQuery::exec(DBManager2) INSERT INTO
keybindings (SELECT 'Main Menu', 'EXIT', 'System Exit', (CASE data
WHEN '1' THEN 'Ctrl+Esc' WHEN '2' THEN 'Meta+Esc' WHEN '3' THEN
'Alt+Esc' WHEN '4' THEN 'Esc' ELSE '' END), hostname FROM settings
WHERE value = 'AllowQuitShutdown' LIMIT 1) ON DUPLICATE KEY UPDATE
keylist = VALUES(keylist);
2010-12-31 09:33:06.597 MSqlQuery::exec(DBManager0) DELETE FROM
settings WHERE value='DBSchemaVer';
2010-12-31 09:33:06.598 MSqlQuery::exec(DBManager0) INSERT INTO
settings (value, data, hostname) VALUES ('DBSchemaVer', 1256, NULL);
2010-12-31 09:33:06.598 Upgrading to MythTV schema version 1257
2010-12-31 09:33:06.729 MSqlQuery::exec(DBManager0) ALTER TABLE record
DROP COLUMN tsdefault;
2010-12-31 09:33:06.730 MSqlQuery::exec(DBManager2) DELETE FROM
settings WHERE value='DBSchemaVer';
2010-12-31 09:33:06.730 MSqlQuery::exec(DBManager2) INSERT INTO
settings (value, data, hostname) VALUES ('DBSchemaVer', 1257, NULL);
2010-12-31 09:33:06.730 Upgrading to MythTV schema version 1258
2010-12-31 09:33:06.730 MSqlQuery::exec(DBManager2) CREATE TABLE
internetcontent ( name VARCHAR(255) NOT NULL,  thumbnail VARCHAR(255),
 type SMALLINT(3) NOT NULL,  author VARCHAR(128) NOT NULL,
description TEXT NOT NULL,  commandline TEXT NOT NULL,  version DOUBLE
NOT NULL,  updated TIMESTAMP NOT NULL,  search BOOL NOT NULL,  tree
BOOL NOT NULL,  podcast BOOL NOT NULL,  download BOOL NOT NULL,  host
VARCHAR(128));
2010-12-31 09:33:06.730 DB Error (Performing database upgrade):
Query was: CREATE TABLE internetcontent ( name VARCHAR(255) NOT NULL,
thumbnail VARCHAR(255),  type SMALLINT(3) NOT NULL,  author
VARCHAR(128) NOT NULL,  description TEXT NOT NULL,  commandline TEXT
NOT NULL,  version DOUBLE NOT NULL,  updated TIMESTAMP NOT NULL,
search BOOL NOT NULL,  tree BOOL NOT NULL,  podcast BOOL NOT NULL,
download BOOL NOT NULL,  host  VARCHAR(128));
Error was: Driver error was [2/1050]:
QMYSQL: Unable to execute query
Database error was:
Table 'internetcontent' already exists

new version: 1258
2010-12-31 09:33:06.730 Database Schema upgrade FAILED, unlocking.
2010-12-31 09:33:06.730 MSqlQuery::exec(DBManager1) UNLOCK TABLES;
2010-12-31 09:33:06.730 Enabling Settings Cache.
2010-12-31 09:33:06.730 Clearing Settings Cache.
2010-12-31 09:33:06.731 Couldn't upgrade database to new schema
2010-12-31 09:33:06.731 Destroying MythDBPrivate
myth at myth-server:~$


More information about the mythtv-users mailing list