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

(-)a/about.pl (-2 / +28 lines)
Lines 284-293 if ( C4::Context->preference('WebBasedSelfCheck') Link Here
284
        AutoSelfCheckPatronDoesNotHaveSelfCheckPerm => not ( $has_self_checkout_perm ),
284
        AutoSelfCheckPatronDoesNotHaveSelfCheckPerm => not ( $has_self_checkout_perm ),
285
        AutoSelfCheckPatronHasTooManyPerm => $has_other_permissions,
285
        AutoSelfCheckPatronHasTooManyPerm => $has_other_permissions,
286
    );
286
    );
287
288
289
}
287
}
290
288
289
{
290
    my $dbh       = C4::Context->dbh;
291
    my $patrons = $dbh->selectall_arrayref(
292
        q|select b.borrowernumber from borrowers b join deletedborrowers db on b.borrowernumber=db.borrowernumber|,
293
        { Slice => {} }
294
    );
295
    my $biblios = $dbh->selectall_arrayref(
296
        q|select b.biblionumber from biblio b join deletedbiblio db on b.biblionumber=db.biblionumber|,
297
        { Slice => {} }
298
    );
299
    my $checkouts = $dbh->selectall_arrayref(
300
        q|select i.issue_id from issues i join old_issues oi on i.issue_id=oi.issue_id|,
301
        { Slice => {} }
302
    );
303
    my $holds = $dbh->selectall_arrayref(
304
        q|select r.reserve_id from reserves r join old_reserves o on r.reserve_id=o.reserve_id|,
305
        { Slice => {} }
306
    );
307
    if ( @$patrons or @$biblios or @$checkouts or @$holds ) {
308
        $template->param(
309
            has_ai_issues => 1,
310
            ai_patrons    => $patrons,
311
            ai_biblios    => $biblios,
312
            ai_checkouts  => $checkouts,
313
            ai_holds      => $holds,
314
        );
315
    }
316
}
291
my %versions = C4::Context::get_versions();
317
my %versions = C4::Context::get_versions();
292
318
293
$template->param(
319
$template->param(
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/about.tt (-2 / +33 lines)
Lines 130-142 Link Here
130
        </div>
130
        </div>
131
131
132
        <div id="sysinfo">
132
        <div id="sysinfo">
133
    [% IF warnPrefBiblioAddsAuthorities || warnPrefEasyAnalyticalRecords || warnPrefAnonymousPatron || warnPrefAnonymousPatron_PatronDoesNotExist || warnNoActiveCurrency || QueryParserError || warnIsRootUser || xml_config_warnings.size || AutoSelfCheckPatronDoesNotHaveSelfCheckPerm || AutoSelfCheckPatronHasTooManyPerm || warnStatisticsFieldsError || warnNoTemplateCaching %]
133
    [% IF warnPrefBiblioAddsAuthorities || warnPrefEasyAnalyticalRecords || warnPrefAnonymousPatron || warnPrefAnonymousPatron_PatronDoesNotExist || warnNoActiveCurrency || QueryParserError || warnIsRootUser || xml_config_warnings.size || AutoSelfCheckPatronDoesNotHaveSelfCheckPerm || AutoSelfCheckPatronHasTooManyPerm || warnStatisticsFieldsError || warnNoTemplateCaching || has_ai_issues %]
134
        [% IF (warnIsRootUser) %]
134
        [% IF (warnIsRootUser) %]
135
            <h2>Warning regarding current user</h2>
135
            <h2>Warning regarding current user</h2>
136
            <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>
136
            <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>
137
            <p>Please log in instead with a regular staff account. To create a staff account, create a library, a patron category 'Staff' and add a new patron. Then give this patron permissions from 'More' in the toolbar.</p>
137
            <p>Please log in instead with a regular staff account. To create a staff account, create a library, a patron category 'Staff' and add a new patron. Then give this patron permissions from 'More' in the toolbar.</p>
138
        [% END %]
138
        [% END %]
139
139
140
        [% IF has_ai_issues %]
141
            <h2>Data problems</h2>
142
            <p>
143
            The following tables have problems with their auto_increment values which may lead to data lost. You should not ignore this warning.
144
            The problem is that innodb does not keep auto_increment across SQL server restarts (it is only set in memory).
145
            So on server startup the auto_increment values are set to max(table.id)+1.
146
            </p>
147
            <p>
148
            See the <a href="https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix">related wiki page</a> to know how to avoid this problem.
149
            </p>
150
            [% IF ai_patrons %]
151
                <h3>Patrons</h3>
152
                The following ids exist in both the borrowers and deletedborrowers table:
153
                [% FOR p IN ai_patrons %][% p.borrowernumber %][% UNLESS loop.last %], [% END %][% END %]
154
            [% END %]
155
            [% IF ai_biblios %]
156
                <h3>Biblios</h3>
157
                The following ids exist in both the biblio and deletedbiblio table:
158
                [% FOR b IN ai_biblios %][% b.biblionumber %][% UNLESS loop.last %], [% END %][% END %]
159
            [% END %]
160
            [% IF ai_checkouts %]
161
                <h3>Checkouts</h3>
162
                The following ids exist in both the issues and old_issues table:
163
                [% FOR c IN ai_checkouts %][% c.issue_id %][% UNLESS loop.last %], [% END %][% END %]
164
            [% END %]
165
            [% IF ai_holds %]
166
                <h3>Holds</h3>
167
                The following ids exist in both the holds and old_reserves table:
168
                [% FOR h IN ai_holds %][% h.issue_id %][% UNLESS loop.last %], [% END %][% END %]
169
            [% END %]
170
        [% END %]
171
140
        [% IF warnPrefBiblioAddsAuthorities || warnPrefEasyAnalyticalRecords || warnPrefAnonymousPatron || warnPrefAnonymousPatron_PatronDoesNotExist || warnNoActiveCurrency || QueryParserError || AutoSelfCheckPatronDoesNotHaveSelfCheckPerm || AutoSelfCheckPatronHasTooManyPerm || warnStatisticsFieldsError || warnNoTemplateCaching %]
172
        [% IF warnPrefBiblioAddsAuthorities || warnPrefEasyAnalyticalRecords || warnPrefAnonymousPatron || warnPrefAnonymousPatron_PatronDoesNotExist || warnNoActiveCurrency || QueryParserError || AutoSelfCheckPatronDoesNotHaveSelfCheckPerm || AutoSelfCheckPatronHasTooManyPerm || warnStatisticsFieldsError || warnNoTemplateCaching %]
141
            <h2>Warnings regarding the system configuration</h2>
173
            <h2>Warnings regarding the system configuration</h2>
142
            <table>
174
            <table>
143
- 

Return to bug 18931