<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.16.3">
</HEAD>
<BODY>
><I> How do I upgrade the database from ATRPMS latest to source?</I>
<PRE>
>
><I> Currently I'm getting the following error:</I>
>
><I> 2007-01-16 22:00:57.683 Upgrading to schema version 1165</I>
><I> 2007-01-16 22:00:57.685 DB Error (Performing database upgrade):</I>
><I> Query was: CREATE INDEX program_manualid ON program (manualid);</I>
><I> Error was: Driver error was [2/1061]:</I>
><I> QMYSQL3: Unable to execute query</I>
><I> Database error was:</I>
><I> Duplicate key name 'program_manualid'</I>
>
>
><I> and trying to restart after that gave me</I>
>
><I> new version: 1165</I>
><I> 2007-01-16 22:00:57.685 Database Schema upgrade FAILED, unlocking.</I>
><I> 2007-01-16 22:00:57.686 Couldn't upgrade database to new schema, </I>
><I> exiting.</I>
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.
---
I find that the mythtv-setup cannot do this but starting mythbackend is successful.
Thanks millions for this pointer Jackie. It was the solution I was looking for.
I was at schema 1164 version.
When I tried your solution and ran setup from a console it still failed. mythbackend must be more robust?
Thanks again!
</PRE>
-Rick
</BODY>
</HTML>