[mythtv] Fwd: Problems upgrading database

Geoffrey Kruse gkruse at gmail.com
Thu Apr 7 18:14:46 UTC 2005


Forgive me if this has already been covered, but using current cvs I 
get the following errors starting the front or backend, but only after 
the first time.  Ie, if i remove the conflicting rows they will start 
but the next time they will not.


Geoff

2005-04-07 11:07:14.454 DB Error (Performing database upgrade):
Query was: ALTER TABLE capturecard ADD COLUMN dvb_hw_decoder INT 
DEFAULT '0';
Error was: Driver error was [2/1060]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate column name 'dvb_hw_decoder'

new version: 1079
2005-04-07 11:07:14.460 Database Schema upgrade FAILED, unlocking.
2005-04-07 11:07:14.461 Couldn't upgrade database to new schema


and similar but different, once I remove the dvb_hw_decoder row I get 
the same error with recordid in oldrecorded

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2361 bytes
Desc: not available
Url : http://mythtv.org/pipermail/mythtv-dev/attachments/20050407/e5b12d55/smime.bin


More information about the mythtv-dev mailing list