<div dir="ltr">i think my last email can be safely ignored (sorry). I re-deleted mythconverg and copied it over again from the backup and this time set the permissions to mysql:mysql -- the output of mythtvsetup is below. and again, I'd apprecate any help:) thanks<br>
<br><br>[myth@totally ~]$ mythtvsetup <br>2013-09-21 11:31:25.979816 I Setup Interrupt handler<br>2013-09-21 11:31:25.979835 I Setup Terminated handler<br>2013-09-21 11:31:25.979848 I Setup Segmentation fault handler<br>
2013-09-21 11:31:25.979860 I Setup Aborted handler<br>2013-09-21 11:31:25.979871 I Setup Bus error handler<br>2013-09-21 11:31:25.979883 I Setup Floating point exception handler<br>2013-09-21 11:31:25.979895 I Setup Illegal instruction handler<br>
2013-09-21 11:31:25.979920 I Setup Real-time signal 0 handler<br>2013-09-21 11:31:25.980019 C mythtv-setup version: fixes/0.26 [0.26.0-9.fc19 (v0.26.0-153-gb02d25a)] <a href="http://www.mythtv.org">www.mythtv.org</a><br>
2013-09-21 11:31:25.980027 C Qt version: compile: 4.8.4, runtime: 4.8.5<br>2013-09-21 11:31:25.980032 N Enabled verbose msgs: general<br>2013-09-21 11:31:25.980040 N Setting Log Level to LOG_INFO<br>2013-09-21 11:31:25.980359 N Using runtime prefix = /usr<br>
2013-09-21 11:31:25.980377 N Using configuration directory = /home/myth/.mythtv<br>2013-09-21 11:31:25.980491 I Assumed character encoding: en_GB.utf8<br>2013-09-21 11:31:25.980502 I Added logging to the console<br>2013-09-21 11:31:25.980505 W This application expects to be running a locale that specifies a UTF-8 codeset, and many features may behave improperly with your current language settings. Please set the LC_ALL or LC_CTYPE, and LANG variable(s) in the environment in which this program is executed to include a UTF-8 codeset (such as 'en_US.UTF-8').<br>
2013-09-21 11:31:25.980974 N Empty LocalHostName.<br>2013-09-21 11:31:25.980981 I Using localhost value of totally<br>2013-09-21 11:31:25.999983 N Setting QT default locale to EN_US<br>2013-09-21 11:31:26.000070 I Current locale EN_US<br>
2013-09-21 11:31:26.000114 N Reading locale defaults from /usr/share/mythtv//locales/en_us.xml<br>2013-09-21 11:31:26.008137 I Starting process manager<br>2013-09-21 11:31:26.008156 I Starting process signal handler<br>
2013-09-21 11:31:26.012650 I Starting IO manager (read)<br>2013-09-21 11:31:26.012792 I Starting IO manager (write)<br>2013-09-21 11:31:26.109240 I ScreenSaverX11Private: DPMS is active.<br>2013-09-21 11:31:26.123847 N Desktop video mode: 3840x1200 60.000 Hz<br>
2013-09-21 11:31:26.209334 I Added logging to mythlogserver at TCP:35327<br>2013-09-21 11:31:26.574544 W MythUIHelper: No theme dir: '/usr/share/mythtv/themes/metallurgy'<br>2013-09-21 11:31:26.574556 E MythUIHelper: Could not find theme: metallurgy - Switching to Terra<br>
2013-09-21 11:31:26.578248 I Loading en_us translation for module mythfrontend<br>2013-09-21 11:31:26.578680 E LIRC: Failed to connect to Unix socket '/var/run/lirc/lircd'<br> eno: No such file or directory (2)<br>
2013-09-21 11:31:26.578707 E JoystickMenuThread: Joystick disabled - Failed to read /home/myth/.mythtv/joystickmenurc<br>2013-09-21 11:31:26.578714 I UDPListener: Enabling<br>2013-09-21 11:31:26.581518 I Binding to UDP <a href="http://127.0.0.1:6948">127.0.0.1:6948</a><br>
2013-09-21 11:31:26.581624 I Binding to UDP <a href="http://192.168.1.200:6948">192.168.1.200:6948</a><br>2013-09-21 11:31:26.581841 I Binding to UDP [::1]:6948<br>2013-09-21 11:31:26.582073 I Binding to UDP [2001:470:67:368::49]:6948<br>
2013-09-21 11:31:26.582298 I Binding to UDP [fe80::21b:fcff:fed2:a6be%em1]:6948<br>2013-09-21 11:31:26.582407 I Binding to UDP <a href="http://192.168.1.255:6948">192.168.1.255:6948</a><br>2013-09-21 11:31:26.596251 W Key Esc is bound to multiple actions in context Main Menu.<br>
2013-09-21 11:31:26.606954 I Using Frameless Window<br>2013-09-21 11:31:26.606976 I Using Full Screen Window<br>2013-09-21 11:31:26.609850 I Using the Qt painter<br>2013-09-21 11:31:27.021781 I Current MythTV Schema Version (DBSchemaVer): 1271<br>
2013-09-21 11:31:27.038973 E Backing up database with script: '/usr/share/mythtv/<a href="http://mythconverg_backup.pl">mythconverg_backup.pl</a>'<br>2013-09-21 11:32:35.396340 E DBUtil: Error backing up database: /usr/share/mythtv/<a href="http://mythconverg_backup.pl">mythconverg_backup.pl</a> /tmp/mythtv_db_backup_conf_jDIipl (2)<br>
2013-09-21 11:32:35.396370 C Script-based database backup failed. Retrying with internal backup.<br>2013-09-21 11:32:35.399872 C Backing up database to file: '/mnt/store5/mythtv_db_backups/mythconverg-1271-20130921183235.sql'<br>
2013-09-21 11:32:35.496529 E DBUtil: Error backing up database: 'mysqldump --defaults-extra-file='/tmp/mythtv_db_backup_conf_gSZyAm' --host='localhost' --port='3306' --user='mythtv' --add-drop-table --add-locks --allow-keywords --complete-insert --extended-insert --lock-tables --no-create-db --quick 'mythconverg' > '/mnt/store5/mythtv_db_backups/mythconverg-1271-20130921183235.sql' 2>/dev/null' (2)<br>
2013-09-21 11:33:58.961380 C Upgrading to MythTV schema version 1272<br>2013-09-21 11:33:58.961943 E DB Error (Performing database upgrade): <br>Query was: ALTER TABLE recordmatch MODIFY recordid INT UNSIGNED NOT NULL; <br>
Error was: Driver error was [2/144]:<br>QMYSQL: Unable to execute query<br>Database error was:<br>Table './mythconverg/recordmatch' is marked as crashed and last (automatic?) repair failed<br> <br>new version: 1272<br>
2013-09-21 11:33:58.961961 E Database schema upgrade failed.<br>2013-09-21 11:33:58.962206 E Couldn't upgrade database to new schema.<br>[myth@totally ~]$ <br><br></div><div class="gmail_extra"><br><br><div class="gmail_quote">
On Sat, Sep 21, 2013 at 11:15 AM, fordy ydrof <span dir="ltr"><<a href="mailto:fordy@ydrof.com" target="_blank">fordy@ydrof.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr"><div><div>Hello Stephen, et al;<br></div> I restored my 0.24 DB again, and then I ran mythtvsetup. I'd welcome any suggestions or insights on how to proceed. <br><br>thanks again<br><br>The output is as follows: <br>
<br><br>[myth@totally ~]$ mythtvsetup <br>2013-09-21 11:03:55.279488 I Setup Interrupt handler<br>2013-09-21 11:03:55.279507 I Setup Terminated handler<br>2013-09-21 11:03:55.279520 I Setup Segmentation fault handler<br>
2013-09-21 11:03:55.279531 I Setup Aborted handler<br>2013-09-21 11:03:55.279542 I Setup Bus error handler<br>2013-09-21 11:03:55.279554 I Setup Floating point exception handler<br>2013-09-21 11:03:55.279566 I Setup Illegal instruction handler<br>
2013-09-21 11:03:55.279579 I Setup Real-time signal 0 handler<br>2013-09-21 11:03:55.279669 C mythtv-setup version: fixes/0.26 [0.26.0-9.fc19 (v0.26.0-153-gb02d25a)] <a href="http://www.mythtv.org" target="_blank">www.mythtv.org</a><br>
2013-09-21 11:03:55.279676 C Qt version: compile: 4.8.4, runtime: 4.8.5<br>2013-09-21 11:03:55.279681 N Enabled verbose msgs: general<br>2013-09-21 11:03:55.279689 N Setting Log Level to LOG_INFO<br>2013-09-21 11:03:55.279962 N Using runtime prefix = /usr<br>
2013-09-21 11:03:55.279980 N Using configuration directory = /home/myth/.mythtv<br>2013-09-21 11:03:55.280050 I Added logging to the console<br>2013-09-21 11:03:55.280160 I Assumed character encoding: en_GB.utf8<br>2013-09-21 11:03:55.280171 W This application expects to be running a locale that specifies a UTF-8 codeset, and many features may behave improperly with your current language settings. Please set the LC_ALL or LC_CTYPE, and LANG variable(s) in the environment in which this program is executed to include a UTF-8 codeset (such as 'en_US.UTF-8').<br>
2013-09-21 11:03:55.281049 N Empty LocalHostName.<br>2013-09-21 11:03:55.281055 I Using localhost value of totally<br>2013-09-21 11:03:55.301912 N Desktop video mode: 3840x1200 60.000 Hz<br>2013-09-21 11:03:55.505551 I Added logging to mythlogserver at TCP:35327<br>
2013-09-21 11:03:55.764156 E LIRC: Failed to connect to Unix socket '/var/run/lirc/lircd'<br> eno: No such file or directory (2)<br>2013-09-21 11:03:55.764198 E JoystickMenuThread: Joystick disabled - Failed to read /home/myth/.mythtv/joystickmenurc<br>
2013-09-21 11:03:55.764210 I UDPListener: Enabling<br>2013-09-21 11:03:55.768302 I Binding to UDP <a href="http://127.0.0.1:0" target="_blank">127.0.0.1:0</a><br>2013-09-21 11:03:55.768464 I Binding to UDP <a href="http://192.168.1.200:0" target="_blank">192.168.1.200:0</a><br>
2013-09-21 11:03:55.768791 I Binding to UDP [::1]:0<br>2013-09-21 11:03:55.769138 I Binding to UDP [2001:470:67:368::49]:0<br>2013-09-21 11:03:55.769472 I Binding to UDP [fe80::21b:fcff:fed2:a6be%em1]:0<br>2013-09-21 11:03:55.769635 I Binding to UDP <a href="http://192.168.1.255:0" target="_blank">192.168.1.255:0</a><br>
2013-09-21 11:03:55.781229 I Using Frameless Window<br>2013-09-21 11:03:55.781260 I Using Full Screen Window<br>2013-09-21 11:03:55.783493 I Using the Qt painter<br>2013-09-21 11:03:56.061220 N Setting QT default locale to en_GB<br>
2013-09-21 11:03:56.266352 I System Locale (en_GB), Country (GB), Language (en)<br>2013-09-21 11:04:01.183625 I Loading en_gb translation for module mythfrontend<br>2013-09-21 11:04:01.188942 N Setting QT default locale to en_GB<br>
2013-09-21 11:04:01.189078 I Current locale en_GB<br>2013-09-21 11:04:01.189165 N Reading locale defaults from /usr/share/mythtv//locales/en_gb.xml<br>2013-09-21 11:04:01.189816 E SaveSettingOnHost('FreqTable') - No database yet<br>
2013-09-21 11:04:01.189828 E SaveSettingOnHost('ISO639Language0') - No database yet<br>2013-09-21 11:04:01.189836 E SaveSettingOnHost('ISO639Language1') - No database yet<br>2013-09-21 11:04:01.189843 E SaveSettingOnHost('TVFormat') - No database yet<br>
2013-09-21 11:04:01.189850 E SaveSettingOnHost('VbiFormat') - No database yet<br>2013-09-21 11:04:01.189857 E SaveSettingOnHost('prefDupMethod') - No database yet<br>2013-09-21 11:04:01.189870 E SaveSettingOnHost('DateFormat') - No database yet<br>
2013-09-21 11:04:01.189880 E SaveSettingOnHost('EnableMHEG') - No database yet<br>2013-09-21 11:04:01.189892 E SaveSettingOnHost('MythArchiveVideoFormat') - No database yet<br>2013-09-21 11:04:01.189902 E SaveSettingOnHost('ShortDateFormat') - No database yet<br>
2013-09-21 11:04:01.189925 E SaveSettingOnHost('TimeFormat') - No database yet<br>2013-09-21 11:04:01.190403 I Starting process manager<br>2013-09-21 11:04:01.193951 I Starting process signal handler<br>2013-09-21 11:04:01.194208 I Starting IO manager (read)<br>
2013-09-21 11:04:01.194274 I Starting IO manager (write)<br>2013-09-21 11:04:01.295096 I ScreenSaverX11Private: DPMS is active.<br>2013-09-21 11:04:01.308242 N Inserting MythTV initial database information.<br>2013-09-21 11:04:01.308265 C Upgrading to MythTV schema version 1307<br>
2013-09-21 11:04:01.308500 E DB Error (Performing database upgrade): <br>Query was: CREATE TABLE callsignnetworkmap ( id int(11) NOT NULL AUTO_INCREMENT, callsign varchar(20) NOT NULL DEFAULT '', network varchar(20) NOT NULL DEFAULT '', PRIMARY KEY (id), UNIQUE KEY callsign (callsign)) ENGINE=MyISAM DEFAULT CHARSET=utf8; <br>
Error was: Driver error was [2/1050]:<br>QMYSQL: Unable to execute query<br>Database error was:<br>Table 'callsignnetworkmap' already exists<br> <br><br></div>then running mythtvsetup again re-asks for my country/language and results in this:<br>
<br>[myth@totally ~]$ mythtvsetup <br>2013-09-21 11:09:10.852216 I Setup Interrupt handler<br>2013-09-21 11:09:10.852235 I Setup Terminated handler<br>2013-09-21 11:09:10.852247 I Setup Segmentation fault handler<br>2013-09-21 11:09:10.852259 I Setup Aborted handler<br>
2013-09-21 11:09:10.852270 I Setup Bus error handler<br>2013-09-21 11:09:10.852281 I Setup Floating point exception handler<br>2013-09-21 11:09:10.852293 I Setup Illegal instruction handler<br>2013-09-21 11:09:10.852306 I Setup Real-time signal 0 handler<br>
2013-09-21 11:09:10.852395 C mythtv-setup version: fixes/0.26 [0.26.0-9.fc19 (v0.26.0-153-gb02d25a)] <a href="http://www.mythtv.org" target="_blank">www.mythtv.org</a><br>2013-09-21 11:09:10.852403 C Qt version: compile: 4.8.4, runtime: 4.8.5<br>
2013-09-21 11:09:10.852408 N Enabled verbose msgs: general<br>2013-09-21 11:09:10.852416 N Setting Log Level to LOG_INFO<br>2013-09-21 11:09:10.852680 N Using runtime prefix = /usr<br>2013-09-21 11:09:10.852698 N Using configuration directory = /home/myth/.mythtv<br>
2013-09-21 11:09:10.852798 I Assumed character encoding: en_GB.utf8<br>2013-09-21 11:09:10.852809 W This application expects to be running a locale that specifies a UTF-8 codeset, and many features may behave improperly with your current language settings. Please set the LC_ALL or LC_CTYPE, and LANG variable(s) in the environment in which this program is executed to include a UTF-8 codeset (such as 'en_US.UTF-8').<br>
2013-09-21 11:09:10.852884 I Added logging to the console<br>2013-09-21 11:09:10.853736 N Empty LocalHostName.<br>2013-09-21 11:09:10.853754 I Using localhost value of totally<br>2013-09-21 11:09:10.874822 N Desktop video mode: 3840x1200 60.000 Hz<br>
2013-09-21 11:09:11.080870 I Starting mythlogserver<br>2013-09-21 11:09:11.081150 I Starting process manager<br>2013-09-21 11:09:11.081201 I Starting process signal handler<br>2013-09-21 11:09:11.081271 I Starting IO manager (read)<br>
2013-09-21 11:09:11.083241 I Starting IO manager (write)<br>2013-09-21 11:09:11.349701 E LIRC: Failed to connect to Unix socket '/var/run/lirc/lircd'<br> eno: No such file or directory (2)<br>2013-09-21 11:09:11.349740 E JoystickMenuThread: Joystick disabled - Failed to read /home/myth/.mythtv/joystickmenurc<br>
2013-09-21 11:09:11.349750 I UDPListener: Enabling<br>2013-09-21 11:09:11.351872 I Binding to UDP <a href="http://127.0.0.1:0" target="_blank">127.0.0.1:0</a><br>2013-09-21 11:09:11.352042 I Binding to UDP <a href="http://192.168.1.200:0" target="_blank">192.168.1.200:0</a><br>
2013-09-21 11:09:11.352365 I Binding to UDP [::1]:0<br>2013-09-21 11:09:11.352701 I Binding to UDP [2001:470:67:368::49]:0<br>2013-09-21 11:09:11.353051 I Binding to UDP [fe80::21b:fcff:fed2:a6be%em1]:0<br>2013-09-21 11:09:11.353219 I Binding to UDP <a href="http://192.168.1.255:0" target="_blank">192.168.1.255:0</a><br>
2013-09-21 11:09:11.365173 I Using Frameless Window<br>2013-09-21 11:09:11.365211 I Using Full Screen Window<br>2013-09-21 11:09:11.367539 I Using the Qt painter<br>2013-09-21 11:09:11.382262 I Added logging to mythlogserver at TCP:35327<br>
2013-09-21 11:09:11.716466 N Setting QT default locale to en_GB<br>2013-09-21 11:09:11.905581 I System Locale (en_GB), Country (GB), Language (en)<br>2013-09-21 11:09:15.716059 I Loading en_gb translation for module mythfrontend<br>
2013-09-21 11:09:15.721335 N Setting QT default locale to en_GB<br>2013-09-21 11:09:15.721436 I Current locale en_GB<br>2013-09-21 11:09:15.721480 N Reading locale defaults from /usr/share/mythtv//locales/en_gb.xml<br>
2013-09-21 11:09:15.721746 E SaveSettingOnHost('FreqTable') - No database yet<br>2013-09-21 11:09:15.721753 E SaveSettingOnHost('ISO639Language0') - No database yet<br>2013-09-21 11:09:15.721758 E SaveSettingOnHost('ISO639Language1') - No database yet<br>
2013-09-21 11:09:15.721763 E SaveSettingOnHost('TVFormat') - No database yet<br>2013-09-21 11:09:15.721768 E SaveSettingOnHost('VbiFormat') - No database yet<br>2013-09-21 11:09:15.721772 E SaveSettingOnHost('prefDupMethod') - No database yet<br>
2013-09-21 11:09:15.721782 E SaveSettingOnHost('DateFormat') - No database yet<br>2013-09-21 11:09:15.721789 E SaveSettingOnHost('EnableMHEG') - No database yet<br>2013-09-21 11:09:15.721796 E SaveSettingOnHost('MythArchiveVideoFormat') - No database yet<br>
2013-09-21 11:09:15.721803 E SaveSettingOnHost('ShortDateFormat') - No database yet<br>2013-09-21 11:09:15.721810 E SaveSettingOnHost('TimeFormat') - No database yet<br>2013-09-21 11:09:15.789986 I ScreenSaverX11Private: DPMS is active.<br>
2013-09-21 11:09:15.804429 N Inserting MythTV initial database information.<br>2013-09-21 11:09:15.804452 C Upgrading to MythTV schema version 1307<br>2013-09-21 11:09:15.804679 E DB Error (Performing database upgrade): <br>
Query was: CREATE TABLE callsignnetworkmap ( id int(11) NOT NULL AUTO_INCREMENT, callsign varchar(20) NOT NULL DEFAULT '', network varchar(20) NOT NULL DEFAULT '', PRIMARY KEY (id), UNIQUE KEY callsign (callsign)) ENGINE=MyISAM DEFAULT CHARSET=utf8; <br>
Error was: Driver error was [2/1050]:<br>QMYSQL: Unable to execute query<br>Database error was:<br>Table 'callsignnetworkmap' already exists<br> <br>new version: 1307<br><br><div><br></div></div><div class="HOEnZb">
<div class="h5"><div class="gmail_extra">
<br><br><div class="gmail_quote">On Fri, Sep 20, 2013 at 11:13 PM, Stephen Worthington <span dir="ltr"><<a href="mailto:stephen_agent@jsw.gen.nz" target="_blank">stephen_agent@jsw.gen.nz</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><div>On Fri, 20 Sep 2013 16:28:27 -0700, you wrote:<br>
<br>
>Hello All,<br>
><br>
> Background: I was happily running fedora 14 and mythtv .24 -- until my<br>
>boot/OS drive failed.<br>
><br>
> I bought a new drive and loaded it up with current Fedora (19) and<br>
>installed mythtv (.26)<br>
><br>
> I've been able to recover the mysql db mythconverg (though, i dont have<br>
>good exported backups i'm afraid), and when I attempted to upgrade (.24 -><br>
>.26) on a copy of mythconverg (i still have the state of the DB at the time<br>
>of the hard drive crash, but i no longer have a place to run fedora 14 or<br>
>myth .24)<br>
><br>
>mythtv has partially updated DB schemas, but now seem to be stuck here now<br>
>unable to upgrade further:<br>
>Warning: MythTV wants to upgrade your database,<br>
>for the TV schema, from 1271 to 1307.<br>
><br>
><br>
>any suggestions? what are my options at this point? I'd like of course to<br>
>retain my data about episodes recorded etc.. not looking forward to a clean<br>
>slate and re-recording shows i've already watched..<br>
><br>
><br>
>thanks in advance<br>
<br>
</div></div>The best way to update DB schemas is to use mythtv-setup. So if you<br>
restore your 0.24 database again, then make sure that you do not run<br>
mythbackend, and instead run mythtv-setup, you should get prompts to<br>
update the schema. Remember that it will first make a backup of the<br>
database before it upgrades it. If your database is huge like mine (><br>
5000 recordings), that can take quite a while and there is no visible<br>
activity on screen for minutes while it happens. Then the upgrade<br>
prompts will finally appear.<br>
_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
<a href="http://www.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://www.mythtv.org/mailman/listinfo/mythtv-users</a><br>
</blockquote></div><br></div>
</div></div></blockquote></div><br></div>