Code: Select all
1) Back up your database (
http://www.mythtv.org/wiki/Database_Backup_and_Restore )
mythconverg_backup.pl
2) DROP your old database:
cat << "EOF" | mysql -umythtv -p mythconverg
DROP DATABASE IF EXISTS mythconverg;
CREATE DATABASE IF NOT EXISTS mythconverg;
ALTER DATABASE mythconverg DEFAULT CHARACTER SET latin1;
EOF
(and, no, the "latin1" is not a typo or a mistake, and, no, the "latin1"
won't cause any issues for users with non-latin characters).
3) Do a complete restore of the blank MythTV 0.21-fixes database:
mythconverg_restore.pl --dir=$HOME --file=mythconverg-1214-blank.sql
--verbose
4) Do a partial restore of your backup (fix the filename and directory
as appropriate):
mythconverg_restore.pl --partial_restore --dir=$HOME
--file=mythconverg-1214-20091105184542.sql.gz --verbose
5) Run the 0.22rc or 0.22-fixes or trunk mythtv-setup . It should
successfully upgrade your database. You will then have to reconfigure
MythTV (all of mythtv-setup configuration and all of mythfrontend
settings) and your plugins. (And, on the bright side, having to redo
your settings means that you will get to go through all the settings
that have been added since you first configured and set them the way you
really want them. :)Code: Select all
mkdir /mnt/sandboxCode: Select all
mount /dev/sda6 /mnt/sandboxCode: Select all
/etc/init.d/mythbackend stopCode: Select all
cp -ax / /mnt/sandboxCode: Select all
nano /mnt/sandbox/etc/fstabCode: Select all
/dev/sda1 /boot ext2 defaults,noatime 1 2
/dev/sda2 none swap sw 0 0
/dev/sda5 / ext4 noatime 0 1
/dev/sda7 /mnt/big ext4 defaults,noatime 0 0Code: Select all
/dev/sda1 /boot ext2 defaults,noatime 1 2
/dev/sda2 none swap sw 0 0
/dev/sda6 / ext4 noatime 0 1
#/dev/sda7 /mnt/big ext4 defaults,noatime 0 0Code: Select all
mknod /mnt/sandbox/dev/console c 5 1Code: Select all
nano /boot/grub/menu.lstCode: Select all
default 0
timeout 3
splashimage=(hd0,0)/grub/splash.xpm.gz
title MythTV
root (hd0,0)
kernel /kernel-2.6.32-gentoo-r5 root=/dev/sda5
Code: Select all
#default 0
timeout 3
splashimage=(hd0,0)/grub/splash.xpm.gz
default saved
fallback 0 2
title MythTV
root (hd0,0)
kernel /kernel-2.6.32-gentoo-r5 root=/dev/sda5
savedefault
title Sandbox
root (hd0,0)
kernel /kernel-2.6.32-gentoo-r5 root=/dev/sda6
savedefault 0Code: Select all
grub-set-default 1
shutdown -r now
Code: Select all
Warning at /var/www/localhost/htdocs/mythweb/modules/_shared/tmpl/_errors/db_vars_error.php, line 23:
require(modules/_shared/tmpl/tmpl/header.php) [function.require]: failed to open stream: No such file or directory
Fatal error: require() [function.require]: Failed opening required 'modules/_shared/tmpl/tmpl/header.php' (include_path='.:/usr/share/php5:/usr/share/php') in /var/www/localhost/htdocs/mythweb/modules/_shared/tmpl/_errors/db_vars_error.php on line 23I seem to remember seeing somewhere that the USE flag requirements for mythweb have changed. I'm sorry I can't be more specific, other than to remember that the flag that changed in one of the dependent packages was "json". This might not be your problem, but maybe it is.Nicias wrote:Followed the upgrade guide, no problems with mythtv or mythvideo.
However, my mythtv over lighttpd has stopped working. I get this message now:
Code: Select all
Warning at /var/www/localhost/htdocs/mythweb/modules/_shared/tmpl/_errors/db_vars_error.php, line 23: require(modules/_shared/tmpl/tmpl/header.php) [function.require]: failed to open stream: No such file or directory Fatal error: require() [function.require]: Failed opening required 'modules/_shared/tmpl/tmpl/header.php' (include_path='.:/usr/share/php5:/usr/share/php') in /var/www/localhost/htdocs/mythweb/modules/_shared/tmpl/_errors/db_vars_error.php on line 23
That's an odd one. It looks like your template isn't being defined or may be improperly set. The template name it's using is a literal 'tmpl' and the only valid templates are default, iPod, lite, or wap. There may be a bad value of some sort in the database table that stores the session. I'm not clear which template your supposed to be using, but it appears you can force a reset to any one by browsing to your mythweb server using:Nicias wrote:Followed the upgrade guide, no problems with mythtv or mythvideo.
However, my mythtv over lighttpd has stopped working. I get this message now:
Code: Select all
Warning at /var/www/localhost/htdocs/mythweb/modules/_shared/tmpl/_errors/db_vars_error.php, line 23: require(modules/_shared/tmpl/tmpl/header.php) [function.require]: failed to open stream: No such file or directory Fatal error: require() [function.require]: Failed opening required 'modules/_shared/tmpl/tmpl/header.php' (include_path='.:/usr/share/php5:/usr/share/php') in /var/www/localhost/htdocs/mythweb/modules/_shared/tmpl/_errors/db_vars_error.php on line 23
Code: Select all
http://<your_server>/mythweb?RESET_TMPL=default

NOOOOO!!!!!!!yngwin wrote:If we cannot offer some sort of upgrade guide to current stable users, we see no other choice than to mask all mythtv ebuilds.
Not to worry - mythtv-0.22 is stable now (well, not on ppc yet), so x86/amd64 users don't have to worry about this.flysideways wrote:NOOOOO!!!!!!!yngwin wrote:If we cannot offer some sort of upgrade guide to current stable users, we see no other choice than to mask all mythtv ebuilds.


Code: Select all
# uname -a
Linux mythbox 2.6.31-gentoo-r10 #2 PREEMPT Sat Mar 13 18:23:52 MST 2010 i686 Unknown CPU Typ AuthenticAMD GNU/Linux
Code: Select all
$ mplayer 1007_20100320052900.mpg
MPlayer SVN-r30554-4.3.4 (C) 2000-2010 MPlayer Team
$ uname -a
Linux vienna 2.6.31-gentoo-r10 #2 SMP PREEMPT Sun Mar 14 11:00:35 MDT 2010 x86_64 AMD Athlon(tm) Dual Core Processor 5050e AuthenticAMD GNU/Linux


Code: Select all
Fatal error: Call to a member function query_col() on a non-object in /var/www/localhost/htdocs/mythweb/modules/backend_log/init.php on line 19That sounds like an error you'd get if you weren't getting a database connection. In my case (as was the recommended setup if I remember correctly) I have a symlink in /etc/apache2/modules.d/ (in my case it's named mythweb.conf) that links to /var/www/localhost/htdocs/mythweb/mythweb.conf.apache. That has setenv statements starting at line 63 that define the database connection stuff.Dark Foo wrote:After updating from mythtv 0.22 to 0.23 (i know 0.24 is out but like others im waiting on ebuilds) mythweb throws up the error
Anyone have an ideas on how to fix this? I googled a bit and looked on a few mailing lists and have tried all they suggested on there, but with no luckCode: Select all
Fatal error: Call to a member function query_col() on a non-object in /var/www/localhost/htdocs/mythweb/modules/backend_log/init.php on line 19
