[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