[mythtv-users] Avenard repo upgraded to 0.22 Database Schema upgrade failed

[Michael T. Dean]

On 10/21/2009 05:05 PM, Patrick Davila wrote:
> Been happily running 0.21 with Avenard patches. Upgrade notification
> popped up today and the wife clicked yes. Packages upgraded to 0.22 and
> the DBSchema upgrade is failing:
> 2009-10-21 17:03:01.653 Newest MythTV Schema Version : 1244
> 2009-10-21 17:03:01.656 Upgrading to MythTV schema version 1225
> 2009-10-21 17:03:01.657 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-10-21 17:03:01.657 Database Schema upgrade FAILED, unlocking.
> 2009-10-21 17:03:01.657 Couldn't upgrade database to new schema
>
>
> Any ideas on how to get around this?

Those aren't the real error that caused the upgrade to fail.  Those are 
errors that you get when you repeat the upgrade after the upgrade failed.

Please execute:

mysql -umythtv -p mythconverg \
 -e "DROP TABLE IF EXISTS bad_people; "\
"DROP TABLE IF EXISTS bad_credits; "
"DROP TABLE IF EXISTS bad_recordedcredits;"

Then re-run the upgrade and post the output.

Thanks,
Mike