I just updated to mythtv mythtv-0.20_p11444, coming from 0.19. I got this problem when starting mythfrontend: 2006-10-07 10:13:41.702 Using runtime prefix = /usr 2006-10-07 10:13:41.709 DPMS is active. 2006-10-07 10:13:41.832 New DB connection, total: 1 2006-10-07 10:13:41.917 Connected to database 'mythconverg' at host: localhost 2006-10-07 10:13:41.918 Total desktop dim: 1280x1024, with 1 screen[s]. 2006-10-07 10:13:41.948 Using screen 0, 1280x1024 at 0,0 2006-10-07 10:13:41.956 Current Schema Version: 1123 2006-10-07 10:13:42.049 Newest Schema Version : 1160 2006-10-07 10:13:42.050 New DB connection, total: 2 2006-10-07 10:13:42.050 Connected to database 'mythconverg' at host: localhost 2006-10-07 10:13:42.066 Setting Lock for Database Schema upgrade. If you see a long pause here it means the Schema is already locked and is being upgraded by another Myth process. 2006-10-07 10:13:42.089 New DB connection, total: 3 2006-10-07 10:13:42.090 Connected to database 'mythconverg' at host: localhost 2006-10-07 10:13:42.090 Upgrading to schema version 1124 2006-10-07 10:13:42.196 New DB connection, total: 4 2006-10-07 10:13:42.197 Connected to database 'mythconverg' at host: localhost 2006-10-07 10:13:42.239 Upgrading to schema version 1125 2006-10-07 10:13:42.270 Upgrading to schema version 1126 2006-10-07 10:13:42.299 Upgrading to schema version 1127 2006-10-07 10:13:42.366 Upgrading to schema version 1128 2006-10-07 10:13:42.396 Upgrading to schema version 1129 2006-10-07 10:13:42.444 New DB connection, total: 5 2006-10-07 10:13:42.444 Connected to database 'mythconverg' at host: localhost 2006-10-07 10:13:42.445 Upgrading to schema version 1130 2006-10-07 10:13:42.459 Upgrading to schema version 1131 2006-10-07 10:13:42.474 Upgrading to schema version 1132 2006-10-07 10:13:42.478 Upgrading to schema version 1133 2006-10-07 10:13:42.502 Upgrading to schema version 1134 2006-10-07 10:13:42.503 Upgrading to schema version 1135 2006-10-07 10:13:42.560 Upgrading to schema version 1136 2006-10-07 10:13:42.740 Upgrading to schema version 1137 2006-10-07 10:13:42.741 DB Error (Performing database upgrade): Query was: ALTER TABLE recordedprogram ADD listingsource INT NOT NULL default '0'; Error was: Driver error was [2/1146]: QMYSQL3: Unable to execute query Database error was: Table 'mythconverg.recordedprogram' doesn't exist new version: 1137 2006-10-07 10:13:42.741 Database Schema upgrade FAILED, unlocking. 2006-10-07 10:13:42.741 Couldn't upgrade database to new schema, exiting. Portage 2.1.1 (default-linux/x86/2006.0, gcc-4.1.1, glibc-2.4-r3, 2.6.18-gentoo i686) ================================================================= System uname: 2.6.18-gentoo i686 Intel(R) Pentium(R) M processor 2.00GHz Gentoo Base System version 1.12.5 Last Sync: Sat, 07 Oct 2006 01:30:01 +0000 app-admin/eselect-compiler: [Not Present] dev-java/java-config: 1.2.11-r1 dev-lang/python: 2.4.3-r4 dev-python/pycrypto: 2.0.1-r5 dev-util/ccache: [Not Present] dev-util/confcache: [Not Present] sys-apps/sandbox: 1.2.17 sys-devel/autoconf: 2.13, 2.59-r7 sys-devel/automake: 1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2 sys-devel/binutils: 2.16.1-r3 sys-devel/gcc-config: 1.3.13-r4 sys-devel/libtool: 1.5.22 virtual/os-headers: 2.6.17-r1 ACCEPT_KEYWORDS="x86" AUTOCLEAN="yes" CBUILD="i686-pc-linux-gnu" CFLAGS="-march=pentium-m -O3 -pipe" CHOST="i686-pc-linux-gnu" CONFIG_PROTECT="/etc /usr/kde/3.5/env /usr/kde/3.5/share/config /usr/kde/3.5/shutdown /usr/lib/mozilla/defaults/pref /usr/share/X11/xkb /usr/share/config /usr/share/texmf/dvipdfm/config/ /usr/share/texmf/dvips/config/ /usr/share/texmf/tex/generic/config/ /usr/share/texmf/tex/platex/config/ /usr/share/texmf/xdvi/" CONFIG_PROTECT_MASK="/etc/env.d /etc/gconf /etc/revdep-rebuild /etc/terminfo" CXXFLAGS="-O2 -mcpu=i686 -pipe" DISTDIR="/usr/portage/distfiles" FEATURES="autoconfig distlocks metadata-transfer sandbox sfperms strict" GENTOO_MIRRORS="ftp://ftp.sh.cvut.cz/MIRRORS/gentoo/gentoo http://pandemonium.tiscali.de/pub/gentoo/ http://mirror.isp.net.au/ftp/pub/gentoo/" LINGUAS="" MAKEOPTS="-j2" PKGDIR="/usr/portage/packages" PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --delete-after --stats --timeout=180 --exclude='/distfiles' --exclude='/local' --exclude='/packages'" PORTAGE_TMPDIR="/var/tmp" PORTDIR="/usr/portage" PORTDIR_OVERLAY="/usr/local/portage" SYNC="rsync://rsync.gentoo.org/gentoo-portage" USE="x86 X a52 aac acpi alsa amarok amd apache2 apm arts asf automount bash-completion batch berkdb bidi bitmap-fonts bittorrent bl cdparanoia cgi cli crypt css cups dbus dlloader dpms dri dvd dvdr dvdread eds elibc_glibc emboss encode esd ethereal fat fftw flac font-server foomaticdb fortran gdb gdbm gif gphoto2 gpm gsm gstreamer gtk gtk2 hal hdf5 imap imlib innodb input_devices_keyboard input_devices_mouse ipv6 isdnlog ivtv jpeg kde kdepim kernel_linux latex libg++ libwww lirc_devices_pctv lm_sensors logrotate mad mikmod mjpeg mmx motif mp3 mp4live mpeg mpeg2 mplayer msn musepack musicbrainz mysql mythtv ncurses nls nptl nptlonly nsplugin nvidia ofx ogg opengl openssh openssl oss pam pcre pda pdf perl png pppd python qt3 qt4 quicktime readline real reflection sdl session spell spl sqlite sqlite3 sse sse-filters sse2 ssl subversion svg tcl tcpd threads tk truetype truetype-fonts type1-fonts udev unicode userland_GNU v4l v4l2 vcd vfat video_cards_nvidia videos vidix visualization vorbis webdav wifi win32codecs wma xinerama xml xmms xorg xv xvid xvmc zlib" Unset: CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LANG, LC_ALL, LDFLAGS, PORTAGE_RSYNC_EXTRA_OPTS
Peter: Find me or Steve (beandog) on IRC. Also test the latest snapshot. The other possibility is upgrading to 0.20 then to a patch level 0.20.
I've bit the bullet, dropped my database, and started from scratch in the meanwhile.
