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

(-)a/about.pl (+22 lines)
Lines 621-626 $template->param( 'bad_yaml_prefs' => \@bad_yaml_prefs ) if @bad_yaml_prefs; Link Here
621
    }
621
    }
622
}
622
}
623
623
624
#BZ 28267: Warn administrators if there are database rows with a format other than 'DYNAMIC'
625
{
626
    my $database = C4::Context->config('database');
627
    if ($database){
628
        my $dbh = C4::Context->dbh;
629
        my $sql = q#
630
            SELECT count(table_name)
631
            FROM information_schema.tables
632
            WHERE
633
                table_schema = ?
634
                AND row_format != "Dynamic"
635
        #;
636
        my $sth = $dbh->prepare($sql);
637
        $sth->execute($database);
638
        my $row = $sth->fetchrow_arrayref;
639
        my $count = $row->[0];
640
        if ($count){
641
            $template->param( warnDbRowFormat => $count );
642
        }
643
    }
644
}
645
624
my %versions = C4::Context::get_versions();
646
my %versions = C4::Context::get_versions();
625
647
626
$template->param(
648
$template->param(
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/about.tt (-2 / +9 lines)
Lines 219-225 Link Here
219
        </div>
219
        </div>
220
220
221
        <div role="tabpanel" class="tab-pane" id="sysinfo">
221
        <div role="tabpanel" class="tab-pane" id="sysinfo">
222
    [% IF warnRequireChoosingExistingAuthority || warnPrefEasyAnalyticalRecords || warnPrefAnonymousPatronOPACPrivacy || warnPrefAnonymousPatronAnonSuggestions || warnPrefAnonymousPatronOPACPrivacy_PatronDoesNotExist || warnPrefAnonymousPatronAnonSuggestions_PatronDoesNotExist || warnPrefKohaAdminEmailAddress || warnPrefOpacHiddenItems || invalid_yesno.count || warnNoActiveCurrency || warnIsRootUser || xml_config_warnings.size || AutoSelfCheckPatronDoesNotHaveSelfCheckPerm || AutoSelfCheckPatronHasTooManyPerm || warnStatisticsFieldsError || warnNoTemplateCaching || warnILLConfiguration || has_ai_issues || oauth2_missing_deps || bad_yaml_prefs || warnRelationships || log4perl_errors || config_bcrypt_settings_no_set || warnHiddenBiblionumbers.size || warnConnectBroker || elasticsearch_has_missing %]
222
    [% IF warnRequireChoosingExistingAuthority || warnPrefEasyAnalyticalRecords || warnPrefAnonymousPatronOPACPrivacy || warnPrefAnonymousPatronAnonSuggestions || warnPrefAnonymousPatronOPACPrivacy_PatronDoesNotExist || warnPrefAnonymousPatronAnonSuggestions_PatronDoesNotExist || warnPrefKohaAdminEmailAddress || warnPrefOpacHiddenItems || invalid_yesno.count || warnNoActiveCurrency || warnIsRootUser || xml_config_warnings.size || AutoSelfCheckPatronDoesNotHaveSelfCheckPerm || AutoSelfCheckPatronHasTooManyPerm || warnStatisticsFieldsError || warnNoTemplateCaching || warnILLConfiguration || has_ai_issues || oauth2_missing_deps || bad_yaml_prefs || warnRelationships || log4perl_errors || config_bcrypt_settings_no_set || warnHiddenBiblionumbers.size || warnConnectBroker || elasticsearch_has_missing || warnDbRowFormat %]
223
        [% IF ( warnDbRowFormat ) %]
224
            <h2>Database row format incorrect</h2>
225
            <p>There are [% warnDbRowFormat %] database tables with a row format other than 'DYNAMIC'. You may experience problems upgrading to newer versions of Koha unless you update the row format for your database tables.</p>
226
            <p>To know how to avoid this problem see the related wiki page:
227
            <a href="https://wiki.koha-community.org/wiki/Database_row_format">Database row format</a>
228
            </p>
229
        [% END %]
230
223
        [% IF (warnIsRootUser) %]
231
        [% IF (warnIsRootUser) %]
224
            <h2>Warning regarding current user</h2>
232
            <h2>Warning regarding current user</h2>
225
            <p>You are logged in as the database administrative user. This is not recommended because some parts of Koha will not function as expected when using this account.</p>
233
            <p>You are logged in as the database administrative user. This is not recommended because some parts of Koha will not function as expected when using this account.</p>
226
- 

Return to bug 28267