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

[Steven Adeff]

On Thu, Jul 2, 2015 at 7:55 PM, Michelle Dupuis <mdupuis at ocg.ca> wrote:
> You should be safe to add a single call (eg: XXXREFNUM) which is big int type and autoincrement.  After that the phpmyadmin tools will support row manipulation.
> ________________________________________
> From: mythtv-users <mythtv-users-bounces at mythtv.org> on behalf of Rich Freeman <r-mythtv at thefreemanclan.net>
> Sent: Thursday, July 2, 2015 6:44 PM
> To: Myth TV Users List
> Subject: Re: [mythtv-users] phpmyadmin no unique on settings table?
>
> On Thu, Jul 2, 2015 at 4:57 PM, Hika van den Hoven <hikavdh at gmail.com> wrote:
>>
>> It's why he could not edit the table in phpmyadmin. Because there was
>> no Index. Just like on my system. If he is running Gentoo it could be
>> that the scheme coming with the installation there is faulty
>>
>
> Gentoo doesn't mess with the DB schemas.  That should be 100% out of
> the box.  However, if it is a long-lived install (ie upgraded over
> many versions) I can't vouch for how mythtv has upgraded the schemas.
> The only real DB issue Gentoo ever had with MythTV was that our MySQL
> default charset wasn't what MythTV was expecting, and that resulted in
> a bumpy 0.22 upgrade.
>
> I'd think that adding the key after the fact shouldn't hurt anything.
>
> --
> Rich

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.


-- 
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