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

Table 'mythconverg.videosource' doesn't exist
http://forum.linhes.org/viewtopic.php?f=2&t=9908		 Page 1 of 1
Author:  jockboy6 [ Wed May 03, 2006 10:38 pm ]
Post subject:  Table 'mythconverg.videosource' doesn't exist
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?
Author:  cecil [ Wed May 03, 2006 10:54 pm ]
Post subject: 
Check your db for errors.
Author:  jockboy6 [ Thu May 04, 2006 5:49 am ]
Post subject: 
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?
Author:  jockboy6 [ Thu May 04, 2006 7:41 am ]
Post subject: 
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!
Author:  adoute [ Thu May 04, 2006 9:07 am ]
Post subject: 
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
Author:  jockboy6 [ Thu May 04, 2006 9:57 am ]
Post subject: 
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!!!
Author:  tjc [ Thu May 04, 2006 11:28 am ]
Post subject: 
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.
Author:  jockboy6 [ Thu May 04, 2006 5:45 pm ]
Post subject: 
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?
Author:  jockboy6 [ Thu May 04, 2006 9:01 pm ]
Post subject: 
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 :-)
Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/