[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