View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 8 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
PostPosted: Mon Sep 10, 2007 1:25 pm 
Offline
Joined: Mon Jan 01, 2007 10:43 pm
Posts: 6
mythtv-setup's video sources won't add new video source. I fill in the fields, click Finish, and no record was added.

_________________
PVR-350 + PVR-150
KnoppMyth R5F27
1.66 GHz Sempron, 1G RAM


Top
 Profile  
 
 Post subject:
PostPosted: Mon Sep 10, 2007 1:44 pm 
Offline
Site Admin
Joined: Fri Sep 19, 2003 6:37 pm
Posts: 2659
Location: Whittier, Ca
If you <alt><tab> to the xterm you see?


Top
 Profile  
 
PostPosted: Mon Sep 10, 2007 2:09 pm 
Offline
Joined: Wed Nov 16, 2005 8:55 pm
Posts: 1381
Location: Farmington, MI USA
wrichards wrote:
mythtv-setup's video sources won't add new video source. I fill in the fields, click Finish, and no record was added.
Did you "Fetch listings..."?


Top
 Profile  
 
 Post subject:
PostPosted: Mon Sep 10, 2007 3:10 pm 
Offline
Joined: Mon Jan 01, 2007 10:43 pm
Posts: 6
xterm:

tv_find_grabbers exited early or we timed out waiting
2007-09-10 12:44:19.068 DB Error (inserting row):
Query was:
INSERT INTO videosource (sourceid) VALUES (0);
Driver error was [2/1146]:
MYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.videosource' doesn't exist

_________________
PVR-350 + PVR-150
KnoppMyth R5F27
1.66 GHz Sempron, 1G RAM


Top
 Profile  
 
 Post subject:
PostPosted: Mon Sep 10, 2007 3:15 pm 
Offline
Joined: Mon Jan 01, 2007 10:43 pm
Posts: 6
I looked into mythconverg--show tables lists 65 tables, and sure enough, 'videosource' is not one of them.

_________________
PVR-350 + PVR-150
KnoppMyth R5F27
1.66 GHz Sempron, 1G RAM


Top
 Profile  
 
 Post subject:
PostPosted: Mon Sep 10, 2007 3:42 pm 
Offline
Joined: Wed Nov 16, 2005 8:55 pm
Posts: 1381
Location: Farmington, MI USA
wrichards wrote:
I looked into mythconverg--show tables lists 65 tables, and sure enough, 'videosource' is not one of them.
Odd. Is this a fresh install or an upgrade? Perhaps a bad download/CD/burn?


Top
 Profile  
 
 Post subject:
PostPosted: Mon Sep 10, 2007 4:05 pm 
Offline
Joined: Mon Jan 01, 2007 10:43 pm
Posts: 6
It's an update from R5F1. The cd self-test passed.

_________________
PVR-350 + PVR-150
KnoppMyth R5F27
1.66 GHz Sempron, 1G RAM


Top
 Profile  
 
 Post subject:
PostPosted: Mon Sep 10, 2007 4:32 pm 
Offline
Joined: Wed Nov 16, 2005 8:55 pm
Posts: 1381
Location: Farmington, MI USA
wrichards wrote:
It's an update from R5F1. The cd self-test passed.
Hmmm. Here's the table structure from my backup:
Code:
CREATE TABLE `videosource` (
  `sourceid` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(128) NOT NULL default '',
  `xmltvgrabber` varchar(128) default NULL,
  `userid` varchar(128) NOT NULL default '',
  `freqtable` varchar(16) NOT NULL default 'default',
  `lineupid` varchar(64) default NULL,
  `password` varchar(64) default NULL,
  `useeit` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`sourceid`),
  UNIQUE KEY `name` (`name`)
) TYPE=MyISAM;

Hopefully that's the only problem you will run into, but I have 75 tables in my R5D1 +.20.2 -> R5F27 upgrade system. You might try running the upgrade again...


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 8 posts ] 


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 26 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu