Hi Mythtv experts, please help a brother out.

While following the instructions at http://knoppmythwiki.org/index.php?page=MythFlix

When completing the below step, I mistakenly input the wrong "Queue" number. (P0000000000000000000000000000000000)


Replace the first url with the URL you copied down before. You can leave the icon URL alone.
insert into netflix values ("Queue","NetFlix?", 'http://rss.netflix.com/QueueRSS?id=P0000000000000000000000000000000000','http://cdn.nflximg.com/us/icons/nficon.ico', null, 1);

When I try to update Mysql with the correct # I get the following message.

"ERROR 1062: Duplicate entry 'Queue' for key 1"

It probably has something to do with typing "insert", but I don't know what to type to fix it.

Thanks for your help.

_________________
Seth Loff

Probably your mysql command should be 'replace' rather than 'insert'.

I was able to insert the queue and history but I seem to be putting it in the wrong place because it is showing up in the Browse movie section.
I was using webmin and adding the table to the mythconverg database.
I did a search for netflix and added there.
Any ideas on why it seemed to place it in the wrong menue?

I just forgot to place the correct numbers 1 and 2 in is_queue, this immediately put the information on the correct page

How can I fix this field in the settings table in the mythconverg db?

MythFlix isn't working properly and I believe it's because I pasted the wrong value.
Now there are two NetflixShopperId values with different cookie data.

Webmin says "Data in this table cannot be edited because it has no primary key."

Would it be feasible to stop the mysql server, dump the data out of settings, edit out the bad value, and try to import the settings table?

There is a settings.sh I posted here a while back which makes fiddling with that easier. Searching for "settings" with me "tjc" as the author should turn it up quickly.