[mythtv-users] Avenard repo upgraded to 0.22 Database Schema upgrade failed
Michael T. Dean
mtdean at thirdcontact.com
Wed Oct 21 22:59:02 UTC 2009
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.
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.
More information about the mythtv-users