[mythtv] Attempting to try out latest svn ... database upgrade issue.
David
david at unsolicited.net
Sun Aug 10 10:59:17 UTC 2008
David wrote:
> 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.
>
>
Ended up doing the following, which allowed me to upgrade.
Index: libs/libmyth/dbutil.cpp
===================================================================
--- libs/libmyth/dbutil.cpp (revision 18112)
+++ libs/libmyth/dbutil.cpp (working copy)
@@ -273,8 +273,7 @@
if (!query.isConnected())
return result;
- query.prepare("SHOW FULL TABLES");
- if (!query.exec())
+ if (!query.exec("SHOW FULL TABLES;"))
{
MythDB::DBError("DBUtil Finding Tables", query);
return result;
More information about the mythtv-dev
mailing list