I ran the upgrade-linhes script today and it went horibly wrong
It was doing the schema update and came up with the following error
I carried on with it and rebooted only to find my backend no longer starts, is there anyway to repair the database, I have no tv without the backend and the wife is giving me daggers..
I don't know what I was upgrading from I last did an update about 3 months ago...
Code:
login as: root
root@mythtv's password:
Access denied
root@mythtv's password:
Last login: Thu Aug 5 22:34:05 2010 from unknown-00-1c-bf-7a-f2-79.config
[root@mythtv ~]# cd /
[root@mythtv /]# ls
bin data etc home lost+found mnt opt root srv tmp var
boot dev etc.old lib media myth proc sbin sys usr
[root@mythtv /]# cd usr
[root@mythtv usr]# cd var
[root@mythtv var]# ls
cache empty games lib local lock log mail opt run service spool tmp
[root@mythtv var]# cd log
[root@mythtv log]# ls
Xorg.0.log errors.log lircd soundon.log
Xorg.0.log.old errors.log.1 lircd.1 sv
acpid.log errors.log.2 lircd.2 syslog.log
acpid.log.1 errors.log.3 lircd.3 syslog.log.1
acpid.log.2 errors.log.4 lircd.4 syslog.log.2
acpid.log.3 everything.log messages.log syslog.log.3
acpid.log.4 everything.log.1 messages.log.1 syslog.log.4
auth.log everything.log.2 messages.log.2 user.log
auth.log.1 everything.log.3 messages.log.3 user.log.1
auth.log.2 everything.log.4 messages.log.4 user.log.2
auth.log.3 faillog mysqld.log user.log.3
auth.log.4 fluxbox.log mythtv user.log.4
btmp kernel.log mythvantage_install.log utmp
daemon.log kernel.log.1 network.init webmin
daemon.log.1 kernel.log.2 network.init.error wtmp
daemon.log.2 kernel.log.3 old wtmp.1
daemon.log.3 kernel.log.4 pacman.log
daemon.log.4 lastlog sa
dmesg.log lighttpd samba
[root@mythtv log]# cd mythtv
[root@mythtv mythtv]# ls
hulu_grabber.log mythbackend.log.4.gz mythfrontend.log.1.gz
myth2x264.log mythbackend.log.5.gz mythfrontend.log.2.gz
myth_mtc.log mythbackend.log.6.gz mythfrontend.log.3.gz
mythbackend.log mythbackend.log.7.gz mythfrontend.log.4.gz
mythbackend.log.1.gz mythexport.log mythfrontend.log.5.gz
mythbackend.log.2.gz mythfilldatabase.log mythfrontend.log.6.gz
mythbackend.log.3.gz mythfrontend.log mythfrontend.log.7.gz
[root@mythtv mythtv]# vi mythbackend.log
2010-08-05 21:40:57.773 UPnpMedia: BuildMediaMap Done. Found 385 objects
2010-08-05 21:42:04.095 AutoExpire: CalcParams(): Max required Free Space: 1.0 GB w/freq: 15 min
2010-08-05 21:57:04.161 AutoExpire: CalcParams(): Max required Free Space: 1.0 GB w/freq: 15 min
2010-08-05 22:01:02.198 MainServer::ANN Monitor
2010-08-05 22:01:02.201 adding: mythtv as a client (events: 0)
2010-08-05 22:01:02.208 DB Error (ProgramList::FromRecorded):
Query was:
SELECT recorded.chanid,recorded.starttime,recorded.endtime,recorded.title,recorded.subtitle,recorded.description,recorded.hostname,channum,name,callsign,commflagged,cutlist,recorded.autoexpire,editing,bookmark,recorded.category,recorded.recgroup,record.dupin,record.dupmethod,recorded.recordid,channel.outputfilters,recorded.seriesid,recorded.programid,recorded.filesize, recorded.lastmodified, recorded.findid, recorded.originalairdate, recorded.playgroup, recorded.basename, recorded.progstart, recorded.progend, recorded.stars, recordedprogram.audioprop+0, recordedprogram.videoprop+0, recordedprogram.subtitletypes+0, recorded.watched, recorded.storagegroup, recorded.transcoded, recorded.recpriority, recorded.preserve, recordedprogram.airdate FROM recorded LEFT JOIN record ON recorded.recordid = record.recordid LEFT JOIN channel ON recorded.chanid = channel.chanid LEFT JOIN recordedprogram ON ( recorded.chanid = recordedprogram.chanid AND recorded.progstart = recordedprogram.starttime ) WHERE (
~
-- VISUAL -- 8 61887,1 Bot
This is what is in the backend log