nuonguy at yahoo
Jul 21, 2008, 12:55 PM
Post #1 of 1
(298 views)
Permalink
|
|
upgrading database from .21-fixes to trunk does not work; schema 1216 to 1222; "Column 'channum' cannot be part of FULLTEXT index"
|
|
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.
|
