[mythtv-users] upgrade to 0.22 mythvideo schema upgrade failure

[sdkovacs]

The backend seems to have upgraded fine (ran mythtv-setup without any
problems), but when I run mythfrontend there is an error related to
upgrading the mythvideo schema.


Query was:
ALTER DATABASE mythconverg DEFAULT CHARACTER SET latin1;
Driver error was [2/1146]:
QMYSQL: Unable to execute query
Database error was:
Table 'mythconverg.videocountry' doesn't exist



mythfrontend log:

2009-11-08 01:22:38.604 mythfrontend version:
branches/release-0-22-fixes/mythtv/ [22750] www.mythtv.org
2009-11-08 01:22:38.623 Using runtime prefix = /usr
2009-11-08 01:22:38.623 Using configuration directory = /home/mythtv/.mythtv
2009-11-08 01:22:39.362 Empty LocalHostName.
2009-11-08 01:22:39.362 Using localhost value of mythbox
2009-11-08 01:22:39.553 New DB connection, total: 1
2009-11-08 01:22:39.558 Connected to database 'mythconverg' at host: localhost
2009-11-08 01:22:39.559 Closing DB connection named 'DBManager0'
2009-11-08 01:22:39.578 ScreenSaverX11Private: Gnome screen saver
support enabled
2009-11-08 01:22:39.579 DPMS is active.
2009-11-08 01:22:39.580 Primary screen: 0.
2009-11-08 01:22:39.581 Connected to database 'mythconverg' at host: localhost
2009-11-08 01:22:39.583 Running in a window
2009-11-08 01:22:39.583 Using screen 0, 720x480 at 0,0
2009-11-08 01:22:39.603 MythUI Image Cache size set to 20971520 bytes
2009-11-08 01:22:39.604 Enabled verbose msgs:  important general
2009-11-08 01:22:39.613 Primary screen: 0.
2009-11-08 01:22:39.614 Running in a window
2009-11-08 01:22:39.614 Using screen 0, 720x480 at 0,0
2009-11-08 01:22:39.615 Using theme base resolution of 800x600
2009-11-08 01:22:39.630 LIRC: Successfully initialized '/dev/lircd'
using '/home/mythtv/.mythtv/lircrc' config
2009-11-08 01:22:39.630 JoystickMenuThread Error: Joystick disabled -
Failed to read /home/mythtv/.mythtv/joystickmenurc
2009-11-08 01:22:39.797 Using the Qt painter
2009-11-08 01:22:39.840 Loaded base theme from
/usr/share/mythtv/themes/MythCenter/base.xml
2009-11-08 01:22:40.051 Loaded base theme from
/usr/share/mythtv/themes/default/base.xml
2009-11-08 01:22:40.059 Current MythTV Schema Version (DBSchemaVer): 1244
2009-11-08 01:22:44.005 Desktop video mode: 720x480 73.9044 Hz
2009-11-08 01:22:44.316 Registering Internal as a media playback plugin.
2009-11-08 01:22:44.363 Registering WebBrowser as a media playback plugin.
2009-11-08 01:22:44.452 MonitorRegisterExtensions(0x100, gif,jpg,png)
2009-11-08 01:22:44.543 Current MythMusic Schema Version
(MusicDBSchemaVer): 1017
2009-11-08 01:22:44.622 MonitorRegisterExtensions(0x40,
mp3,mp2,ogg,oga,flac,wma,wav,ac3,oma,omg,atp,ra,dts,aac,m4a,aa3,tta,mka,aiff,swa,wv)
2009-11-08 01:22:44.650 Current MythVideo Schema Version
(mythvideo.DBSchemaVer): 1016
2009-11-08 01:22:44.650 MythVideo database schema is old. Waiting to
see if DB is being upgraded.
2009-11-08 01:22:45.652 New DB connection, total: 2
2009-11-08 01:22:45.652 Connected to database 'mythconverg' at host: localhost
2009-11-08 01:22:45.658 Current MythVideo Schema Version
(mythvideo.DBSchemaVer): 1016
2009-11-08 01:22:46.664 Current MythVideo Schema Version
(mythvideo.DBSchemaVer): 1016
2009-11-08 01:22:47.670 Current MythVideo Schema Version
(mythvideo.DBSchemaVer): 1016
2009-11-08 01:22:47.670 Timed out waiting.
2009-11-08 01:22:47.686 Backing up database with script:
'/usr/share/mythtv/mythconverg_backup.pl'
2009-11-08 01:22:53.505 Database Backup complete.
2009-11-08 01:22:53.522 Backed up database to file:
'/videos/record/mythconverg-1244-20091108012247.sql.gz'
2009-11-08 01:23:16.551 Upgrading to MythVideo schema version 1017
2009-11-08 01:23:16.588 DB Error (performActualUpdate):
Query was:
ALTER DATABASE mythconverg DEFAULT CHARACTER SET latin1;
Driver error was [2/1146]:
QMYSQL: Unable to execute query
Database error was:
Table 'mythconverg.videocountry' doesn't exist

2009-11-08 01:23:16.588 Couldn't upgrade video database schema, exiting.
2009-11-08 01:23:16.588 Unable to initialize plugin 'mythvideo'.
2009-11-08 01:23:16.610 NetworkControl: Listening for remote
connections on port 6546
2009-11-08 01:23:16.612 Loading window theme from
/usr/share/mythtv/themes/MythCenter/menu-ui.xml
2009-11-08 01:23:16.837 Loading menu theme from
/usr/share/mythtv/themes/defaultmenu//mainmenu.xml
2009-11-08 01:23:16.842 Found mainmenu.xml for theme 'MythCenter'
2009-11-08 01:23:19.380 MythContext: Connecting to backend server:
192.168.0.5:6543 (try 1 of 1)
2009-11-08 01:23:19.381 Using protocol version 50