No subject


Thu May 18 18:34:19 UTC 2006


problems it looks like you may have apache problems and I would work on
getting it to display normal pages such as index.htm first then test with
other things like phpmyadmin then start working on mythweb since it is the
most complicated.

Allan

------=_Part_33542_11325669.1148401817200
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

On 5/23/06, <b class=3D"gmail_sendername">Tom Dale</b> &lt;<a href=3D"mailt=
o:tdmyth at yahoo.com">tdmyth at yahoo.com</a>&gt; wrote:<div><span class=3D"gmai=
l_quote"></span><blockquote class=3D"gmail_quote" style=3D"border-left: 1px=
 solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
I realize that my previous thread may have been<br>difficult to follow, but=
<br>with the help I got from several folks, I believe that<br>we've narrowe=
d<br>down the problem.&nbsp;&nbsp;I'm sure that someone here can help<br>me=
.&nbsp;&nbsp;I completely
<br>re-installed from scratch using Mythdora and restored<br>my database pe=
r<br>the MythTV FAQ.&nbsp;&nbsp;Live TV does not work, prior<br>recordings =
do not show up,<br>MythWeb displays errors.&nbsp;&nbsp;This box has run for=
 over a<br>year with various
<br>Fedora or Mythdora installations.&nbsp;&nbsp;I don't know what<br>broke=
 it, but<br>restoring the database seems to restore the problem.<br>Thanks =
to help<br>from this list, here's what I found in my<br>mythbackend.log tha=
t looks
<br>suspicious:<br><br>&gt; 2006-05-20 03:02:24.244 DB Error (Error in<br>J=
obQueue::GetJobs(), Unable<br>&gt; to query list of Jobs in Queue.):<br>&gt=
; Query was:<br>&gt; SELECT <a href=3D"http://j.id">j.id</a>, j.chanid, j.s=
tarttime
, j.inserttime,<br>j.type, j.cmds,<br>&gt; j.flags, j.status, j.statustime,=
 j.hostname, j.args,<br>j.comment,<br>&gt; r.endtime FROM jobqueue j, recor=
ded r WHERE j.chanid<br>=3D r.chanid AND<br>&gt; j.starttime =3D r.starttim=
e
 ORDER BY j.inserttime,<br>j.chanid, <a href=3D"http://j.id">j.id</a>;<br>&=
gt; Driver error was [2/1146]:<br>&gt; QMYSQL3: Unable to execute query<br>=
&gt; Database error was:<br>&gt; Table 'mythconverg.jobqueue' doesn't exist
<br><br>To see the full contents of the log, mysqld.log, error<br>logs and =
previous<br>thread history, see<br><br><a href=3D"http://www.gossamer-threa=
ds.com/lists/mythtv/users/204612">http://www.gossamer-threads.com/lists/myt=
htv/users/204612
</a><br><br>Thank you, in advance, for any help you can provide!<br>-Tom-<b=
r><br><br>__________________________________________________<br>Do You Yaho=
o!?<br>Tired of spam?&nbsp;&nbsp;Yahoo! Mail has the best spam protection a=
round<br>
<a href=3D"http://mail.yahoo.com">http://mail.yahoo.com</a><br>____________=
___________________________________<br>mythtv-users mailing list<br><a href=
=3D"mailto:mythtv-users at mythtv.org">mythtv-users at mythtv.org</a><br><a href=
=3D"http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users">
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br></blockquote=
></div><br>I think you have to break your system down in to three different=
 and completely unrelated problems.<br><br>1). <span style=3D"font-weight: =
bold;">
Live TV not working</span><br><div style=3D"margin-left: 40px;">Usually the=
se problems are related to setting up ivtv correctly tell us what kind of c=
ard you are using and what you have done to set them up and we can help you=
 more with them.
<br></div>2). <span style=3D"font-weight: bold;">No previous recordings, da=
tabase problems</span><br><div style=3D"margin-left: 40px;">As long as you =
had a backup of your old database and restored it then I'm sure it is just =
small errors that you can fix with 'perl optimize_mythdb.pl'. Otherwise if =
you changed versions of Myth then you have to upgrade your database.
<br></div>3). <span style=3D"font-weight: bold;">MythWeb errors</span><br><=
div style=3D"margin-left: 40px;">From what little bit I read from your prev=
ious post about your mythweb problems it looks like you may have apache pro=
blems and I would work on getting it to display normal pages such as=20
index.htm first then test with other things like phpmyadmin then start work=
ing on mythweb since it is the most complicated.<br></div><br>Allan<br>

------=_Part_33542_11325669.1148401817200--


More information about the mythtv-users mailing list