Reply to thread

Message: <blockquote data-quote="Miwer" data-source="post: 1062049" data-attributes="member: 132832">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]</blockquote>

Verification