|
Lines 140-176
Link Here
|
| 140 |
[% IF has_ai_issues %] |
140 |
[% IF has_ai_issues %] |
| 141 |
<h2>Data problems</h2> |
141 |
<h2>Data problems</h2> |
| 142 |
<p> |
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. |
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 |
The problem is that innodb does not keep auto_increment across SQL server restarts (it is only set in memory). |
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. |
145 |
So on server startup the auto_increment values are set to max(table.id)+1. |
| 146 |
</p> |
146 |
</p> |
| 147 |
<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. |
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> |
149 |
</p> |
|
|
150 |
|
| 151 |
<h3>Problems found</h3> |
| 150 |
[% IF ai_patrons %] |
152 |
[% IF ai_patrons %] |
| 151 |
<h3>Patrons</h3> |
153 |
<h4>Patrons</h4> |
| 152 |
The following ids exist in both the borrowers and deletedborrowers table: |
154 |
<p>The following ids exist in both <strong>borrowers</strong> and <strong>deletedborrowers</strong> tables: |
| 153 |
[% FOR p IN ai_patrons %][% p.borrowernumber %][% UNLESS loop.last %], [% END %][% END %] |
155 |
[% FOR p IN ai_patrons %][% p.borrowernumber %][% UNLESS loop.last %], [% END %][% END %]</p> |
| 154 |
[% END %] |
156 |
[% END %] |
| 155 |
[% IF ai_biblios %] |
157 |
[% IF ai_biblios %] |
| 156 |
<h3>Biblios</h3> |
158 |
<h4>Biblios</h4> |
| 157 |
The following ids exist in both the biblio and deletedbiblio table: |
159 |
<p>The following ids exist in both <strong>biblio</strong> and <strong>deletedbiblio</strong> tables: |
| 158 |
[% FOR b IN ai_biblios %][% b.biblionumber %][% UNLESS loop.last %], [% END %][% END %] |
160 |
[% FOR b IN ai_biblios %][% b.biblionumber %][% UNLESS loop.last %], [% END %][% END %]</p> |
| 159 |
[% END %] |
161 |
[% END %] |
| 160 |
[% IF ai_items %] |
162 |
[% IF ai_items %] |
| 161 |
<h3>Items</h3> |
163 |
<h4>Items</h4> |
| 162 |
The following ids exist in both the items and deleteditems table: |
164 |
<p>The following ids exist in both <strong>items</strong> and <strong>deleteditems</strong> tables: |
| 163 |
[% FOR i IN ai_items %][% i.itemnumber %][% UNLESS loop.last %], [% END %][% END %] |
165 |
[% FOR i IN ai_items %][% i.itemnumber %][% UNLESS loop.last %], [% END %][% END %]</p |
| 164 |
[% END %] |
166 |
[% END %] |
| 165 |
[% IF ai_checkouts %] |
167 |
[% IF ai_checkouts %] |
| 166 |
<h3>Checkouts</h3> |
168 |
<h4>Checkouts</h4> |
| 167 |
The following ids exist in both the issues and old_issues table: |
169 |
<p>The following ids exist in both <strong>issues</strong> and <strong>old_issues</strong> tables: |
| 168 |
[% FOR c IN ai_checkouts %][% c.issue_id %][% UNLESS loop.last %], [% END %][% END %] |
170 |
[% FOR c IN ai_checkouts %][% c.issue_id %][% UNLESS loop.last %], [% END %][% END %]</p> |
| 169 |
[% END %] |
171 |
[% END %] |
| 170 |
[% IF ai_holds %] |
172 |
[% IF ai_holds %] |
| 171 |
<h3>Holds</h3> |
173 |
<h4>Holds</h4> |
| 172 |
The following ids exist in both the holds and old_reserves table: |
174 |
<p>The following ids exist in both <strong>holds</strong> and <strong>old_reserves</strong> table: |
| 173 |
[% FOR h IN ai_holds %][% h.issue_id %][% UNLESS loop.last %], [% END %][% END %] |
175 |
[% FOR h IN ai_holds %][% h.issue_id %][% UNLESS loop.last %], [% END %][% END %]</p> |
| 174 |
[% END %] |
176 |
[% END %] |
| 175 |
[% END %] |
177 |
[% END %] |
| 176 |
|
178 |
|
| 177 |
- |
|
|