[mythtv-users] upgrade database schema from 1224 to 1242 fails
Michael T. Dean
mtdean at thirdcontact.com
Tue Aug 25 06:12:13 UTC 2009
On 08/25/2009 01:27 AM, Michael T. Dean wrote:
> On 08/25/2009 12:59 AM, Kevin Johnson wrote:
>> I recently tried upgrading to .22 using trunk because I had a few
>> things that I thought an upgrade might help.
>>
>> Now i am in real trouble. I am using mythbuntu 9.04
>>
>> I installed all the packages. When I enter mythtv-setup, it want to
>> upgrade. I choose okay and it kicks out and ask me if I want to run
>> mythfilldatabase. Of couse that fails to.
>> If I run mythbackend from the command line, this is the last part of
>> the output.
>>
>> Please help.
>>
>> A database backup might be a good idea
>> Are you sure you want to upgrade? [no] yes
>> 2009-08-24 21:52:50.166 Newest Schema Version : 1242
>> 2009-08-24 21:52:50.172 Upgrading to schema version 1225
>> 2009-08-24 21:52:50.174 DB Error (Performing database upgrade): Query
>> was: CREATE TABLE bad_people AS SELECT * FROM people; Error was:
>> Driver error was [2/1050]:
>> QMYSQL3: Unable to execute statement
>> Database error was:
>> Table 'bad_people' already exists
>>
>> new version: 1225
>> 2009-08-24 21:52:50.174 Database Schema upgrade FAILED, unlocking.
>> 2009-08-24 21:52:50.175 Couldn't upgrade database to new schema
>
> That error is caused by the previous upgrade failure.
>
> Any chance you have the log from the original upgrade?
Meaning that it looks like you re-ran mythtv-setup or mythbackend to get
the log output showing the failure for pasting into the e-mail.
Instead, it's now giving a different error that's being caused by the
"unfinished" state of the database upgrade.
Mike
More information about the mythtv-users
mailing list