[mythtv-users] 0.27 to 0.28.1 mythdatabase upgrade failure

[Michael T. Dean]

On 04/16/2017 05:30 PM, Steven Adeff wrote:
> running on Ubuntu, performed a full apt-get upgrade after enabling the
> 0.28 ppa and removing the 0.27ppa.
>
> When I run mythtv-setup.real and accept the database upgrade I get this,
>
> 2017-04-16 14:26:53.093764 C  Upgrading to MythTV schema version 1318
> 2017-04-16 14:26:53.094492 E  DB Error (Performing database upgrade):
> Query was: INSERT INTO settings VALUES ('ImageStorageGroupName',
> 'Images', NULL);
> Error was: Driver error was [2/1136]:
> QMYSQL: Unable to execute query
> Database error was:
> Column count doesn't match value count at row 1
>
> 2017-04-16 14:26:53.094517 E  Database schema upgrade failed.
> 2017-04-16 14:26:53.094893 E  Couldn't upgrade database to new schema.
> QMutex: destroying locked mutex
>
>
> a quick google on the error shows a hit to the mythtv list about
> something that has already been fixed, so I'm wondering if I've missed
> something?
>
> thanks!

This just means that something/someone has modified your settings table 
such that it has other than 3 columns.  It should have only value, data, 
and hostname columns.  Anything else (likely--or anything less, 
unlikely) means something broke your DB.

Mike