You are not logged in.
Hey Guys.
Just updated my MythTV Machine - and what a hell. !!! In the end i decided it was much easiere just to install the machine fresh from mew.
Now I'm about to get pretty tired - The script placed in /usr/share/mythtv/mc.sql is empty???
Downloaded the package directly from MythTv.org - and just took the script from there - But Now I'm not able to add the Hauppage PVR-500 in MythTV setup??
The script I got from the package:
CREATE DATABASE mythconverg;
GRANT ALL ON mythconverg.* TO mythtv at localhost IDENTIFIED BY "mythtv";
FLUSH PRIVILEGES;
GRANT CREATE TEMPORARY TABLES ON mythconverg.* TO mythtv at localhost IDENTIFIED BY "mythtv";
FLUSH PRIVILEGES;
But there's seems to be a lot of tables missing - have anyone the correct script somewhere - caurse I cannot not get it by installing using pacman - and the script from mythTV.org doesn't seems to fit - No matter what - It seems like I don't am allowed to run the things I should ! But that haven't been a problem before !!
Even though I add the card - the mythtv-setup screen does not catch it - and then I back to the beginning!
Hoe someone could help there !
Just getting better .... All the time
Offline
well when i run mythtv-setup - ill get this from my konaol:
# mythtv-setup
2007-06-12 07:59:12.323 Using runtime prefix = /usr
2007-06-12 07:59:12.330 DPMS is active.
2007-06-12 07:59:12.354 New DB connection, total: 1
2007-06-12 07:59:12.358 Connected to database 'mythconverg' at host: localhost
2007-06-12 07:59:12.360 Total desktop dim: 1024x768, with 1 screen[s].
2007-06-12 07:59:12.362 Using screen 0, 1024x768 at 0,0
2007-06-12 07:59:12.366 Current Schema Version:
2007-06-12 07:59:12.367 Newest Schema Version : 1160
2007-06-12 07:59:12.367 New DB connection, total: 2
2007-06-12 07:59:12.368 Connected to database 'mythconverg' at host: localhost
2007-06-12 07:59:12.368 Setting Lock for Database Schema upgrade. If you see a long pause here it means the Schema is already locked and is being upgraded by another Myth process.
2007-06-12 07:59:12.369 New DB connection, total: 3
2007-06-12 07:59:12.369 Connected to database 'mythconverg' at host: localhost
2007-06-12 07:59:12.370 Told to create a NEW database schema, but the database
already has 2 tables.
If you are sure this is a good mythtv database, verify
that the settings table has the DBSchemaVer variable.
2007-06-12 07:59:12.370 Database Schema upgrade FAILED, unlocking.
2007-06-12 07:59:12.376 Total desktop dim: 1024x768, with 1 screen[s].
2007-06-12 07:59:12.377 Using screen 0, 1024x768 at 0,0
2007-06-12 07:59:12.403 Switching to square mode (G.A.N.T.)
2007-06-12 07:59:12.498 Using the Qt painter
2007-06-12 07:59:12.749 DB Error (Insert Keybinding):
Query was:
INSERT INTO keybindings (context, action, description, keylist, hostname) VALUES ( 'Global', 'UP', 'Up Arrow', 'Up', 'myth' );
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.keybindings' doesn't exist
2007-06-12 07:59:12.750 DB Error (Insert Keybinding):
Query was:
INSERT INTO keybindings (context, action, description, keylist, hostname) VALUES ( 'Global', 'DOWN', 'Down Arrow', 'Down', 'myth' );
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.keybindings' doesn't exist
2007-06-12 07:59:12.751 DB Error (Insert Keybinding):
Query was:
INSERT INTO keybindings (context, action, description, keylist, hostname) VALUES ( 'Global', 'LEFT', 'Left Arrow', 'Left', 'myth' );
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.keybindings' doesn't exist
2007-06-12 07:59:12.752 DB Error (Insert Keybinding):
Query was:
INSERT INTO keybindings (context, action, description, keylist, hostname) VALUES ( 'Global', 'RIGHT', 'Right Arrow', 'Right', 'myth' );
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.keybindings' doesn't exist
2007-06-12 07:59:12.752 DB Error (Insert Keybinding):
Query was:
INSERT INTO keybindings (context, action, description, keylist, hostname) VALUES ( 'Global', 'SELECT', 'Select', 'Return,Enter,Space', 'myth' );
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.keybindings' doesn't exist
2007-06-12 07:59:12.753 DB Error (Insert Keybinding):
Query was:
INSERT INTO keybindings (context, action, description, keylist, hostname) VALUES ( 'Global', 'ESCAPE', 'Escape', 'Esc', 'myth' );
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.keybindings' doesn't exist
2007-06-12 07:59:12.753 DB Error (Insert Keybinding):
Query was:
INSERT INTO keybindings (context, action, description, keylist, hostname) VALUES ( 'Global', 'MENU', 'Pop-up menu', 'M', 'myth' );
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.keybindings' doesn't exist
2007-06-12 07:59:12.754 DB Error (Insert Keybinding):
Query was:
INSERT INTO keybindings (context, action, description, keylist, hostname) VALUES ( 'Global', 'INFO', 'More information', 'I', 'myth' );
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.keybindings' doesn't exist
2007-06-12 07:59:12.755 DB Error (Insert Keybinding):
Query was:
INSERT INTO keybindings (context, action, description, keylist, hostname) VALUES ( 'Global', 'PAGEUP', 'Page Up', 'PgUp', 'myth' );
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.keybindings' doesn't exist
2007-06-12 07:59:12.756 DB Error (Insert Keybinding):
Query was:
INSERT INTO keybindings (context, action, description, keylist, hostname) VALUES ( 'Global', 'PAGEDOWN', 'Page Down', 'PgDown', 'myth' );
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.keybindings' doesn't exist
2007-06-12 07:59:12.756 DB Error (Insert Keybinding):
Query was:
INSERT INTO keybindings (context, action, description, keylist, hostname) VALUES ( 'Global', 'PREVVIEW', 'Previous View', 'Home', 'myth' );
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.keybindings' doesn't exist
2007-06-12 07:59:12.757 DB Error (Insert Keybinding):
Query was:
INSERT INTO keybindings (context, action, description, keylist, hostname) VALUES ( 'Global', 'NEXTVIEW', 'Next View', 'End', 'myth' );
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.keybindings' doesn't exist
2007-06-12 07:59:12.758 DB Error (Insert Keybinding):
Query was:
INSERT INTO keybindings (context, action, description, keylist, hostname) VALUES ( 'Global', 'HELP', 'Help', 'F1', 'myth' );
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.keybindings' doesn't exist
2007-06-12 07:59:12.758 DB Error (Insert Keybinding):
Query was:
INSERT INTO keybindings (context, action, description, keylist, hostname) VALUES ( 'Global', 'EJECT', 'Eject Removable Media', '', 'myth' );
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.keybindings' doesn't exist
2007-06-12 07:59:12.760 DB Error (Insert Keybinding):
Query was:
INSERT INTO keybindings (context, action, description, keylist, hostname) VALUES ( 'Global', '0', '0', '0', 'myth' );
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.keybindings' doesn't exist
2007-06-12 07:59:12.760 DB Error (Insert Keybinding):
Query was:
INSERT INTO keybindings (context, action, description, keylist, hostname) VALUES ( 'Global', '1', '1', '1', 'myth' );
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.keybindings' doesn't exist
2007-06-12 07:59:12.761 DB Error (Insert Keybinding):
Query was:
INSERT INTO keybindings (context, action, description, keylist, hostname) VALUES ( 'Global', '2', '2', '2', 'myth' );
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.keybindings' doesn't exist
2007-06-12 07:59:12.762 DB Error (Insert Keybinding):
Query was:
INSERT INTO keybindings (context, action, description, keylist, hostname) VALUES ( 'Global', '3', '3', '3', 'myth' );
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.keybindings' doesn't exist
2007-06-12 07:59:12.762 DB Error (Insert Keybinding):
Query was:
INSERT INTO keybindings (context, action, description, keylist, hostname) VALUES ( 'Global', '4', '4', '4', 'myth' );
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.keybindings' doesn't exist
2007-06-12 07:59:12.763 DB Error (Insert Keybinding):
Query was:
INSERT INTO keybindings (context, action, description, keylist, hostname) VALUES ( 'Global', '5', '5', '5', 'myth' );
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.keybindings' doesn't exist
2007-06-12 07:59:12.764 DB Error (Insert Keybinding):
Query was:
INSERT INTO keybindings (context, action, description, keylist, hostname) VALUES ( 'Global', '6', '6', '6', 'myth' );
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.keybindings' doesn't exist
2007-06-12 07:59:12.764 DB Error (Insert Keybinding):
Query was:
INSERT INTO keybindings (context, action, description, keylist, hostname) VALUES ( 'Global', '7', '7', '7', 'myth' );
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.keybindings' doesn't exist
2007-06-12 07:59:12.765 DB Error (Insert Keybinding):
Query was:
INSERT INTO keybindings (context, action, description, keylist, hostname) VALUES ( 'Global', '8', '8', '8', 'myth' );
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.keybindings' doesn't exist
2007-06-12 07:59:12.765 DB Error (Insert Keybinding):
Query was:
INSERT INTO keybindings (context, action, description, keylist, hostname) VALUES ( 'Global', '9', '9', '9', 'myth' );
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.keybindings' doesn't exist
2007-06-12 07:59:12.767 Joystick disabled.
mythtv: could not connect to socket
mythtv: Ingen sådan fil eller filkatalog
lirc_init failed for mythtv, see preceding messages
2007-06-12 07:59:13.153 Loading from: /usr/share/mythtv/themes/G.A.N.T./base.xml
2007-06-12 07:59:13.215 Loading from: /usr/share/mythtv/themes/default/base.xml
2007-06-12 07:59:14.962 DB Error (Clear setting):
Query was:
DELETE FROM settings WHERE value = 'Language' AND hostname = 'myth' ;
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.settings' doesn't exist
2007-06-12 07:59:14.963 DB Error (Save new setting on host):
Query was:
INSERT INTO settings ( value, data, hostname ) VALUES ( 'Language', 'DK', 'myth' );
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.settings' doesn't exist
2007-06-12 07:59:14.964 DB Error (Clear setting):
Query was:
DELETE FROM settings WHERE value = 'Language' AND hostname = 'myth' ;
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.settings' doesn't exist
2007-06-12 07:59:14.964 DB Error (Save new setting on host):
Query was:
INSERT INTO settings ( value, data, hostname ) VALUES ( 'Language', 'DK', 'myth' );
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.settings' doesn't exist
2007-06-12 07:59:15.023 DB Error (Insert Keybinding):
Query was:
INSERT INTO keybindings (context, action, description, keylist, hostname) VALUES ( 'qt', 'DELETE', 'Delete', 'D', 'myth' );
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.keybindings' doesn't exist
2007-06-12 07:59:15.024 DB Error (Insert Keybinding):
Query was:
INSERT INTO keybindings (context, action, description, keylist, hostname) VALUES ( 'qt', 'EDIT', 'Edit', 'E', 'myth' );
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.keybindings' doesn't exist
2007-06-12 07:59:39.330 XMLParse::LoadTheme using /usr/share/mythtv/themes/default/keyboard/dk_ui.xml
2007-06-12 08:00:31.725 DB Error (simpledbstorage update):
Query was:
No error type from QSqlError? Strange...
2007-06-12 08:00:31.726 DB Error (simpledbstorage update):
Query was:
No error type from QSqlError? Strange...
2007-06-12 08:00:31.748 DB Error (simpledbstorage update):
Query was:
No error type from QSqlError? Strange...
2007-06-12 08:00:33.024 DB Error (CaptureCard::fillSelections):
Query was:
SELECT cardid, cardtype, videodevice FROM capturecard WHERE hostname = 'myth' AND parentid='0'
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.capturecard' doesn't exist
2007-06-12 08:00:34.018 DB Error (CardUtil::GetCardID()):
Query was:
SELECT cardid FROM capturecard WHERE videodevice = '/dev/v4l/video0' AND hostname = 'myth'
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.capturecard' doesn't exist
2007-06-12 08:00:34.020 DB Error (CardUtil::GetCardID()):
Query was:
SELECT cardid FROM capturecard WHERE videodevice = '/dev/v4l/video0' AND hostname = 'myth'
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.capturecard' doesn't exist
2007-06-12 08:00:34.022 DB Error (CardUtil::GetCardID()):
Query was:
SELECT cardid FROM capturecard WHERE videodevice = '/dev/v4l/video0' AND hostname = 'myth'
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.capturecard' doesn't exist
2007-06-12 08:00:34.025 DB Error (DiSEqCDevTree::Load):
Query was:
SELECT diseqcid FROM capturecard WHERE cardid = 0
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.capturecard' doesn't exist
2007-06-12 08:00:44.725 DB Error (inserting row):
Query was:
INSERT INTO capturecard (cardid) VALUES (0);
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.capturecard' doesn't exist
2007-06-12 08:00:44.726 DB Error (simpledbstorage update):
Query was:
No error type from QSqlError? Strange...
2007-06-12 08:00:44.727 DB Error (simpledbstorage update):
Query was:
No error type from QSqlError? Strange...
2007-06-12 08:00:44.727 DB Error (simpledbstorage update):
Query was:
No error type from QSqlError? Strange...
2007-06-12 08:00:44.728 DB Error (simpledbstorage update):
Query was:
No error type from QSqlError? Strange...
2007-06-12 08:00:44.728 DB Error (simpledbstorage update):
Query was:
No error type from QSqlError? Strange...
2007-06-12 08:00:44.731 DB Error (CaptureCard::fillSelections):
Query was:
SELECT cardid, cardtype, videodevice FROM capturecard WHERE hostname = 'myth' AND parentid='0'
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.capturecard' doesn't exist
2007-06-12 08:00:46.708 DB Error (checkStoragePaths):
Query was:
SELECT data FROM settings WHERE value='RecordFilePrefix' AND hostname = 'myth';
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.settings' doesn't exist
2007-06-12 08:00:46.709 DB Error (checkChannelPresets):
Query was:
SELECT cardid, startchan, sourceid, inputname FROM cardinput;
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.cardinput' doesn't exist
[root@myth ~]#
havesoe one an ideaof what that migth be?????
Just getting better .... All the time
Offline