repeating "wants to upgrade your database schema from 1177 to 1214"
I upgraded from 4 to 5 today and everything seemed to go alright. When I tried to run mythTV setup from the desktop I got the mythtv wants to upgrade the database schema like I expected and it was on the pretty new blue backgroud.
Then I tried to run the setup again to check that all my settings were correct and change the IP address and now everytime (5 or 6 so far) I run the setup from the desktop it just repeats the "mythtv wants to upgrade your database schema" windows. But this time they are back to the grey backgroud from Mythdora 4.
Anyone else having this? I couldn't find any articles in the forums.
Here's a sample log entry (makes the same one each time I try)
2008-08-12 18:48:42.807 Using runtime prefix = /usr, libdir = /usr/lib
2008-08-12 18:48:42.816 Unable to read configuration file mysql.txt
2008-08-12 18:48:42.817 Empty LocalHostName.
2008-08-12 18:48:42.818 Using localhost value of mythserver
2008-08-12 18:48:42.835 New DB connection, total: 1
2008-08-12 18:48:42.843 Connected to database 'mythconverg' at host: localhost
2008-08-12 18:48:42.845 Closing DB connection named 'DBManager0'
2008-08-12 18:48:42.848 Connected to database 'mythconverg' at host: localhost
2008-08-12 18:48:42.850 New DB connection, total: 2
2008-08-12 18:48:42.853 Connected to database 'mythconverg' at host: localhost
2008-08-12 18:48:42.859 Current Schema Version: 1177
2008-08-12 18:48:42.869 New DB connection, total: 3
2008-08-12 18:48:42.872 Connected to database 'mythconverg' at host: localhost
2008-08-12 18:48:42.875 Backing up database to file: /storage/recordings/mythconverg-1177-20080812184842.sql
2008-08-12 18:48:46.969 Compressing database backup file.
2008-08-12 18:48:49.527 Database Backup filename: /storage/recordings/mythconverg-1177-20080812184842.sql.gz
2008-08-12 18:48:49.528 Database Backup complete.
Console is not interactive, cannot ask user about upgrading database schema.
2008-08-12 18:48:49.538 Newest Schema Version : 1214
2008-08-12 18:48:49.542 Upgrading to schema version 1178
2008-08-12 18:48:49.621 DB Error (Performing database upgrade):
Query was: ALTER TABLE program DROP INDEX programid;
Error was: Driver error was [2/1091]:
QMYSQL3: Unable to execute query
Database error was:
Can't DROP 'programid'; check that column/key exists
new version: 1178
2008-08-12 18:48:49.625 Database Schema upgrade FAILED, unlocking.
2008-08-12 18:48:49.627 Couldn't upgrade database to new schema