<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-<u></u>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>
______________________________<u></u>_________________<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/<u></u>mailman/listinfo/mythtvnz</a><br>
Archives <a href="http://www.gossamer-threads.com/lists/mythtv/mythtvnz/" target="_blank">http://www.gossamer-threads.<u></u>com/lists/mythtv/mythtvnz/</a><br>
</blockquote></div><br>