<!DOCTYPE html><html><head>
<style type="text/css">body { font-family:'DejaVu Sans Mono'; font-size:12px}</style>
</head>
<body>On Wed, 23 Jan 2013 20:48:29 +1300, Nick Rout <nick.rout@gmail.com> wrote:<br><br><blockquote style="margin: 0 0 0.80ex; border-left: #0000FF 2px solid; padding-left: 1ex"><br><br><div class="gmail_quote">On Wed, Jan 23, 2013 at 8:35 PM, Paulgir <span dir="ltr"><<a href="mailto:paulgir@gmail.com" target="_blank">paulgir@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
When I checked Mythtv (Mythbuntu)today I found it showing a language set up window that I had not seen before.I closed this window and was on the xfce desktop,I tried to start Myth frontend or mythbackend setup it reverts to the language set-up window.<br>
I tried to do a database restore but I get this message:<br>
<br></blockquote><div><br>What makes you think there is a database problem. Check systematically that:<br><br>1. mysql is running on the backend<br>2. mythbackend ditto<br>3. you have network connectivity to the backend.<br>
4. whether there are any crashed database tables that need repair. HINT if you are on mythbuntu run /etc/cron.weekly/mythtv-database<br>5. whether your ~/.mythtv/mysql.txt and ~/.mythtv/config.xml files have the right info.<br>
6. Look, yes look, at the logging file - particularly /var/log/mythtv/mythfrontend.log, or start mythfrontend from the command line and read the output.<br> <br><br> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Database Information:<br>
DBHostName: localhost<br>
DBPort: 3306<br>
DBUserName: mythtv<br>
DBPassword: XXX<br>
DBName: mythconverg<br>
DBSchemaVer:<br>
DBBackupDirectory: /var/lib/mythtv/db_backups<br>
DBBackupFilename: mythconverg-1299-20130122184502.sql.gz<br>
drop_database: no<br>
create_database: no<br>
<br>
Executables:<br>
mysql_client: mysql<br>
uncompress: gzip -d<br>
<br>
Miscellaneous:<br>
partial_restore: no<br>
restore_xmltvids: no<br>
change_hostname: no<br>
<br>
Checking database.<br>
<br>
Found 105 tables in the database.<br>
WARNING: Database not empty.<br>
<br>
ERROR: Unable to do a full restore. The database contains data<br>
<br>
<br>
<br>
<br>
<br>
So what am I doing wrong - any suggestions?<br>
<br>
The reason I tried to do a db restore was because I got some error messages when I tried myth_fill_database:<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
This version of MythTV requires an updated database. (schema is 1299 versions behind)<br>
<br>
Please run mythtv-setup or mythbackend to update your database.<br>
<br>
Database Host: localhost<br>
Database Name: mythconverg<br>
<br>
2013-01-23 19:49:17.500860 C ERROR: Unable to acquire database upgrade lock<br>
2013-01-23 19:49:17.500869 C Waiting for Database Upgrade to complete.<br>
2013-01-23 19:49:17.500880 C Timed out waiting.<br>
2013-01-23 19:49:17.500919 E Not allowed to upgrade the database.<br>
2013-01-23 19:49:17.502557 E Incorrect database schema<br>
2013-01-23 19:49:17.503042 E Error preparing query: INSERT INTO logging (host, application, pid, tid, thread, filename, line, function, msgtime, level, message) VALUES (:HOST, :APP, :PID, :TID, :THREAD, :FILENAME, :LINE, :FUNCTION, :MSGTIME, :LEVEL, :MESSAGE)<br>
mythfilldatabase<br>
<br>
<br>
<br>
<br>
Or is this a good time to install Mythbuntu 12.04?<br>
<br>
_______________________________________________<br>
mythtvnz mailing list<br>
<a href="mailto:mythtvnz@lists.linuxnut.co.nz" target="_blank">mythtvnz@lists.linuxnut.co.nz</a><br>
<a href="http://lists.ourshack.com/mailman/listinfo/mythtvnz" target="_blank">http://lists.ourshack.com/mailman/listinfo/mythtvnz</a><br>
Archives <a href="http://www.gossamer-threads.com/lists/mythtv/mythtvnz/" target="_blank">http://www.gossamer-threads.com/lists/mythtv/mythtvnz/</a><br>
</blockquote></div><br>
</blockquote><br><div>Thanks for the help.</div><div><br></div><div>I have performed a couple of the suggested procedures:<br></div><div><br></div><div>running /etc/cron.weekly/mythtv-database gives "database corrupt" and "file format" errors.</div><div><br></div><div>Starting mythfrontend from the command line give the error listed below among other similar messages:</div><div><br></div><div><br></div><div>2013-01-23 19:49:17.503042 E Error preparing query: INSERT INTO logging (host, application, pid, tid, thread, filename, line, function, msgtime, level, message) VALUES (:HOST, :APP, :PID, :TID, :THREAD, :FILENAME, :LINE, :FUNCTION, :MSGTIME, :LEVEL, :MESSAGE)<br>mythfilldatabase</div><div><br></div><div>I will have to look up how to repair crashed db tables - I assumed restoring a backed-up db would address that.</div><div><br></div><div>I might leave the rest till tomorrow.,</div><div><br></div><div>I was planning to upgrade the OS and mythtv,this may be the motivation to do that.</div><div><br></div><div>-Paul</div><div><br></div><div><br></div><div><br></div><div><br></div><br></body></html>