[mythtv-users] databse issues
gavin at nodecaf.net
Mon Aug 8 13:14:46 UTC 2005
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.
From: mythtv-users-bounces at mythtv.org on behalf of Reza Naima
Sent: Mon 8/8/2005 1:37 AM
To: Discussion about mythtv
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?
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
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
Size: 3006 bytes
Desc: not available
Url : http://mythtv.org/pipermail/mythtv-users/attachments/20050808/e9ff5d8d/attachment.bin
More information about the mythtv-users