View | Details | Raw Unified | Return to bug 21613
Collapse All | Expand All

(-)a/Koha/Database.pm (-4 / +3 lines)
Lines 76-85 sub _new_schema { Link Here
76
        %encoding_attr = ( mysql_enable_utf8 => 1 );
76
        %encoding_attr = ( mysql_enable_utf8 => 1 );
77
        $encoding_query = "set NAMES 'utf8mb4'";
77
        $encoding_query = "set NAMES 'utf8mb4'";
78
        $tz_query = qq(SET time_zone = "$tz") if $tz;
78
        $tz_query = qq(SET time_zone = "$tz") if $tz;
79
        unless ( C4::Context->config('strict_sql_modes') ) {
79
        if ( $ENV{_} =~ m|prove| or C4::Context->config('strict_sql_modes') ) {
80
            $sql_mode_query = q{SET sql_mode = 'IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'};
81
        } else {
82
            $sql_mode_query = q{SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'};
80
            $sql_mode_query = q{SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'};
81
        } else {
82
            $sql_mode_query = q{SET sql_mode = 'IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'};
83
        }
83
        }
84
    }
84
    }
85
    elsif ( $db_driver eq 'Pg' ) {
85
    elsif ( $db_driver eq 'Pg' ) {
86
- 

Return to bug 21613