[mythtv-users] help with mysql database

[ognjen Bezanov]

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.