[mythtv-users] troubles with xmltv and mythfilldatabase

[Phill Edwards]

Bit more to it than that I think. After logging into mysql you have to 
connect to the right database before you can query any tables. I think the 
syntax is "connect mythconverg;" or something like that. Find the file 
mc.sql and look in there for exact syntax.

Regards,
Phill

>From: "anders smith" <anders at smiths.dk>
>Reply-To: Discussion about mythtv <mythtv-users at mythtv.org>
>To: "Discussion about mythtv" <mythtv-users at mythtv.org>
>Subject: Re: [mythtv-users] troubles with xmltv and mythfilldatabase
>Date: Mon, 1 Nov 2004 14:00:05 +0100
>
>mysql > select * from channel;
>
>I seem to remember this will give you everything in the channel table
>anders
>
>----- Original Message -----
>From: "Michael Messner" <michael.messner_edv at inode.at>
>To: <mythtv-users at mythtv.org>
>Sent: Monday, November 01, 2004 1:28 PM
>Subject: Re: [mythtv-users] troubles with xmltv and mythfilldatabase
>
>
>Hi,
>
>Am Montag, 1. November 2004 13:08 schrieb Ryszard:
> > did you log onto mysql and do a select on the channel table?
>
>I'm not a mysql expert so what do you mean with a select on the
>channel table?
>If I open mysql I can see a complete empty channel table.
>
>cu mIke
>
>
> > i'm
> > not an expert but it looks like the 1st place to start looking.
> >
> >
> > On Mon, 1 Nov 2004 12:59:56 +0200, Michael Messner
> >
> > <michael.messner_edv at inode.at> wrote:
> > > Hello,
> > >
> > >  nobody an idea whats going wrong?
> > >
> > > mfg mIke
> > >
> > > Am Sonntag, 31. Oktober 2004 13:18 schrieb Michael Messner:
> > > > Hello,
> > > >
> > > >  now I've tried to get the TV-guide working on mythTV
> > > > (without a TV-card).
> > > >
> > > > tv_grab_de_tvtoday --config-file /root/.mythtv/channel.xmltv
> > > > --output ~/.mythtv/listings.xml
> > > >
> > > > getting list of channels:
> > > > ##################################################
> > > > grabbing: ##################################################
> > > >
> > > >  /usr/local/bin/mythfilldatabase --file 1 0
> > > > ~/.mythtv/listings.xml
> > > >
> > > > ### bypassing grabbers, reading directly from file
> > > > Query was:
> > > > SELECT channum FROM channel WHERE chanid = 1000;
> > > > No error type from QSqlError?  Strange...
> > > > Query was:
> > > > SELECT channum FROM channel WHERE chanid = 1000;
> > > > No error type from QSqlError?  Strange...
> > > > Query was:
> > > > SELECT channum FROM channel WHERE chanid = 1000;
> > > > No error type from QSqlError?  Strange...
> > > > ......
> > > >
> > > > is there any mistake from me?
> > > > anybody knows whats going wrong there?
> > > >
> > > > thanks and cu mIke
> > >
> > > --
> > > Selflinux
> > > http://www.selflinux.org/portal/
> > >
> > >
> > > _______________________________________________
> > > mythtv-users mailing list
> > > mythtv-users at mythtv.org
> > > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>--
>Eine Katze hat einen Schwanz mehr als keine Katze. Keine Katze hat
>zwei Schwänze, also hat eine Katze drei Schwänze.
>[Bernd Brodesser in suse-linux]
>
>
>
>----------------------------------------------------------------------------
>----
>
>
>_______________________________________________
>mythtv-users mailing list
>mythtv-users at mythtv.org
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>_______________________________________________
>mythtv-users mailing list
>mythtv-users at mythtv.org
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users