[03:35] <amejia> superm1: hi
[03:35] <superm1> hi
[03:35] <amejia> superm1: this is the version of xbmc with the arm fixes
[03:35] <amejia> superm1: http://packages.qa.debian.org/x/xbmc/news/20120420T030518Z.html
[03:35] <Zinn> [packages.qa.debian.org] Accepted xbmc 2:11.0~git20120416.a630a51-2 (source all amd64)
[03:35] <superm1> amejia: ah great
[03:36] <amejia> superm1: can it be synced for precise?
[03:37] <superm1> yeah should still be able to since it's not seeded anywhere
[03:38] <amejia> superm1: ok great
[03:42] <amejia> superm1: ok, well thanks again
[03:42] <amejia> superm1: i'm off to bed now, good night
[03:47] <superm1> night sure
[04:05] <superm1> amejia: oh i sent you libcec files to sponsor, did a test build in precise schroot though, i don't have an unstable one handy
[16:18] <qwebirc97858> Hello, 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:43] <superm1> qwebirc97858: check /var/log/mythtv/mythbackend.log
[16:43] <superm1> see if it talks about what's going wrong with the db upgrade
[16:44] <qwebirc97858> ok thanks on it now
[16:52] <qwebirc97858> would you like the raw text?
[16:53] <superm1> !pastebin
[16:53] <Zinn> when 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] <superm1> you can put it there
[16:53] <qwebirc97858> ok will do thanks again
[16:54] <superm1> sure
[16:57] <qwebirc97858> ok tried again and pasted the log file output in the pastebin
[16:58] <qwebirc97858> its a little long, I'm trying to figure out where it when wrong
[17:00] <qwebirc97858> Appears that this the problem:
[17:00] <qwebirc97858> Error (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: 1297
[17:00] <qwebirc97858> is this an issue due to the removal of myth video?
[17:03] <superm1> ooh that doesn't look good
[17:03] <superm1> you didn't post the pastebin URL, but you might need to check in #mythtv-users for someone to help recommend how to clean that up
[17:04] <superm1> i'm not positive the best way to go about it on a failed upgrade like that
[17:04] <qwebirc97858> here's the pastebin
[17:04] <qwebirc97858> http://pastebin.com/37BYvPmz
[17:04] <Zinn> [pastebin.com] qwebirc97858 - Pastebin.com
[17:04] <qwebirc97858> set to expire in 1 hour
[17:05] <qwebirc97858> ok will go to mythtv-users
[17:05] <superm1> was the upgrade interrupted the very first time?  maybe earlier in the log?
[17:05] <superm1> like before the snippet you pastebin'ed
[17:05] <superm1> it seems odd that it would fail like that
[17:06] <superm1> if it was actually interrupted, you can probably restore the latest backup from 0.24 before you started the 0.25 uprade, and start it over
[17:07] <qwebirc97858> ok i tried that using mythconverg_restore.pl
[17:07] <qwebirc97858> but i couldn't get it to work
[17:07] <qwebirc97858> ill paste what i got in a moment, give me a minute
[17:12] <qwebirc97858> ok so when I try to restore my backup
[17:12] <qwebirc97858> using the following command
[17:12] <qwebirc97858> mythconverg-restore.pl --directory /var/lib/mythtv/db_backups --filename mythconverg-1264-20120417080345.sql.gz
[17:12] <qwebirc97858> i get this: mythconverg-restore.pl: command not found
[17:13] <superm1> it's stored in /usr/share/mythtv
[17:13] <superm1> that script
[17:13] <qwebirc97858> yes i navigated to that directory in terminal and ran the command pasted
[17:14] <qwebirc97858> am i doing something wrong?
[17:14] <qwebirc97858> i also made it excitable using chmod a+x mythconverg_backup.pl mythconverg_restore.pl
[17:15] <qwebirc97858> *executable
[17:21] <qwebirc97858> ok 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.gz
[17:22] <qwebirc97858> ok trying to upgrade again....cross your fingers
[18:00] <superm1> if 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:32] <qwebirc97858> ok all done!
[18:33] <qwebirc97858> thanks for your help, it all worked out
[18:33] <qwebirc97858> now onto trying to get airplay to work....long term project
[19:06] <superm1> qwebirc97858: sure glad to help and glad it worked out.  good luck on the airplay! :)
[21:41] <superm1> amejia: it still failed on armel
[21:41] <superm1> fortunately caught before the sync was done
[21:42] <superm1> amejia: fwd'ed you the build log if you want to look closer.  but it looks like it failed in experimental as well