[mythtv-users] Mythtv-setup Fails

[Michael T. Dean]

On 05/08/2009 04:00 PM, John P. New wrote:
> 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?

Pretty sure those are mainly non-errors that occur when there is no 
database schema (because of things that happen before the schema is 
created).

The "Illegal instruction" is the only real error, and that's caused by 
compiling for one architecture and running on a slightly different 
architecture (i.e. compiling for i686 and running on an i586 or something).

When compiling yourself, do /not/ specify any arch, tune, or cpu options 
to configure.  Simply use: ./configure --enable-proc-opt (and any other 
non-architecture-related options you need, like --enable-dvb, etc.).

Mike