[mythtv-users] Revision: 12668 DB Update error

Jon Boehm boehm100 at comcast.net
Mon Jan 29 04:21:30 UTC 2007


Could you be specific on how you did this?  I found mythconverg  
database and channel table but I would hate to mess this up.  This is  
my first time in phpmyadmin.

Thanks,
Jon


On Jan 28, 2007, at 7:12 PM, Adam Propeck wrote:

> 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!
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users



More information about the mythtv-users mailing list