[mythtv-users] Revision: 12668 DB Update error

Adam Propeck adam at propeck.com
Mon Jan 29 03:12:58 UTC 2007


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. ;)

On 1/28/07 wrote:
>
> Just tried updating to current SVN and got this:
>
> ----------------------------------------------------------------------------
> 2007-01-28 20:13:08.213 New DB connection, total: 3
> 2007-01-28 20:13:08.214 Connected to database 'mythconverg' at host:
> localhost
> 2007-01-28 20:13:08.215 Upgrading to schema version 1178
> 2007-01-28 20:13:08.216 DB Error (Performing database upgrade):
> Query was: ALTER TABLE channel           DROP INDEX sourceid;
> Error was: Driver error was [2/1091]:
> QMYSQL3: Unable to execute query
> Database error was:
> Can't DROP 'sourceid'; check that column/key exists
>
> new version: 1178
> 2007-01-28 20:13:08.217 Database Schema upgrade FAILED, unlocking.
> 2007-01-28 20:13:08.217 Couldn't upgrade database to new schema
>
>
> ----------------------------------------------------------------------------
>
>
>
> What should I do? Thanks in advance for the help!
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20070128/6bb23539/attachment.htm 


More information about the mythtv-users mailing list