<br><br>
<div class="gmail_quote">On Mon, Mar 10, 2008 at 9:27 AM, Jackie Meese <<a href="mailto:jackie.m@dcm.dhs.org">jackie.m@dcm.dhs.org</a>> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">> How do I upgrade the database from ATRPMS latest to source?<br>><br>> Currently I'm getting the following error:<br>
><br>> 2007-01-16 22:00:57.683 Upgrading to schema version 1165<br>> 2007-01-16 22:00:57.685 DB Error (Performing database upgrade):<br>> Query was: CREATE INDEX program_manualid ON program (manualid);<br>> Error was: Driver error was [2/1061]:<br>
> QMYSQL3: Unable to execute query<br>> Database error was:<br>> Duplicate key name 'program_manualid'<br>><br>><br>> and trying to restart after that gave me<br>><br>> new version: 1165<br>
> 2007-01-16 22:00:57.685 Database Schema upgrade FAILED, unlocking.<br>> 2007-01-16 22:00:57.686 Couldn't upgrade database to new schema,<br>> exiting.<br><br>To fix this problem (which just moved at stable with the new relesase,<br>
I ran the following mysql command:<br> ALTER TABLE `program` DROP INDEX `program_manualid`<br><br>The auto update script put this index back.<br><br>j.<br>_______________________________________________<br>mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br><a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users" target="_blank">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br></blockquote>
</div>
<div><br>Same thing here. Not only that, but the update script dies and takes the whole X system with it. </div>
<div>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.</div>
<div> </div>
<div>I understand the SQL stuff, but why should the upgrade script kill X upon failure? It makes no sense</div>
<div> </div>
<div>JP<br clear="all"><br>-- <br>------------------------------<br>/\_/\ <br>|O O| <a href="mailto:pepebuho@pananet.com">pepebuho@pananet.com</a><br>~~~~ Javier Perez<br>~~~~ While the night runs<br>~~~~ toward the day...<br>
m m Pepebuho watches <br>from his high perch. </div>