jean

@Jean Cardona

You have missing foreign keys, please execute the following script. Your are now 100% correct.

ALTER TABLE `Attachment` ADD CONSTRAINT `FK_Attachment_TodoID` FOREIGN KEY (`TodoID`) REFERENCES `Todo`(`ID`);

ALTER TABLE `Connections` ADD CONSTRAINT `FK_Connections_GroupInfo` FOREIGN KEY (`SecurityGroup`) REFERENCES `GroupInfo`(`ID`);

ALTER TABLE `Inventory` ADD CONSTRAINT `FK_Inventory_Connections` FOREIGN KEY (`ConnectionID`) REFERENCES `Connections`(`ID`);

ALTER TABLE `Monitoring` ADD CONSTRAINT `FK_Monitoring_Connections` FOREIGN KEY (`ConnectionID`) REFERENCES `Connections`(`ID`);

ALTER TABLE `Todo` ADD CONSTRAINT `FK_Todo_GroupInfo` FOREIGN KEY (`SecurityGroup`) REFERENCES `GroupInfo`(`ID`);

ALTER TABLE `UserGroupInfo` ADD CONSTRAINT `FK_UserGroupInfo_GroupInfo` FOREIGN KEY (`GroupInfoID`) REFERENCES `GroupInfo`(`ID`);

Ok, I've done that. I've just sent the schema for verification.

Thank you for the great support!

@Jean Cardona,

Please send me you schema to make sure all is good so that we don't have any errors with future upgrades.

Best regards,

Ok, done

After running the alter tables from the CONCAT command, the upgrade went well, thank you!

I now have this error:

MySqlException - Can't create table `rdpmanager`.`SessionRecording` (errno: 150 "Foreign key constraint is incorrectly formed")

I've sent the schema for analysis

Same here for the failure, it's the first one that fails.

Email sent as well, with "Attn: Stefane" in the body.

Hello,

We have the exact same symptom, and

SELECT CONCAT('ALTER TABLE ', TABLE_SCHEMA,'.',TABLE_NAME, ' ENGINE = InnoDB;')

FROM information_schema.TABLES

WHERE ENGINE='MyISAM' AND TABLE_SCHEMA = database();

Does not yield any result.