[mythtv-users] help with mysql database

[Khanh Tran]

Drop the database and reimport the schema?  Since you're just following
the setup instructions, you can't lose, right?

-Khanh


-----Original Message-----
From: mythtv-users-bounces at mythtv.org
[mailto:mythtv-users-bounces at mythtv.org] On Behalf Of ognjen Bezanov
Sent: Friday, November 12, 2004 12:21 PM
To: ognjen at mailshack.com; Discussion about mythtv
Subject: Re: [mythtv-users] help with mysql database

Anyone got any ideas? i realy want to use MythTV, but if i cant i may
have to *shudder* load up windows with one of the other PVR programs,
which i am far from keen on.

Thanks.

On Thu, 2004-11-11 at 21:17, ognjen Bezanov wrote:
> Hi all, Ive been following the MythTv howto from mythtv.org and have 
> sucessfully managed to install everything, the only problem i have 
> currently is with mysql database, everytime i try to add channels via 
> mythtv-setup (using XMLTV) i get the following error at the end:
> 
> 
> DB Error (simpledbstorage update):
> Query was:
> INSERT INTO videosource SET sourceid = 0, freqtable = 'default'; 
> Driver error was [2/1062]:
> QMYSQL3: Unable to execute query
> Database error was:
> Duplicate entry '' for key 2
> 
> 
> I ran mysql admin and checked the database, there is no duplicate 
> entry (in fact the database is empty) so im a bit stumped with this, 
> any help appreciated.
> 
> 
> ______________________________________________________________________
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users