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

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/about.tt (-18 / +16 lines)
Lines 1-3 Link Here
1
[% USE HtmlTags %]
1
[% SET footerjs = 1 %]
2
[% SET footerjs = 1 %]
2
[% INCLUDE 'doc-head-open.inc' %]
3
[% INCLUDE 'doc-head-open.inc' %]
3
<title>Koha &rsaquo; About Koha</title>
4
<title>Koha &rsaquo; About Koha</title>
Lines 139-178 Link Here
139
140
140
        [% IF has_ai_issues %]
141
        [% IF has_ai_issues %]
141
            <h2>Data problems</h2>
142
            <h2>Data problems</h2>
142
            <p>
143
            <p>Some of your tables have problems with their auto_increment values which may lead to data loss.</p>
143
            Some of your tables have problems with their auto_increment values which may lead to data loss. <strong>You should not ignore this warning</strong>.
144
            <p><strong>You should not ignore this warning.</strong></p>
144
            The problem is that InnoDB does not keep auto_increment across SQL server restarts (it is only set in memory).
145
            <p>The problem is that InnoDB does not keep auto_increment across SQL server restarts (it is only set in memory). So on server startup the auto_increment values are set to max(table.id)+1.</p>
145
            So on server startup the auto_increment values are set to max(table.id)+1.
146
            <p>To know how to avoid this problem see the related wiki page:
146
            </p>
147
            <a href="https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix">DBMS auto increment fix</a>
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>
148
            </p>
150
149
151
            <h3>Problems found</h3>
150
            <h3>Problems found</h3>
152
            [% IF ai_patrons %]
151
            [% IF ai_patrons %]
153
                <h4>Patrons</h4>
152
                <h4>Patrons</h4>
154
                <p>The following ids exist in both <strong>borrowers</strong> and <strong>deletedborrowers</strong> tables:
153
                <p>The following ids exist in both tables [% "borrowers" | $HtmlTags tag="strong" %] and [% "deletedborrowers" | $HtmlTags tag="strong" %]:</p>
155
                [% FOR p IN ai_patrons %][% p.borrowernumber %][% UNLESS loop.last %], [% END %][% END %]</p>
154
                <p>[% FOR p IN ai_patrons %][% p.borrowernumber %][% UNLESS loop.last %], [% END %][% END %]</p>
156
            [% END %]
155
            [% END %]
157
            [% IF ai_biblios %]
156
            [% IF ai_biblios %]
158
                <h4>Biblios</h4>
157
                <h4>Biblios</h4>
159
                <p>The following ids exist in both <strong>biblio</strong> and <strong>deletedbiblio</strong> tables:
158
                <p>The following ids exist in both tables [% "biblio" | $HtmlTags tag="strong" %] and [% "deletedbiblio" | $HtmlTags tag="strong" %]:</p>
160
                [% FOR b IN ai_biblios %][% b.biblionumber %][% UNLESS loop.last %], [% END %][% END %]</p>
159
                <p>[% FOR b IN ai_biblios %][% b.biblionumber %][% UNLESS loop.last %], [% END %][% END %]</p>
161
            [% END %]
160
            [% END %]
162
            [% IF ai_items %]
161
            [% IF ai_items %]
163
                <h4>Items</h4>
162
                <h4>Items</h4>
164
                <p>The following ids exist in both <strong>items</strong> and <strong>deleteditems</strong> tables:
163
                <p>The following ids exist in both tables [% "items" | $HtmlTags tag="strong" %] and [% "deleteditems" | $HtmlTags tag="strong" %]:</p>
165
                [% FOR i IN ai_items %][% i.itemnumber %][% UNLESS loop.last %], [% END %][% END %]</p>
164
                <p>[% FOR i IN ai_items %][% i.itemnumber %][% UNLESS loop.last %], [% END %][% END %]</p>
166
            [% END %]
165
            [% END %]
167
            [% IF ai_checkouts %]
166
            [% IF ai_checkouts %]
168
                <h4>Checkouts</h4>
167
                <h4>Checkouts</h4>
169
                <p>The following ids exist in both <strong>issues</strong> and <strong>old_issues</strong> tables:
168
                <p>The following ids exist in both tables [% "issues" | $HtmlTags tag="strong" %] and [% "old_issues" | $HtmlTags tag="strong" %]:</p>
170
                [% FOR c IN ai_checkouts %][% c.issue_id %][% UNLESS loop.last %], [% END %][% END %]</p>
169
                <p>[% FOR c IN ai_checkouts %][% c.issue_id %][% UNLESS loop.last %], [% END %][% END %]</p>
171
            [% END %]
170
            [% END %]
172
            [% IF ai_holds %]
171
            [% IF ai_holds %]
173
                <h4>Holds</h4>
172
                <h4>Holds</h4>
174
                <p>The following ids exist in both <strong>holds</strong> and <strong>old_reserves</strong> table:
173
                <p>The following ids exist in both tables [% "holds" | $HtmlTags tag="strong" %] and [% "old_reserves" | $HtmlTags tag="strong" %]:</p>
175
                [% FOR h IN ai_holds %][% h.reserve_id %][% UNLESS loop.last %], [% END %][% END %]</p>
174
                <p>[% FOR h IN ai_holds %][% h.reserve_id %][% UNLESS loop.last %], [% END %][% END %]</p>
176
            [% END %]
175
            [% END %]
177
            <br/>
176
            <br/>
178
        [% END %]
177
        [% END %]
179
- 

Return to bug 19274