[mythtv] Mythflix setup issues

Justin luitjens at cs.utah.edu
Wed Feb 13 00:15:41 UTC 2008


Hi,

I'm trying to configure mythflix to connect to my netflix account.  I 
followed the instructions found at 
http://www.mythtv.org/wiki/index.php/MythFlix_README.  When I get to the 
step where I need to insert into the database I'm getting the following 
error:


mysql> insert into mythconverg.netflix values ('Queue','NetFlix', 
'http://rss.netflix.com/QueueRSS?id=P1414488369827910822560762043502405','http://cdn.nflximg.com/us/icons/nficon.ico', 
null, 1);
ERROR 1136 (21S01): Column count doesn't match value count at row 1
mysql> insert into mythconverg.netflix values ('History','NetFlix', 
'http://rss.netflix.com/TrackingRSS?id=P1414488369827910822560762043502405','http://cdn.nflximg.com/us/icons/nficon.ico', 
null, 2);
ERROR 1136 (21S01): Column count doesn't match value count at row 1


Looking at the database shows the number of columns is different in the 
database

+----------+------------------+------+-----+---------+-------+
| Field    | Type             | Null | Key | Default | Extra |
+----------+------------------+------+-----+---------+-------+
| name     | varchar(100)     | NO   | PRI |         |       |
| category | varchar(255)     | NO   |     |         |       |
| url      | varchar(255)     | NO   |     |         |       |
| ico      | varchar(255)     | YES  |     | NULL    |       |
| updated  | int(10) unsigned | YES  |     | NULL    |       |
| is_queue | int(10) unsigned | YES  |     | NULL    |       |
| queue    | varchar(32)      | NO   | PRI |         |       |
+----------+------------------+------+-----+---------+-------+
7 rows in set (0.05 sec)


I'm unsure exactly which parameters are which to know which one is 
missing.  Can someone with some know how please let me know what the 
command should be?  Also the readme should probably be updated.

Thanks


More information about the mythtv-dev mailing list