[mythtv-users] upgrading database from .21-fixes to trunk does not work; schema 1216 to 1222; "Column 'channum' cannot be part of FULLTEXT index"

cromworshipper-mythtvlist at yahoo.com cromworshipper-mythtvlist at yahoo.com
Mon Jul 21 17:50:38 UTC 2008


I tried to submit a ticket, but I get "Submission rejected as potential spam (Content contained blacklisted patterns)"

This is from mythtv-setup:

2008-07-20 23:00:29.093 Newest Schema Version : 1222
2008-07-20 23:00:29.097 Upgrading to schema version 1216
2008-07-20 23:00:29.106 DB Error (Performing database upgrade): 
Query was: ALTER TABLE channel  MODIFY channum varbinary(10) NOT NULL default '',  MODIFY freqid varbinary(10) default NULL,  MODIFY callsign varbinary(20) NOT NULL default '',  MODIFY name varbinary(64) NOT NULL default '',  MODIFY icon varbinary(255) NOT NULL default 'none',  MODIFY videofilters varbinary(255) NOT NULL default '',  MODIFY xmltvid varbinary(64) NOT NULL default '',  MODIFY tvformat varbinary(10) NOT NULL default 'Default',  MODIFY outputfilters varbinary(255) NOT NULL default '',  MODIFY default_authority varbinary(32) NOT NULL default ''; 
Error was: Driver error was [2/1283]:
QMYSQL: Unable to execute query
Database error was:
Column 'channum' cannot be part of FULLTEXT index
 
new version: 1216
2008-07-20 23:00:29.106 Database Schema upgrade FAILED, unlocking.
2008-07-20 23:00:29.106 Couldn't upgrade database to new schema.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20080721/55787a14/attachment.htm 


More information about the mythtv-users mailing list