<!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>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></BODY></HTML>