[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