Reply to thread

Hi,

I was having the same issue, so I looked into this a bit.

I tried installing a crisp new MP1.6 on a VM, and there's a change in one of the columns in both recording and schedule tables.

In table recording, I had the column 'fileName' as varchar(260) - in a new database this is a varchar(255).

In table schedule, I had the column 'programName' as varchar(256) - in a new database this is also a varchar(255).

So after changing these columns, I could convert the table to InnoDB without errors (although I did get a warning on the column change)

Also row_format in a new database is COMPACT, so that should be included too.

I did not change any character sets.

This script worked for me (notice the two extra lines in there):

[CODE]ALTER TABLE `mptvdb`.`canceledschedule` ENGINE=InnoDB ROW_FORMAT=COMPACT;

ALTER TABLE `mptvdb`.`card` ENGINE=InnoDB ROW_FORMAT=COMPACT;

ALTER TABLE `mptvdb`.`cardgroup` ENGINE=InnoDB ROW_FORMAT=COMPACT;

ALTER TABLE `mptvdb`.`cardgroupmap` ENGINE=InnoDB ROW_FORMAT=COMPACT;

ALTER TABLE `mptvdb`.`channel` ENGINE=InnoDB ROW_FORMAT=COMPACT;

ALTER TABLE `mptvdb`.`channelgroup` ENGINE=InnoDB ROW_FORMAT=COMPACT;

ALTER TABLE `mptvdb`.`channellinkagemap` ENGINE=InnoDB ROW_FORMAT=COMPACT;

ALTER TABLE `mptvdb`.`channelmap` ENGINE=InnoDB ROW_FORMAT=COMPACT;

ALTER TABLE `mptvdb`.`conflict` ENGINE=InnoDB ROW_FORMAT=COMPACT;

ALTER TABLE `mptvdb`.`diseqcmotor` ENGINE=InnoDB ROW_FORMAT=COMPACT;

ALTER TABLE `mptvdb`.`favorite` ENGINE=InnoDB ROW_FORMAT=COMPACT;

ALTER TABLE `mptvdb`.`groupmap` ENGINE=InnoDB ROW_FORMAT=COMPACT;

ALTER TABLE `mptvdb`.`history` ENGINE=InnoDB ROW_FORMAT=COMPACT;

ALTER TABLE `mptvdb`.`keyword` ENGINE=InnoDB ROW_FORMAT=COMPACT;

ALTER TABLE `mptvdb`.`keywordmap` ENGINE=InnoDB ROW_FORMAT=COMPACT;

ALTER TABLE `mptvdb`.`pendingdeletion` ENGINE=InnoDB ROW_FORMAT=COMPACT;

ALTER TABLE `mptvdb`.`personaltvguidemap` ENGINE=InnoDB ROW_FORMAT=COMPACT;

ALTER TABLE `mptvdb`.`program` ENGINE=InnoDB ROW_FORMAT=COMPACT;

ALTER TABLE `mptvdb`.`radiochannelgroup` ENGINE=InnoDB ROW_FORMAT=COMPACT;

ALTER TABLE `mptvdb`.`radiogroupmap` ENGINE=InnoDB ROW_FORMAT=COMPACT;

ALTER TABLE `mptvdb`.`recording` CHANGE COLUMN `fileName` `fileName` VARCHAR(255) NOT NULL;

ALTER TABLE `mptvdb`.`recording` ENGINE=InnoDB ROW_FORMAT=COMPACT;

ALTER TABLE `mptvdb`.`satellite` ENGINE=InnoDB ROW_FORMAT=COMPACT;

ALTER TABLE `mptvdb`.`schedule` CHANGE COLUMN `programName` `programName` VARCHAR(255) NOT NULL;

ALTER TABLE `mptvdb`.`schedule` ENGINE=InnoDB ROW_FORMAT=COMPACT;

ALTER TABLE `mptvdb`.`server` ENGINE=InnoDB ROW_FORMAT=COMPACT;

ALTER TABLE `mptvdb`.`setting` ENGINE=InnoDB ROW_FORMAT=COMPACT;

ALTER TABLE `mptvdb`.`softwareencoder` ENGINE=InnoDB ROW_FORMAT=COMPACT;

ALTER TABLE `mptvdb`.`timespan` ENGINE=InnoDB ROW_FORMAT=COMPACT;

ALTER TABLE `mptvdb`.`tuningdetail` ENGINE=InnoDB ROW_FORMAT=COMPACT;

ALTER TABLE `mptvdb`.`tvmoviemapping` ENGINE=InnoDB ROW_FORMAT=COMPACT;

ALTER TABLE `mptvdb`.`version` ENGINE=InnoDB ROW_FORMAT=COMPACT;[/CODE]