View unanswered posts    View active topics

Board index KnoppMyth Hardware

All times are UTC - 6 hours





Post new topic Reply to topic  Page 1 of 1
  [ 9 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
jockboy6
PostPosted: Wed May 03, 2006 10:38 pm 
Offline
Joined: Fri Feb 11, 2005 2:47 pm
Posts: 14
After upgrading from R5A22 to R5B7 I can no longer set up my Video Source in mythtv-setup. I can make my selections but it doesn't save when I hit finish.

When I do a mythfilldatabase, I get this error

Quote:
Table 'mythconverg.videosource' doesn't exist


I know this means I'm missing this table somehow, how can I recreate this table? I checked in my backup and it doesn't mention the videosouce table at all. Any Ideas?
Top
 Profile  
 
cecil
 Post subject:
PostPosted: Wed May 03, 2006 10:54 pm 
Offline
Site Admin
Joined: Fri Sep 19, 2003 6:37 pm
Posts: 2659
Location: Whittier, Ca
Check your db for errors.
Top
 Profile  
 
jockboy6
 Post subject:
PostPosted: Thu May 04, 2006 5:49 am 
Offline
Joined: Fri Feb 11, 2005 2:47 pm
Posts: 14
I ran mysqlcheck and this is what I got

Quote:
root@mythtv:~# mysqlcheck -r -umythtv -pmythtv mythconverg
mythconverg.callsignnetworkmap OK
mythconverg.capturecard OK
mythconverg.cardinput OK
mythconverg.channel OK
mythconverg.codecparams OK
mythconverg.conflictresolutionany OK
mythconverg.conflictresolutionoverride OK
mythconverg.conflictresolutionsingle OK
mythconverg.credits OK
mythconverg.dtv_multiplex OK
mythconverg.dtv_privatetypes OK
mythconverg.dvdinput OK
mythconverg.dvdtranscode OK
mythconverg.favorites OK
mythconverg.filemarkup OK
mythconverg.gallerymetadata OK
mythconverg.gamemetadata OK
mythconverg.gameplayers OK
mythconverg.housekeeping OK
mythconverg.jobqueue OK
mythconverg.jumppoints OK
mythconverg.keybindings OK
mythconverg.keyword OK
mythconverg.mamemetadata OK
mythconverg.mamesettings OK
mythconverg.musicmetadata OK
mythconverg.musicplaylist OK
mythconverg.mythlog OK
mythconverg.mythweb_sessions OK
mythconverg.neskeyword OK
mythconverg.nestitle OK
mythconverg.networkiconmap OK
mythconverg.newssites OK
mythconverg.oldfind OK
mythconverg.oldprogram OK
mythconverg.oldrecorded OK
mythconverg.people OK
mythconverg.phonecallhistory OK
mythconverg.phonedirectory OK
mythconverg.pidcache OK
mythconverg.profilegroups OK
mythconverg.program OK
mythconverg.programgenres OK
mythconverg.programrating OK
mythconverg.recgrouppassword OK
mythconverg.record OK
mythconverg.recorded OK
mythconverg.recordedcredits OK
mythconverg.recordedmarkup OK
mythconverg.recordedprogram OK
mythconverg.recordedrating OK
mythconverg.recordingprofiles OK
mythconverg.recordmatch OK
mythconverg.recordoverride OK
mythconverg.schemalock OK
mythconverg.settings OK
mythconverg.smartplaylist OK
mythconverg.smartplaylistcategory OK
mythconverg.smartplaylistitem OK
mythconverg.snessettings OK
mythconverg.videobookmarks OK
mythconverg.videocategory OK
mythconverg.videocountry OK
mythconverg.videogenre OK
mythconverg.videometadata OK
root@mythtv:~#


is that what you meant by checking the db?
Top
 Profile  
 
jockboy6
 Post subject:
PostPosted: Thu May 04, 2006 7:41 am 
Offline
Joined: Fri Feb 11, 2005 2:47 pm
Posts: 14
Also am I missing any other tables here?

Would someone be able to export their videosource table and post it here or send me to a working R5B7 DB ??? hopefully someone that uses zap2it for north america.

Could I have a bad image?

Thanks!
Top
 Profile  
 
adoute
 Post subject:
PostPosted: Thu May 04, 2006 9:07 am 
Offline
Joined: Tue Mar 29, 2005 6:15 pm
Posts: 79
Location: Plymouth, MI
I would say that a bad image is a definite possibility - if you don't have all the right tables, something obviously went wrong during the install / update process.

This is a list of all the tables that I have in mythvconverg:

Code:
callsignnetworkmap
capturecard
cardinput
channel
codecparams
credits
dtv_multiplex
dtv_privatetypes
dvdinput
dvdtranscode
favorites
filemarkup
gallerymetadata
gamemetadata
gameplayers
housekeeping
inuseprograms
jobqueue
jumppoints
keybindings
keyword
mamemetadata
mamesettings
musicmetadata
musicplaylist
mythlog
mythweb_sessions
neskeyword
nestitle
networkiconmap
oldfind
oldprogram
oldrecorded
people
phonecallhistory
phonedirectory
pidcache
playgroup
profilegroups
program
programgenres
programrating
recgrouppassword
record
recorded
recordedcredits
recordedmarkup
recordedprogram
recordedrating
recordingprofiles
recordmatch
romdb
schemalock
settings
smartplaylist
smartplaylistcategory
smartplaylistitem
snessettings
tvchain
videobookmarks
videocategory
videocountry
videogenre
videometadata
videometadatacountry
videometadatagenre
videosource
videotypes
websites
xvmc_buffer_settings


Here is the structure for the videosource table (output form PHPMyAdmin):
Code:
--
-- Table structure for table `videosource`
--

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 AUTO_INCREMENT=2 ;


On my system, there is only 1 row of data in the videosource table. The values are:
Code:
 sourceid: 1
name: <your info will be different than mine>
xmltvgrabber: datadirect
userid: <your info will be different than mine>
freqtable: default
lineupid: <your info will be different than mine>
password:<your info will be different than mine>
useeit: 0


This is all taken from a working R5B7 install. Hope it helps!

Allan

_________________
Running Knoppmyth R5F27 since 09/12/07

Hardware Specs
Top
 Profile  
 
jockboy6
 Post subject:
PostPosted: Thu May 04, 2006 9:57 am 
Offline
Joined: Fri Feb 11, 2005 2:47 pm
Posts: 14
Looks like I'm missing some of those tables (about 6 tables), I'll try and download from a new source and upgrade again.

This table schema is just what I needed. Thanks!!!
Top
 Profile  
 
tjc
 Post subject:
PostPosted: Thu May 04, 2006 11:28 am 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
Remember to use the "testcd" option when you boot from the CD. This has saved me from wasting a bunch of time fighting with bad CDs on at least a couple of occasions.
Top
 Profile  
 
jockboy6
 Post subject:
PostPosted: Thu May 04, 2006 5:45 pm 
Offline
Joined: Fri Feb 11, 2005 2:47 pm
Posts: 14
tried a new image off a different server - same problem

this is what I get when I run mythbackend:

Quote:
# mythbackend
2006-05-04 23:43:15.236 Using runtime prefix = /usr
2006-05-04 23:43:15.257 New DB connection, total: 1
2006-05-04 23:43:15.278 Connected to database 'mythconverg' at host: localhost
2006-05-04 23:43:15.284 Current Schema Version: 1099
2006-05-04 23:43:15.285 Newest Schema Version : 1123
2006-05-04 23:43:15.287 New DB connection, total: 2
2006-05-04 23:43:15.288 Connected to database 'mythconverg' at host: localhost
2006-05-04 23:43:15.288 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.
2006-05-04 23:43:15.290 New DB connection, total: 3
2006-05-04 23:43:15.291 Connected to database 'mythconverg' at host: localhost
2006-05-04 23:43:15.292 Upgrading to schema version 1100
2006-05-04 23:43:15.293 DB Error (Performing database upgrade):
Query was: ALTER TABLE videosource ADD COLUMN useeit SMALLINT NOT NULL DEFAULT 0;
Error was: Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.videosource' doesn't exist

new version: 1100
2006-05-04 23:43:15.294 Database Schema upgrade FAILED, unlocking.
2006-05-04 23:43:15.295 Couldn't upgrade database to new schema


Any Ideas?
Top
 Profile  
 
jockboy6
 Post subject:
PostPosted: Thu May 04, 2006 9:01 pm 
Offline
Joined: Fri Feb 11, 2005 2:47 pm
Posts: 14
I think I got it working, for some reason I lost that table, so I added the table from the post above and I got an error message

if your upgradeing to R5B7 this is the table you need to have before you do the upgrade:

Code:
--
-- Table structure for table `videosource`
--

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,
  PRIMARY KEY  (`sourceid`),
  UNIQUE KEY `name` (`name`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;


After you upgrade, the upgrade process adds the useeit field.

Code:
`useeit` smallint(6) NOT NULL default '0',


Thanks guys for all the help :-)
Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 1 of 1
  [ 9 posts ] 


Board index KnoppMyth Hardware

All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 17 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:  
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu