[mythtv-users] 0.27 to 0.28.1 mythdatabase upgrade failure

[Steven Adeff]

On Mon, Apr 17, 2017 at 3:42 AM, Michael T. Dean
<mtdean at thirdcontact.com> wrote:
> 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

Ah!

Yes, my settings table has an "ID" column. Which looking back through
my records I had to implement years ago to get around another issue
MythTV was having with my settings table. I removed the column and was
able to get MythTV to update the database.

thanks!!

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