Error in MySQL when dropping a constraint while upgrading to OpenKM version 7.1.31

Symptoms

The OKMUpdater tool log shows the error:

Error when executing: alter table OKM_FORUM_TOPIC drop constraint FK_FTPIC_FRM_ID;
Error when executing: drop table OKM_FORUM;

Cause

MySQL has special syntax for dropping foreign key constraints.

Resolution

Go to Administration > Tools > Database query and execute the following script:

alter table OKM_FORUM_TOPIC drop FOREIGN KEY FK_FTPIC_FRM_ID;
drop table OKM_FORUM;

Properties

Keywords