<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">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">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">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">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">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">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">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">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="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 class="HOEnZb"><div class="h5">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">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>