db/migrations/5.3.23_fix_questionnaire_questiondata.php


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

<?php

class FixQuestionnaireQuestiondata extends Migration
{
    public function description()
    {
        return 'fix invalid boolean values in questionnaire_questions';
    }

    public function up()
    {
        DBManager::get()->exec("
            UPDATE questionnaire_questions
            SET questiondata = REPLACE(questiondata, ':\"false\"', ':false')
            WHERE questiondata LIKE '%:\"false\"%'
        ");
    }
}