[mythtv-users] upgrading database from ATRPMS

[Javier Perez]

On Mon, Mar 10, 2008 at 9:27 AM, Jackie Meese <jackie.m at dcm.dhs.org> wrote:

> > How do I upgrade the database from ATRPMS latest to source?
> >
> > Currently I'm getting the following error:
> >
> > 2007-01-16 22:00:57.683 Upgrading to schema version 1165
> > 2007-01-16 22:00:57.685 DB Error (Performing database upgrade):
> > Query was: CREATE INDEX program_manualid ON program (manualid);
> > Error was: Driver error was [2/1061]:
> > QMYSQL3: Unable to execute query
> > Database error was:
> > Duplicate key name 'program_manualid'
> >
> >
> > and trying to restart after that gave me
> >
> > new version: 1165
> > 2007-01-16 22:00:57.685 Database Schema upgrade FAILED, unlocking.
> > 2007-01-16 22:00:57.686 Couldn't upgrade database to new schema,
> > exiting.
>
> To fix this problem (which just moved at stable with the new relesase,
> I ran the following mysql command:
>  ALTER TABLE `program` DROP INDEX `program_manualid`
>
> The auto update script put this index back.
>
> j.
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>

Same thing here. Not only that, but the update script dies and takes the
whole X system with it.
I had to downgrade to 20.x because I could not make it work. Is there
somewhere the written steps (SQL's) needed to upgrade the database, I would
like to go one by one until I get to the one causing the problem.

I  understand the SQL stuff, but why should the upgrade script kill X upon
failure? It makes no sense

JP

-- 
------------------------------
/\_/\
|O O| pepebuho at pananet.com
~~~~ Javier Perez
~~~~ While the night runs
~~~~ toward the day...
m m Pepebuho watches
from his high perch.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20080311/c910c142/attachment.htm