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 › About Koha</title> |
4 |
<title>Koha › 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 |
- |
|
|