[mythtv] Attempting to try out latest svn ... database upgrade issue.

David david at unsolicited.net
Fri Aug 8 19:38:33 UTC 2008


I'm having a little difficulty upgrading to svn from an older (pre QT4)
one. MythTV seems to think that my database is empty ? Does anyone have
any suggestions for a workaround?

(Linux/QT4.3.4/MYSQL 5.1.22)

2008-08-08 19:34:54.876 Using runtime prefix = /usr
2008-08-08 19:34:54.882 Empty LocalHostName.
2008-08-08 19:34:54.882 Using localhost value of server
2008-08-08 19:34:54.920 New DB connection, total: 1
2008-08-08 19:34:54.956 Connected to database 'mythconverg' at host:
localhost
2008-08-08 19:34:54.956 Closing DB connection named 'DBManager0'
2008-08-08 19:34:54.962 Connected to database 'mythconverg' at host:
localhost
2008-08-08 19:34:54.970 Current Schema Version: 1212
2008-08-08 19:34:54.970 Database schema is old. Waiting to see if DB is
being upgraded.
2008-08-08 19:34:55.971 New DB connection, total: 2
2008-08-08 19:34:55.972 Connected to database 'mythconverg' at host:
localhost
2008-08-08 19:34:55.978 Current Schema Version: 1212
2008-08-08 19:34:56.984 Current Schema Version: 1212
2008-08-08 19:34:57.989 Current Schema Version: 1212
2008-08-08 19:34:58.995 Current Schema Version: 1212
2008-08-08 19:35:00.001 Current Schema Version: 1212
2008-08-08 19:35:00.002 Timed out waiting.
2008-08-08 19:35:00.008 New database detected.  Skipping backup.

Warning: MythTV wants to upgrade your database,
for the TV schema, from 1212 to 1223.


Shall I upgrade this database? [yes]

A database backup might be a good idea
Are you sure you want to upgrade? [no]  yes
2008-08-08 19:35:13.403 Newest Schema Version : 1223
2008-08-08 19:35:13.413 Inserting MythTV initial database information.
2008-08-08 19:35:13.413 New DB connection, total: 3
2008-08-08 19:35:13.414 Connected to database 'mythconverg' at host:
localhost
2008-08-08 19:35:13.415 Upgrading to schema version 1112
2008-08-08 19:35:13.434 DB Error (Performing database upgrade):
Query was: INSERT INTO playgroup VALUES ('Default','',30,5,100);
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



More information about the mythtv-dev mailing list