Opened 18 years ago
Closed 18 years ago
#1465 closed defect (invalid)
filemarkup table not created.
Reported by: | oneillji | Owned by: | GoToDev |
---|---|---|---|
Priority: | minor | Milestone: | unknown |
Component: | mythtv | Version: | |
Severity: | medium | Keywords: | |
Cc: | Ticket locked: | no |
Description
As a trouble-shooting exercise, i dropped the mythconverg schema, recreated the schema with 'mysql -u root -p < mc.sql'. Used mythtv-setup to configure, then ran mythbackend. The other tables appear to be in place. This isn't an issue for me as i have a dump i can restore but thought i best report it.
Session management error: Authentication Rejected, reason : None of the authentication protocols specified are supported and host-based authentication failed 2006-03-06 19:50:18.841 Using runtime prefix = /usr/local 2006-03-06 19:50:18.869 New DB connection, total: 1 2006-03-06 19:50:18.870 Connected to database 'mythconverg' at host: localhost 2006-03-06 19:50:18.882 Current Schema Version: 1128 2006-03-06 19:50:18.882 Newest Schema Version : 1129 2006-03-06 19:50:18.883 New DB connection, total: 2 2006-03-06 19:50:18.902 Connected to database 'mythconverg' at host: localhost 2006-03-06 19:50:18.903 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. 2006-03-06 19:50:18.903 New DB connection, total: 3 2006-03-06 19:50:18.904 Connected to database 'mythconverg' at host: localhost 2006-03-06 19:50:18.923 New DB connection, total: 4 2006-03-06 19:50:18.923 Connected to database 'mythconverg' at host: localhost 2006-03-06 19:50:18.923 Upgrading to schema version 1129 2006-03-06 19:50:18.924 DB Error (Performing database upgrade): Query was: INSERT INTO filemarkup (filename, type, mark) SELECT filename, '2', bookmark FROM videobookmarks; Error was: Driver error was [2/1146]: QMYSQL3: Unable to execute query Database error was: Table 'mythconverg.filemarkup' doesn't exist new version: 1129 2006-03-06 19:50:18.942 Database Schema upgrade FAILED, unlocking. 2006-03-06 19:50:18.943 Couldn't upgrade database to new schema
Note: See
TracTickets for help on using
tickets.
You're not running current SVN, this bug was fixed about 12 hours ago.