I opened up phpmyadmin and selected the mythconverg database and channel table. I added an index on sourceid called sourceid. Then started mythbackend and I think I'm good to go... hopefully I didn't make things worse. ;)
<br><br><div><span class="gmail_quote">On 1/28/07 wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Just tried updating to current SVN and got this:
<br>----------------------------------------------------------------------------<br>2007-01-28 20:13:08.213 New DB connection, total: 3<br>2007-01-28 20:13:08.214 Connected to database 'mythconverg' at host: localhost
<br>2007-01-28 20:13:08.215 Upgrading to schema version 1178<br>2007-01-28 20:13:08.216 DB Error (Performing database upgrade):<br>Query was: ALTER TABLE channel DROP INDEX sourceid;<br>Error was: Driver error was [2/1091]:
<br>QMYSQL3: Unable to execute query<br>Database error was:<br>Can't DROP 'sourceid'; check that column/key exists<br><br>new version: 1178<br>2007-01-28 20:13:08.217 Database Schema upgrade FAILED, unlocking.
<br>2007-01-28 20:13:08.217 Couldn't upgrade database to new schema<br><br>----------------------------------------------------------------------------<br><br><br><br>What should I do? Thanks in advance for the help!
<br>
</blockquote></div><br>