[mythtv-users] databse issues

[Gavin Haslett]

Could be your user permissions to the database... you may not have enough permissions to perform the upgrade. Try running the upgrade script as root.


-----Original Message-----
From:	mythtv-users-bounces at mythtv.org on behalf of Reza Naima
Sent:	Mon 8/8/2005 1:37 AM
To:	Discussion about mythtv
Cc:	
Subject:	[mythtv-users] databse issues

ok, this auto-db-update thing is driving me nuts.  every time i quit and
restart mythtv, it wants to upgade the db.  i have to go in manually,
and update the database to reflect the version change, then mythbackend
starts.  but when mythbackend quites, and i try to restart it, it
thinks it's the old version again.  anyone know why?

thnx

2005-08-07 23:33:31.567 Upgrading to schema version 1077
2005-08-07 23:33:31.595 New DB connection, total: 3
2005-08-07 23:33:31.623 Upgrading to schema version 1078
2005-08-07 23:33:31.637 Upgrading to schema version 1079
2005-08-07 23:33:31.650 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-08-07 23:33:31.651 Database Schema upgrade FAILED, unlocking.
2005-08-07 23:33:31.651 Couldn't upgrade database to new schema




-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 3006 bytes
Desc: not available
Url : http://mythtv.org/pipermail/mythtv-users/attachments/20050808/e9ff5d8d/attachment.bin