[mythtv-users] phpmyadmin no unique on settings table?

[Steven Adeff]

On Fri, Jul 3, 2015 at 8:16 PM, Rich Freeman
<r-mythtv at thefreemanclan.net> wrote:
>> ok, I'm still not sure what to do then. before I upgraded I was able
>> to edit the table in an older version of phpmyadmin. another mythtv
>> system I run, which is on the older phpmyadmin I can edit the table.
>>
>
> I'd have to look up the syntax, but either add the primary key index
> on the two columns, or just add a new autonumber field as the primary
> key.  Neither should bother MythTV.  I'd think that you could do this
> from phpmyadmin, actually (I don't think it should care about a
> missing primary key when altering a table).
>
> --
> Rich

ok, I'll have to do some googling to see how to do that exactly. and
of course perform a db backup just before...


-- 
Steve
http://www.mythtv.org/wiki/User:Steveadeff
Before you ask, read the FAQ!
http://www.mythtv.org/wiki/Frequently_Asked_Questions
then search the Wiki, and this list,
http://www.gossamer-threads.com/lists/mythtv/
Mailinglist etiquette - http://www.mythtv.org/wiki/Mailing_List_etiquette