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

Steven Adeff adeffs.mythtv at gmail.com
Wed Jul 8 16:00:03 UTC 2015


On Wed, Jul 8, 2015 at 11:58 AM, Steven Adeff <adeffs.mythtv at gmail.com> wrote:
> On Sat, Jul 4, 2015 at 9:26 AM, Steven Adeff <adeffs.mythtv at gmail.com> wrote:
>> 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...
>
> well I tried to make Value and Hostname columns "primary", and when I
> launch mythbackend I get,
>
>
> This version of MythTV requires an updated database. (schema is 5000
> versions behind)
>
> Please run mythtv-setup or mythbackend to update your database.
>
> Database Host: 192.168.1.50
> Database Name: mythconverg
>
> 2015-07-08 08:48:38.564100 I  Database connection created: DBManager0
> 2015-07-08 08:48:38.564127 I  New DB connection, total: 1
> 2015-07-08 08:48:38.567111 I  Connected to database 'mythconverg' at
> host: 192.168.1.50
> 2015-07-08 08:48:38.571742 I  Closing DB connection named 'DBManager0'
> 2015-07-08 08:48:38.571912 I  Clearing Settings Cache.
> 2015-07-08 08:48:38.571987 I  Database connection created: DBManager1
> 2015-07-08 08:48:38.572002 I  New DB connection, total: 1
> 2015-07-08 08:48:38.572683 I  Connected to database 'mythconverg' at
> host: 192.168.1.50
> 2015-07-08 08:48:38.575076 N  Setting QT default locale to en_US
> 2015-07-08 08:48:38.575179 I  Current locale en_US
> 2015-07-08 08:48:38.575247 N  Reading locale defaults from
> /usr/share/mythtv//locales/en_us.xml
> 2015-07-08 08:48:38.578582 E  DB Error (SaveSettingOnHost('FreqTable')
> - query failure: ):
> Query was:
> INSERT INTO settings (value,data ) VALUES ( ?, ? );
> Bindings were:
> :DATA="us-bcast", :VALUE="FreqTable"
> Driver error was [2/1062]:
> QMYSQL3: Unable to execute statement
> Database error was:
> Duplicate entry 'FreqTable-' for key 'PRIMARY'
>
> 2015-07-08 08:48:38.580843 E  DB Error
> (SaveSettingOnHost('ISO639Language0') - query failure: ):
> Query was:
> INSERT INTO settings (value,data ) VALUES ( ?, ? );
> Bindings were:
> :DATA="eng", :VALUE="ISO639Language0"
> Driver error was [2/1062]:
> QMYSQL3: Unable to execute statement
> Database error was:
> Duplicate entry 'ISO639Language0-' for key 'PRIMARY'
>
> 2015-07-08 08:48:38.582545 E  DB Error
> (SaveSettingOnHost('ISO639Language1') - query failure: ):
> Query was:
> INSERT INTO settings (value,data ) VALUES ( ?, ? );
> Bindings were:
> :DATA="eng", :VALUE="ISO639Language1"
> Driver error was [2/1062]:
> QMYSQL3: Unable to execute statement
> Database error was:
> Duplicate entry 'ISO639Language1-' for key 'PRIMARY'
>
> 2015-07-08 08:48:38.584422 E  DB Error (SaveSettingOnHost('TVFormat')
> - query failure: ):
> Query was:
> INSERT INTO settings (value,data ) VALUES ( ?, ? );
> Bindings were:
> :DATA="NTSC", :VALUE="TVFormat"
> Driver error was [2/1062]:
> QMYSQL3: Unable to execute statement
> Database error was:
> Duplicate entry 'TVFormat-' for key 'PRIMARY'
>
> 2015-07-08 08:48:38.586091 E  DB Error (SaveSettingOnHost('VbiFormat')
> - query failure: ):
> Query was:
> INSERT INTO settings (value,data ) VALUES ( ?, ? );
> Bindings were:
> :DATA="NTSC Closed Caption", :VALUE="VbiFormat"
> Driver error was [2/1062]:
> QMYSQL3: Unable to execute statement
> Database error was:
> Duplicate entry 'VbiFormat-' for key 'PRIMARY'
>
> 2015-07-08 08:48:38.589283 I  Enabling Settings Cache.
> 2015-07-08 08:48:38.589294 I  Clearing Settings Cache.
> 2015-07-08 08:48:38.595992 I  Disabling Settings Cache.
> 2015-07-08 08:48:38.596004 I  Clearing Settings Cache.
> 2015-07-08 08:48:38.598036 I  No current database version?
> 2015-07-08 08:48:38.602121 W  Not allowed to upgrade the database.
> 2015-07-08 08:48:38.604437 I  Enabling Settings Cache.
> 2015-07-08 08:48:38.604452 I  Clearing Settings Cache.
> 2015-07-08 08:48:38.604844 E  Couldn't upgrade database to new schema
> 2015-07-08 08:48:38.628782 I  Removing syslogging


ran
ALTER TABLE `mythconverg`.`settings`
ADD COLUMN `id` INT NOT NULL AUTO_INCREMENT FIRST,
ADD PRIMARY KEY (`id`);

and all is well and good! (so far...)

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


More information about the mythtv-users mailing list