Error in MySQL when drop a constraint upgrading to OpenKM version 7.1.31

Symptons

In the log of the OKMUpdater tool is shown 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 have special syntax for dropping constraints of the type foreign key.

Resolution

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

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

Properties

Keywords