<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1458" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>I found the 'dbcheck.cpp' file in the sourcecode
package where the database setup happens and could extract the commands to setup
the missing 'recordedmarkup' table, and a</FONT><FONT face=Arial size=2>fter
again deleting the two columns in the 'recorded' table I could finally run the
database updater succesfully and I now have a working Myth installation
again.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>One issue I have found is that often my recordings
won't play and I get errors telling me that it's ' waiting for prebuffer... '
and that the 'prebuffer timed out...' when I try to play files that previously
worked fine. </FONT></DIV>
<DIV><FONT face=Arial size=2>The strange thing is that I can play the recording
if I escape out the stalled recording and reenter it again....why is that and
what can I do about it?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Otherwise it's a great improvement over my old .13
installation and I look forward to getting it into daily use.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>thanks</FONT></DIV>
<DIV><FONT face=Arial size=2>anders</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=anders@smiths.dk href="mailto:anders@smiths.dk">anders smith</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=mythtv-users@mythtv.org
href="mailto:mythtv-users@mythtv.org">Discussion about mythtv</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Monday, October 11, 2004 11:17
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [mythtv-users] database errors
during upgrade...</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>After upgrading vi apt-get and atrpms I'm now
stuck because the database update balks..</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>First I got this:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>---snip---</FONT></DIV>
<DIV>2004-10-09 14:41:42 Upgrading to schema 1051<BR>DB error
(performing database upgrade):<BR>Query was ALTER TABLE recorded ADD COLUMN
lastmodified TIMESTAMP NOT <BR>NULL:<BR>Driver error was [2/-1]:<BR>QMYSQL3:
Unable to execute querry<BR>Database error was:<BR>Duplicate column name 'last
modified'</DIV>
<DIV>---snip---</DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>I deleted the 'lastmodified' column in the
database as well as the 'filesize' when it gave the same complaint and I
deleted my 'recordedmarkup' table as it was corrupted, but now I can't get
past it.....</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I did a mysqldump and I think it's complete, but
because of the corruption of the 'recordedmarkup' table I can't be sure, so
that is one reason why I haven't just dumped the whole 'mythconverg' database
and started from scratch... the other is that I'm not sure of the best way to
do it.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Do I simply dump the database, import the mc.sql
setup file and the reimport my mysqldump?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Alternatively can someone tell me how to set up
the mythconverg.recordedmarkup' table?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>thanks</FONT></DIV>
<DIV><FONT face=Arial size=2>Anders</FONT></DIV>
<DIV><BR></DIV>
<P>
<HR>
<P></P>_______________________________________________<BR>mythtv-users mailing
list<BR>mythtv-users@mythtv.org<BR>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users<BR></BLOCKQUOTE></BODY></HTML>