[mythtv-users] Mythfrontend doesn't update database to new schema

[James Pifer]

On Mon, 2011-08-01 at 10:09 -0400, Michael T. Dean wrote:
> James, from the limited information here, it sounds like mythfrontend is 
> unable to connect to mythbackend, so it actually exits with error before 
> it gets around to updating the plugin schemas.  If you could post the 
> full (uncut) log output of an attempt to run mythfrontend (here or to a 
> pastebin), I can look it over and see if it provides more information.
> 
> Oh, and just because they're the first few items on the support team 
> checklist ;), are you sure a) that mythbackend is running properly, b) 
> that you've properly set the IP address for the master backend, and c) 
> that your config.xml and mysql.txt files are all correct (regardless of 
> where on the system they're located)?
> 
> Thanks,
> Mike

Mike,

Thanks for the response, I appreciate the help! Apparently I have a
table missing? 

Thanks,
James

Here's my mythfrontend output:

mythtv at mythtv:~> mythfrontend
2011-08-01 13:57:39.779 mythfrontend version:  [v0.24.1] www.mythtv.org
2011-08-01 13:57:39.779 Using runtime prefix = /usr
2011-08-01 13:57:39.779 Using configuration directory = /home/mythtv/.mythtv
2011-08-01 13:57:39.780 ThreadPool:HTTP: Initial 1, Max 25, Timeout 60000
2011-08-01 13:57:40.212 Unable to read configuration file mysql.txt
2011-08-01 13:57:40.212 Empty LocalHostName.
2011-08-01 13:57:40.212 Using localhost value of mythtv
2011-08-01 13:57:40.219 New DB connection, total: 1
2011-08-01 13:57:40.222 Connected to database 'mythconverg' at host: localhost
2011-08-01 13:57:40.224 Closing DB connection named 'DBManager0'
2011-08-01 13:57:40.225 Connected to database 'mythconverg' at host: localhost
2011-08-01 13:57:40.227 Current locale en_US
2011-08-01 13:57:40.227 Reading locale defaults from /usr/share/mythtv//locales/en_us.xml
2011-08-01 13:57:40.438 ScreenSaverX11Private: Gnome screen saver support enabled
2011-08-01 13:57:40.444 DPMS is active.
2011-08-01 13:57:40.505 Desktop video mode: 1024x768 75.000 Hz
2011-08-01 13:57:40.645 Enabled verbose msgs:  important general
2011-08-01 13:57:40.648 Loading en_us translation for module mythfrontend
2011-08-01 13:57:40.663 LIRC, Error: Failed to connect to Unix socket '/var/run/lirc/lircd'
			eno: No such file or directory (2)
2011-08-01 13:57:40.663 JoystickMenuThread: Joystick disabled - Failed to read /home/mythtv/.mythtv/joystickmenurc
2011-08-01 13:57:40.695 Using Frameless Window
2011-08-01 13:57:40.695 Using Full Screen Window
2011-08-01 13:57:41.260 Using the Qt painter
2011-08-01 13:57:41.601 Current MythTV Schema Version (DBSchemaVer): 1264
2011-08-01 13:57:42.081 Pulse err: Context not ready after 1000ms
2011-08-01 13:57:43.144 Registering Internal as a media playback plugin.
2011-08-01 13:57:43.164 Loading en_us translation for module mytharchive
2011-08-01 13:57:43.168 Registering WebBrowser as a media playback plugin.
2011-08-01 13:57:43.168 Loading en_us translation for module mythbrowser
2011-08-01 13:57:43.189 MonitorRegisterExtensions(0x100, gif,jpg,png)
2011-08-01 13:57:43.189 Loading en_us translation for module mythgallery
2011-08-01 13:57:43.195 Loading en_us translation for module mythgame
2011-08-01 13:57:43.210 Current MythMusic Schema Version (MusicDBSchemaVer): 1017
2011-08-01 13:57:43.244 MonitorRegisterExtensions(0x40, mp3,mp2,ogg,oga,flac,wma,wav,ac3,oma,omg,atp,ra,dts,aac,m4a,aa3,tta,mka,aiff,swa,wv)
2011-08-01 13:57:43.250 Loading en_us translation for module mythmusic
2011-08-01 13:57:43.252 Loading en_us translation for module mythnetvision
2011-08-01 13:57:43.256 Loading en_us translation for module mythnews
2011-08-01 13:57:43.262 Current MythVideo Schema Version (mythvideo.DBSchemaVer): 1016
2011-08-01 13:57:43.262 MythVideo database schema is old. Waiting to see if DB is being upgraded.
2011-08-01 13:57:44.263 New DB connection, total: 2
2011-08-01 13:57:44.263 Connected to database 'mythconverg' at host: localhost
2011-08-01 13:57:44.266 Current MythVideo Schema Version (mythvideo.DBSchemaVer): 1016
2011-08-01 13:57:45.268 Current MythVideo Schema Version (mythvideo.DBSchemaVer): 1016
2011-08-01 13:57:46.270 Current MythVideo Schema Version (mythvideo.DBSchemaVer): 1016
2011-08-01 13:57:46.271 Timed out waiting.
2011-08-01 13:57:46.283 Backing up database with script: '/usr/share/mythtv/mythconverg_backup.pl'
2011-08-01 13:58:01.268 Database Backup complete.
2011-08-01 13:58:01.277 Backed up database to file: '/mythtv/recordings/mythconverg-1264-20110801135746.sql.gz'
2011-08-01 13:58:05.742 Upgrading to MythVideo schema version 1017
2011-08-01 13:58:06.118 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

2011-08-01 13:58:06.118 Couldn't upgrade video database schema, exiting.
2011-08-01 13:58:06.118 Unable to initialize plugin 'mythvideo'.
2011-08-01 13:58:06.124 Loading en_us translation for module mythweather
2011-08-01 13:58:06.127 Loading en_us translation for module mythzoneminder
2011-08-01 13:58:06.254 Found mainmenu.xml for theme 'metallurgy'
2011-08-01 13:58:06.780 MythCoreContext: Connecting to backend server: 192.168.1.17:6543 (try 1 of 1)
2011-08-01 13:58:06.781 Using protocol version 63