This question is in reference to Atlassian Documentation: Upgrade to 5.7.x fails due to IMAGEDETAILS constraint FKA768048734A4917E
Resolution 1 fails with the following message:
ERROR 1005 (HY000): Can't create table 'confluence.#sql-86c_5b' (errno: 150)
I'm upgrading from Confluence 2.8, moved in on a completely fresh and updated Debian Jessie..
SET FOREIGN_KEY_CHECKS = 0;
ALTER TABLE IMAGEDETAILS ADD CONSTRAINT FKA768048734A4917E FOREIGN KEY (ATTACHMENTID) REFERENCES ATTACHMENTS(ATTACHMENTID);
SET FOREIGN_KEY_CHECKS = 1;
helped me beyond it, but I had to repeat it for also:
ALTER TABLE SPACEGROUPPERMISSIONS ADD CONSTRAINT FK487D958B16994414 FOREIGN KEY (SPACEGROUPID) references SPACEGROUPS (SPACEGROUPID)
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG