[mythtv-users] Mythtv-setup Fails

John P. New spm1 at hazelden.ca
Fri May 8 20:00:49 UTC 2009


I am trying to upgrade my MythTV install (built-from-source version .20 on 
Mandriva 2006) to the latest rpm install on Mandriva 2009.1.

I am trying to migrate my mysql database to the new version, and I have used 
mysqldump as well as the mythconverg_backup.pl and ~_restore.pl scripts. 
Regardless of whether I am using the restored database or a completely empty 
one, or using the mc.sql initial database (the only differences in the terminal 
output are the number of database tables that don't exist), the program 
finishes with the same error. 

When I run mythtv-setup, I get:

------------------
2009-05-08 15:22:59.864 Using runtime prefix = /usr
2009-05-08 15:22:59.873 DPMS is active.
2009-05-08 15:22:59.874 Empty LocalHostName.
2009-05-08 15:22:59.874 Using localhost value of localhost
2009-05-08 15:22:59.879 New DB connection, total: 1
2009-05-08 15:22:59.883 Connected to database 'mythconverg' at host: localhost
2009-05-08 15:22:59.884 Closing DB connection named 'DBManager0'
2009-05-08 15:22:59.886 Primary screen 0.
2009-05-08 15:22:59.886 Connected to database 'mythconverg' at host: localhost
2009-05-08 15:22:59.887 Using screen 0, 1280x1024 at 0,0
2009-05-08 15:22:59.897 New DB connection, total: 2
2009-05-08 15:22:59.897 Connected to database 'mythconverg' at host: localhost
2009-05-08 15:22:59.898 Current Schema Version: (none)
2009-05-08 15:22:59.899 DataDirectProcessor::FixProgramIDs() -- begin
2009-05-08 15:22:59.899 New DB DataDirect connection
2009-05-08 15:22:59.900 Connected to database 'mythconverg' at host: localhost
2009-05-08 15:22:59.900 DB Error (Fixing program ids in recorded):
Query was:
UPDATE recorded SET programid=CONCAT(SUBSTRING(programid, 1, 2),                      
'00', SUBSTRING(programid, 3)) WHERE length(programid) = 12
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.recorded' doesn't exist

2009-05-08 15:22:59.901 DB Error (Clear setting):
Query was:
DELETE FROM settings WHERE value = 'BackupDBLastRunStart' AND hostname is 
NULL;
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.settings' doesn't exist

2009-05-08 15:22:59.901 DB Error (SaveSettingOnHost query failure: ):
Query was:
INSERT INTO settings (value,data,hostname ) VALUES ( 'BackupDBLastRunStart', 
'2009-05-08 15:22:59', NULL );
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.settings' doesn't exist

2009-05-08 15:22:59.902 DB Error (StorageGroup::StorageGroup()):
Query was:
SELECT DISTINCT dirname FROM storagegroup WHERE groupname = 'DB Backups' AND 
hostname = 'localhost'
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.storagegroup' doesn't exist

2009-05-08 15:22:59.902 New DB connection, total: 3
2009-05-08 15:22:59.903 Connected to database 'mythconverg' at host: localhost
2009-05-08 15:22:59.903 SG(DB Backups) Error: Directory value for Default 
Storage Group is empty.  Using hardcoded default value of '/mnt/store'
Illegal instruction
------------------

Any ideas?

Thanks in advance,

John New



More information about the mythtv-users mailing list