|
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 |
- |
|
|