reproduced

master: https://github.com/LimeSurvey/LimeSurvey/pull/3573

need to check 5.x

does not appear to affect 5.x

Duplicate of https://bugs.limesurvey.org/view.php?id=19344

Hi, solution posted in 6.4.3 is partial.

there is still an error in activate_helper.php, row 357:
foreach ($result as $constraintName) {
Yii::app()->db->createCommand('ALTER TABLE [' . $tablename . '] DROP CONSTRAINT "' . $constraintName['constraint_name'] . '"')->execute();
}

CONSTRAINT_NAME must be uppercased:

foreach ($result as $constraintName) {
    Yii::app()->db->createCommand('ALTER TABLE [' . $tablename . '] DROP CONSTRAINT "' . $constraintName['CONSTRAINT_NAME'] . '"')->execute();
}