[mythtv] xmltv and database error Unknown column 'userid' in 'field list' ?

[cmisip]

To try to fix this I dumped the database to a file.  Did a mysql <
mc.sql ( the most recent cvs, dated April 28) and then copied over the
recorded.* and oldrecorded.* to the freshly built database.  I dont know
if this is the right thing to do.  It seems to work though.  The QT time
errors disappeared also.  I dont know if there are other complications.



On Tue, 2003-04-29 at 21:58, Isaac Richards wrote:
> On Tuesday 29 April 2003 10:49 pm, cmisip wrote:
> > I figured it out.  There is a 0-8-to-0-9.sql which I thought I applied.
> > I applied it and it is working again.  Curiosly it said there was an
> > error on line 31 with Error 1061 Duplicate key name 'progid'
> 
> Use cvs.sql when upgrading between cvs versions -- by using 0-8-to-0-9.sql 
> more than once, now, you've messed your database up as you're missing at 
> least one of the recent db changes.  Also, I generally have 'database update 
> required' or something like that in the commit message whenever the database 
> schema changes.
> 
> Isaac
> _______________________________________________
> mythtv-dev mailing list
> mythtv-dev at snowman.net
> http://lists.snowman.net/cgi-bin/mailman/listinfo/mythtv-dev