[mythtv] bug in 0-7-to-0-8.sql

Matt Zimmerman mythtv-dev@snowman.net
Fri Jan 10 20:50:40 EST 2003


On Fri, Jan 10, 2003 at 12:28:05PM -0800, Larry Matter wrote:

> Checked out from CVS about 30 minutes ago.
> 
> Starting on line 34 of 0-7-to-0-8.sql, the INSERT INTO statements try to
> select from a column (profile) that hasn't been added yet (until about
> line 65).
> 
> Since those columns are added and then initialized to 0 you could just
> hardcode the value in the insert statement or move the INSERT INTOs to the
> bottom of the file, which is what I did.
> 
> I've attached my version of the file which at least doesn't get complaints
> from mysql (haven't finished configurning the rest of mythtv yet thought).

Heh, I had forgotten about this...that column was added to those tables, and
then that table was abandoned, all since the 0.7 release.  So really, those
ALTER TABLEs should just be removed, and the SELECTs changed to not
reference the profile column.

I think the right idea would be to move the existing bits to cvs.sql and put
the actual 0.7 to 0.8 migration sequence in 0-7-to-0-8.sql...

-- 
 - mdz



More information about the mythtv-dev mailing list