[mythtv-users] db upgrade ? please help :)
fordy ydrof
fordy at ydrof.com
Sat Sep 21 18:15:32 UTC 2013
Hello Stephen, et al;
I restored my 0.24 DB again, and then I ran mythtvsetup. I'd welcome any
suggestions or insights on how to proceed.
thanks again
The output is as follows:
[myth at totally ~]$ mythtvsetup
2013-09-21 11:03:55.279488 I Setup Interrupt handler
2013-09-21 11:03:55.279507 I Setup Terminated handler
2013-09-21 11:03:55.279520 I Setup Segmentation fault handler
2013-09-21 11:03:55.279531 I Setup Aborted handler
2013-09-21 11:03:55.279542 I Setup Bus error handler
2013-09-21 11:03:55.279554 I Setup Floating point exception handler
2013-09-21 11:03:55.279566 I Setup Illegal instruction handler
2013-09-21 11:03:55.279579 I Setup Real-time signal 0 handler
2013-09-21 11:03:55.279669 C mythtv-setup version: fixes/0.26
[0.26.0-9.fc19 (v0.26.0-153-gb02d25a)] www.mythtv.org
2013-09-21 11:03:55.279676 C Qt version: compile: 4.8.4, runtime: 4.8.5
2013-09-21 11:03:55.279681 N Enabled verbose msgs: general
2013-09-21 11:03:55.279689 N Setting Log Level to LOG_INFO
2013-09-21 11:03:55.279962 N Using runtime prefix = /usr
2013-09-21 11:03:55.279980 N Using configuration directory =
/home/myth/.mythtv
2013-09-21 11:03:55.280050 I Added logging to the console
2013-09-21 11:03:55.280160 I Assumed character encoding: en_GB.utf8
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').
2013-09-21 11:03:55.281049 N Empty LocalHostName.
2013-09-21 11:03:55.281055 I Using localhost value of totally
2013-09-21 11:03:55.301912 N Desktop video mode: 3840x1200 60.000 Hz
2013-09-21 11:03:55.505551 I Added logging to mythlogserver at TCP:35327
2013-09-21 11:03:55.764156 E LIRC: Failed to connect to Unix socket
'/var/run/lirc/lircd'
eno: No such file or directory (2)
2013-09-21 11:03:55.764198 E JoystickMenuThread: Joystick disabled -
Failed to read /home/myth/.mythtv/joystickmenurc
2013-09-21 11:03:55.764210 I UDPListener: Enabling
2013-09-21 11:03:55.768302 I Binding to UDP 127.0.0.1:0
2013-09-21 11:03:55.768464 I Binding to UDP 192.168.1.200:0
2013-09-21 11:03:55.768791 I Binding to UDP [::1]:0
2013-09-21 11:03:55.769138 I Binding to UDP [2001:470:67:368::49]:0
2013-09-21 11:03:55.769472 I Binding to UDP
[fe80::21b:fcff:fed2:a6be%em1]:0
2013-09-21 11:03:55.769635 I Binding to UDP 192.168.1.255:0
2013-09-21 11:03:55.781229 I Using Frameless Window
2013-09-21 11:03:55.781260 I Using Full Screen Window
2013-09-21 11:03:55.783493 I Using the Qt painter
2013-09-21 11:03:56.061220 N Setting QT default locale to en_GB
2013-09-21 11:03:56.266352 I System Locale (en_GB), Country (GB), Language
(en)
2013-09-21 11:04:01.183625 I Loading en_gb translation for module
mythfrontend
2013-09-21 11:04:01.188942 N Setting QT default locale to en_GB
2013-09-21 11:04:01.189078 I Current locale en_GB
2013-09-21 11:04:01.189165 N Reading locale defaults from
/usr/share/mythtv//locales/en_gb.xml
2013-09-21 11:04:01.189816 E SaveSettingOnHost('FreqTable') - No database
yet
2013-09-21 11:04:01.189828 E SaveSettingOnHost('ISO639Language0') - No
database yet
2013-09-21 11:04:01.189836 E SaveSettingOnHost('ISO639Language1') - No
database yet
2013-09-21 11:04:01.189843 E SaveSettingOnHost('TVFormat') - No database
yet
2013-09-21 11:04:01.189850 E SaveSettingOnHost('VbiFormat') - No database
yet
2013-09-21 11:04:01.189857 E SaveSettingOnHost('prefDupMethod') - No
database yet
2013-09-21 11:04:01.189870 E SaveSettingOnHost('DateFormat') - No database
yet
2013-09-21 11:04:01.189880 E SaveSettingOnHost('EnableMHEG') - No database
yet
2013-09-21 11:04:01.189892 E SaveSettingOnHost('MythArchiveVideoFormat') -
No database yet
2013-09-21 11:04:01.189902 E SaveSettingOnHost('ShortDateFormat') - No
database yet
2013-09-21 11:04:01.189925 E SaveSettingOnHost('TimeFormat') - No database
yet
2013-09-21 11:04:01.190403 I Starting process manager
2013-09-21 11:04:01.193951 I Starting process signal handler
2013-09-21 11:04:01.194208 I Starting IO manager (read)
2013-09-21 11:04:01.194274 I Starting IO manager (write)
2013-09-21 11:04:01.295096 I ScreenSaverX11Private: DPMS is active.
2013-09-21 11:04:01.308242 N Inserting MythTV initial database information.
2013-09-21 11:04:01.308265 C Upgrading to MythTV schema version 1307
2013-09-21 11:04:01.308500 E DB Error (Performing database upgrade):
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;
Error was: Driver error was [2/1050]:
QMYSQL: Unable to execute query
Database error was:
Table 'callsignnetworkmap' already exists
then running mythtvsetup again re-asks for my country/language and results
in this:
[myth at totally ~]$ mythtvsetup
2013-09-21 11:09:10.852216 I Setup Interrupt handler
2013-09-21 11:09:10.852235 I Setup Terminated handler
2013-09-21 11:09:10.852247 I Setup Segmentation fault handler
2013-09-21 11:09:10.852259 I Setup Aborted handler
2013-09-21 11:09:10.852270 I Setup Bus error handler
2013-09-21 11:09:10.852281 I Setup Floating point exception handler
2013-09-21 11:09:10.852293 I Setup Illegal instruction handler
2013-09-21 11:09:10.852306 I Setup Real-time signal 0 handler
2013-09-21 11:09:10.852395 C mythtv-setup version: fixes/0.26
[0.26.0-9.fc19 (v0.26.0-153-gb02d25a)] www.mythtv.org
2013-09-21 11:09:10.852403 C Qt version: compile: 4.8.4, runtime: 4.8.5
2013-09-21 11:09:10.852408 N Enabled verbose msgs: general
2013-09-21 11:09:10.852416 N Setting Log Level to LOG_INFO
2013-09-21 11:09:10.852680 N Using runtime prefix = /usr
2013-09-21 11:09:10.852698 N Using configuration directory =
/home/myth/.mythtv
2013-09-21 11:09:10.852798 I Assumed character encoding: en_GB.utf8
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').
2013-09-21 11:09:10.852884 I Added logging to the console
2013-09-21 11:09:10.853736 N Empty LocalHostName.
2013-09-21 11:09:10.853754 I Using localhost value of totally
2013-09-21 11:09:10.874822 N Desktop video mode: 3840x1200 60.000 Hz
2013-09-21 11:09:11.080870 I Starting mythlogserver
2013-09-21 11:09:11.081150 I Starting process manager
2013-09-21 11:09:11.081201 I Starting process signal handler
2013-09-21 11:09:11.081271 I Starting IO manager (read)
2013-09-21 11:09:11.083241 I Starting IO manager (write)
2013-09-21 11:09:11.349701 E LIRC: Failed to connect to Unix socket
'/var/run/lirc/lircd'
eno: No such file or directory (2)
2013-09-21 11:09:11.349740 E JoystickMenuThread: Joystick disabled -
Failed to read /home/myth/.mythtv/joystickmenurc
2013-09-21 11:09:11.349750 I UDPListener: Enabling
2013-09-21 11:09:11.351872 I Binding to UDP 127.0.0.1:0
2013-09-21 11:09:11.352042 I Binding to UDP 192.168.1.200:0
2013-09-21 11:09:11.352365 I Binding to UDP [::1]:0
2013-09-21 11:09:11.352701 I Binding to UDP [2001:470:67:368::49]:0
2013-09-21 11:09:11.353051 I Binding to UDP
[fe80::21b:fcff:fed2:a6be%em1]:0
2013-09-21 11:09:11.353219 I Binding to UDP 192.168.1.255:0
2013-09-21 11:09:11.365173 I Using Frameless Window
2013-09-21 11:09:11.365211 I Using Full Screen Window
2013-09-21 11:09:11.367539 I Using the Qt painter
2013-09-21 11:09:11.382262 I Added logging to mythlogserver at TCP:35327
2013-09-21 11:09:11.716466 N Setting QT default locale to en_GB
2013-09-21 11:09:11.905581 I System Locale (en_GB), Country (GB), Language
(en)
2013-09-21 11:09:15.716059 I Loading en_gb translation for module
mythfrontend
2013-09-21 11:09:15.721335 N Setting QT default locale to en_GB
2013-09-21 11:09:15.721436 I Current locale en_GB
2013-09-21 11:09:15.721480 N Reading locale defaults from
/usr/share/mythtv//locales/en_gb.xml
2013-09-21 11:09:15.721746 E SaveSettingOnHost('FreqTable') - No database
yet
2013-09-21 11:09:15.721753 E SaveSettingOnHost('ISO639Language0') - No
database yet
2013-09-21 11:09:15.721758 E SaveSettingOnHost('ISO639Language1') - No
database yet
2013-09-21 11:09:15.721763 E SaveSettingOnHost('TVFormat') - No database
yet
2013-09-21 11:09:15.721768 E SaveSettingOnHost('VbiFormat') - No database
yet
2013-09-21 11:09:15.721772 E SaveSettingOnHost('prefDupMethod') - No
database yet
2013-09-21 11:09:15.721782 E SaveSettingOnHost('DateFormat') - No database
yet
2013-09-21 11:09:15.721789 E SaveSettingOnHost('EnableMHEG') - No database
yet
2013-09-21 11:09:15.721796 E SaveSettingOnHost('MythArchiveVideoFormat') -
No database yet
2013-09-21 11:09:15.721803 E SaveSettingOnHost('ShortDateFormat') - No
database yet
2013-09-21 11:09:15.721810 E SaveSettingOnHost('TimeFormat') - No database
yet
2013-09-21 11:09:15.789986 I ScreenSaverX11Private: DPMS is active.
2013-09-21 11:09:15.804429 N Inserting MythTV initial database information.
2013-09-21 11:09:15.804452 C Upgrading to MythTV schema version 1307
2013-09-21 11:09:15.804679 E DB Error (Performing database upgrade):
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;
Error was: Driver error was [2/1050]:
QMYSQL: Unable to execute query
Database error was:
Table 'callsignnetworkmap' already exists
new version: 1307
On Fri, Sep 20, 2013 at 11:13 PM, Stephen Worthington <
stephen_agent at jsw.gen.nz> wrote:
> On Fri, 20 Sep 2013 16:28:27 -0700, you wrote:
>
> >Hello All,
> >
> > Background: I was happily running fedora 14 and mythtv .24 -- until my
> >boot/OS drive failed.
> >
> > I bought a new drive and loaded it up with current Fedora (19) and
> >installed mythtv (.26)
> >
> > I've been able to recover the mysql db mythconverg (though, i dont have
> >good exported backups i'm afraid), and when I attempted to upgrade (.24 ->
> >.26) on a copy of mythconverg (i still have the state of the DB at the
> time
> >of the hard drive crash, but i no longer have a place to run fedora 14 or
> >myth .24)
> >
> >mythtv has partially updated DB schemas, but now seem to be stuck here now
> >unable to upgrade further:
> >Warning: MythTV wants to upgrade your database,
> >for the TV schema, from 1271 to 1307.
> >
> >
> >any suggestions? what are my options at this point? I'd like of course to
> >retain my data about episodes recorded etc.. not looking forward to a
> clean
> >slate and re-recording shows i've already watched..
> >
> >
> >thanks in advance
>
> The best way to update DB schemas is to use mythtv-setup. So if you
> restore your 0.24 database again, then make sure that you do not run
> mythbackend, and instead run mythtv-setup, you should get prompts to
> update the schema. Remember that it will first make a backup of the
> database before it upgrades it. If your database is huge like mine (>
> 5000 recordings), that can take quite a while and there is no visible
> activity on screen for minutes while it happens. Then the upgrade
> prompts will finally appear.
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/listinfo/mythtv-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20130921/e4826d6c/attachment.html>
More information about the mythtv-users
mailing list