Opened 15 years ago

Closed 15 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


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

Change History (1)

comment:1 Changed 15 years ago by cpinkham

Resolution: invalid
Status: newclosed

You're not running current SVN, this bug was fixed about 12 hours ago.

Note: See TracTickets for help on using tickets.