LinHES Forums
http://forum.linhes.org/

R5F27 setup video sources - not picking up SchedulesDirect
http://forum.linhes.org/viewtopic.php?f=14&t=16405
Page 1 of 1

Author:  wrichards [ Mon Sep 10, 2007 1:25 pm ]
Post subject:  R5F27 setup video sources - not picking up SchedulesDirect

mythtv-setup's video sources won't add new video source. I fill in the fields, click Finish, and no record was added.

Author:  cecil [ Mon Sep 10, 2007 1:44 pm ]
Post subject: 

If you <alt><tab> to the xterm you see?

Author:  slowtolearn [ Mon Sep 10, 2007 2:09 pm ]
Post subject:  Re: R5F27 setup video sources - not picking up SchedulesDir

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..."?

Author:  wrichards [ Mon Sep 10, 2007 3:10 pm ]
Post subject: 

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

Author:  wrichards [ Mon Sep 10, 2007 3:15 pm ]
Post subject: 

I looked into mythconverg--show tables lists 65 tables, and sure enough, 'videosource' is not one of them.

Author:  slowtolearn [ Mon Sep 10, 2007 3:42 pm ]
Post subject: 

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?

Author:  wrichards [ Mon Sep 10, 2007 4:05 pm ]
Post subject: 

It's an update from R5F1. The cd self-test passed.

Author:  slowtolearn [ Mon Sep 10, 2007 4:32 pm ]
Post subject: 

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...

Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/