/srv/irclogs.ubuntu.com/2012/04/20/#ubuntu-mythtv.txt

amejiasuperm1: hi03:35
superm1hi03:35
amejiasuperm1: this is the version of xbmc with the arm fixes03:35
amejiasuperm1: http://packages.qa.debian.org/x/xbmc/news/20120420T030518Z.html03:35
Zinn[packages.qa.debian.org] Accepted xbmc 2:11.0~git20120416.a630a51-2 (source all amd64)03:35
superm1amejia: ah great03:35
amejiasuperm1: can it be synced for precise?03:36
superm1yeah should still be able to since it's not seeded anywhere03:37
amejiasuperm1: ok great03:38
amejiasuperm1: ok, well thanks again03:42
amejiasuperm1: i'm off to bed now, good night03:42
superm1night sure03:47
superm1amejia: oh i sent you libcec files to sponsor, did a test build in precise schroot though, i don't have an unstable one handy04:05
=== mycosys1 is now known as mycosys
qwebirc97858Hello, I am having a 0.25 upgrade issue.  I just upgraded from 0.24 to 0.25.  After reboot and running mythtv-setup, it asks to upgrade from Schema 1296 to 1299.  I choose upgrade, and it ask to backup database.  Once the database is backup up to /tmp, it asks to run mythtv-backend.  Backend appears to start, but only for an instant.  Running mythfilldatabase says the database is not current.  Your assistance would be much 16:18
=== hpeter_ is now known as hpeter
superm1qwebirc97858: check /var/log/mythtv/mythbackend.log16:43
superm1see if it talks about what's going wrong with the db upgrade16:43
qwebirc97858ok thanks on it now16:44
qwebirc97858would you like the raw text?16:52
superm1!pastebin16:53
Zinnwhen pasting more than 5 lines of data please use http://mythbuntu.pastebin.com so you don't flood the channel.  Then please post the link in the channel.16:53
superm1you can put it there16:53
qwebirc97858ok will do thanks again16:53
superm1sure16:54
qwebirc97858ok tried again and pasted the log file output in the pastebin16:57
qwebirc97858its a little long, I'm trying to figure out where it when wrong16:58
qwebirc97858Appears that this the problem:17:00
qwebirc97858Error (Performing database upgrade): #012Query was: ALTER TABLE videocollection CHANGE inetref collectionref VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL #012Error was: Driver error was [2/1054]:#012QMYSQL: Unable to execute query#012Database error was:#012Unknown column 'inetref' in 'videocollection'#012 #012new version: 129717:00
qwebirc97858is this an issue due to the removal of myth video?17:00
superm1ooh that doesn't look good17:03
superm1you didn't post the pastebin URL, but you might need to check in #mythtv-users for someone to help recommend how to clean that up17:03
superm1i'm not positive the best way to go about it on a failed upgrade like that17:04
qwebirc97858here's the pastebin17:04
qwebirc97858http://pastebin.com/37BYvPmz17:04
Zinn[pastebin.com] qwebirc97858 - Pastebin.com17:04
qwebirc97858set to expire in 1 hour17:04
qwebirc97858ok will go to mythtv-users17:05
superm1was the upgrade interrupted the very first time?  maybe earlier in the log?17:05
superm1like before the snippet you pastebin'ed17:05
superm1it seems odd that it would fail like that17:05
superm1if it was actually interrupted, you can probably restore the latest backup from 0.24 before you started the 0.25 uprade, and start it over17:06
qwebirc97858ok i tried that using mythconverg_restore.pl17:07
qwebirc97858but i couldn't get it to work17:07
qwebirc97858ill paste what i got in a moment, give me a minute17:07
qwebirc97858ok so when I try to restore my backup17:12
qwebirc97858using the following command17:12
qwebirc97858mythconverg-restore.pl --directory /var/lib/mythtv/db_backups --filename mythconverg-1264-20120417080345.sql.gz17:12
qwebirc97858i get this: mythconverg-restore.pl: command not found17:12
superm1it's stored in /usr/share/mythtv17:13
superm1that script17:13
qwebirc97858yes i navigated to that directory in terminal and ran the command pasted17:13
qwebirc97858am i doing something wrong?17:14
qwebirc97858i also made it excitable using chmod a+x mythconverg_backup.pl mythconverg_restore.pl17:14
qwebirc97858*executable17:15
qwebirc97858ok i think i got it to work running perl mythconverg_restore.pl --drop_database --create_database --directory /var/lib/mythtv/db_backups --filename mythconverg-1264-20120417080345.sql.gz17:21
qwebirc97858ok trying to upgrade again....cross your fingers17:22
superm1if it's not in $PATH (as in that scenario), you need to execute it like ./mythconverg-restore.pl or like you did perl $FILE (where perl is in /usr/bin/ i believe, so it's in $PATH)18:00
qwebirc97858ok all done!18:32
qwebirc97858thanks for your help, it all worked out18:33
qwebirc97858now onto trying to get airplay to work....long term project18:33
superm1qwebirc97858: sure glad to help and glad it worked out.  good luck on the airplay! :)19:06
superm1amejia: it still failed on armel21:41
superm1fortunately caught before the sync was done21:41
superm1amejia: fwd'ed you the build log if you want to look closer.  but it looks like it failed in experimental as well21:42

Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!