Re: [mythtv-users] Database error
赵亚伟 wrote: QInputContext: cannot create input context for non-toplevel widgets QInputContext: cannot create input context for non-toplevel widgets 2005-08-21 18:42:53.069 Unable to connect to database! 2005-08-21 18:42:53.069 Driver error was [1/1045]: QMYSQL3: Unable to connect Database error was: Access denied for user 'mythtv'@'localhost' (using password: YES) 2005-08-21 18:42:53.070 Failed to init MythContext, exiting. What is wrong Thanks in advance. Here are three posts from the last few days that you might want to read. Note that they're all in response to your asking the same question in one of the 7 other threads you started about the same problem... http://www.gossamer-threads.com/lists/mythtv/users/145549?#145549 http://www.gossamer-threads.com/lists/mythtv/users/145589#145589 http://www.gossamer-threads.com/lists/mythtv/users/145559#145559 The first two give you the answer. The last one doesn't answer your question, but is probably the most important of the three. Mike ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Database error
On 4/13/05, SpikeyGG [EMAIL PROTECTED] wrote: Hello Mythgroup, I recently tried to upgrade my installation of myth cause I noticed that the new stuff is all packaged nice (in three packages). Anyway, I built it from CVS like normal... uninstalled my old one first and install the new one. When I run mythbackend I get the following error: 2005-04-13 20:23:58.545 New DB connection, total: 1 2005-04-13 20:23:58.547 Setting Lock for Database Schema upgrade. If you see a long pause here it means the Schema is already locked and is being upgraded by another Myth process. 2005-04-13 20:23:58.548 New DB connection, total: 2 2005-04-13 20:23:58.549 Upgrading to schema version 1079 2005-04-13 20:23:58.549 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-13 20:23:58.550 Database Schema upgrade FAILED, unlocking. 2005-04-13 20:23:58.550 Couldn't upgrade database to new schema I'm brand new to mysql and learned a little off the web (basically how to look at tables). I checked out the capturecard table and it looks like that dvb_hw_decoder does exist. Any idea how I can fix it without trashing my DB? I just saw the same error on my CVS update today... was working fine as of a week or so ago. Art ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Database Error
On Fri, 2005-04-01 at 15:54 +1000, Craig Cooper wrote: Error as follows: 2005-04-01 15:42:00.873 Writing settings file /home/mythtv/.mythtv/mysql.txt 2005-04-01 15:42:00.875 Unable to connect to database! 2005-04-01 15:42:00.875 Driver error was [1/1045]: QMYSQL3: Unable to connect Database error was: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) couldn't open db *** Could someone please tell me where I am going wrong? I haven't been able to do anything with the database (mysqld is running). I installed mythtv-suite via yum, so may have non-standard directory locations... Make sure that mysql is setup to allow network connections. Lonnie Borntreger ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
RE: [mythtv-users] database error after upgrade
Preston wrote: I just upgraded from slightly pre-0.17 CVS code to today's CVS code, and when I try to start mythbackend, it tells me: 2005-02-23 23:51:29.651 New DB connection, total: 1 2005-02-23 23:51:29.656 Upgrading to schema version 1072 2005-02-23 23:51:29.658 DB Error (Performing database upgrade): Query was: ALTER TABLE program ADD COLUMN manualid INT UNSIGNED NOT NULL DEFAULT 0; Error was: Driver error was [2/1060]: QMYSQL3: Unable to execute query Database error was: Duplicate column name 'manualid' new version: 1072 2005-02-23 23:51:29.662 Couldn't upgrade database to new schema Any suggestions? Yes. First backup your database. Then remove the manualid column from the program table either by using something like webmin or remove it from the backup and restore (you may want to add the --add-drop-tables line to the mysqldump if you go down that route) I had to go through that for a few tables going from CVS to 0.17 HTH Druid ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users