| 
      
            Lines 104-116
          
      
      
        Link Here
      
     | 
  
        
          | 104 | 
           | 
          104 | 
           | 
        
        
          | 105 | 
                  <div id="sysinfo">  | 
          105 | 
                  <div id="sysinfo">  | 
        
        
          | 106 | 
              [% IF warnPrefBiblioAddsAuthorities || warnPrefEasyAnalyticalRecords || warnPrefAnonymousPatron || warnPrefAnonymousPatron_PatronDoesNotExist ||  | 
          106 | 
              [% IF warnPrefBiblioAddsAuthorities || warnPrefEasyAnalyticalRecords || warnPrefAnonymousPatron || warnPrefAnonymousPatron_PatronDoesNotExist ||  | 
        
          
            
              | 107 | 
                        warnNoActiveCurrency || QueryParserError || warnIsRootUser || xml_config_warnings.size || AutoSelfCheckPatronDoesNotHaveSelfCheckPerm || AutoSelfCheckPatronHasTooManyPerm || warnStatisticsFieldsError || warnNoTemplateCaching %]  | 
              107 | 
                        warnNoActiveCurrency || QueryParserError || warnIsRootUser || xml_config_warnings.size || AutoSelfCheckPatronDoesNotHaveSelfCheckPerm || AutoSelfCheckPatronHasTooManyPerm || warnStatisticsFieldsError || warnNoTemplateCaching || has_ai_issues %]  | 
            
        
          | 108 | 
                  [% IF (warnIsRootUser) %]  | 
          108 | 
                  [% IF (warnIsRootUser) %]  | 
        
        
          | 109 | 
                      <h2>Warning regarding current user</h2>  | 
          109 | 
                      <h2>Warning regarding current user</h2>  | 
        
        
          | 110 | 
                      <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>  | 
          110 | 
                      <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>  | 
        
        
          | 111 | 
                      <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>  | 
          111 | 
                      <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>  | 
        
        
          | 112 | 
                  [% END %]  | 
          112 | 
                  [% END %]  | 
        
        
          | 113 | 
           | 
          113 | 
           | 
        
            
               | 
               | 
              114 | 
                      [% IF has_ai_issues %]  | 
            
            
              | 115 | 
                          <h2>Data problems</h2>  | 
            
            
              | 116 | 
                          <p>  | 
            
            
              | 117 | 
                          The following tables have problems with their auto_increment values which may lead to data lost. You should not ignore this warning.  | 
            
            
              | 118 | 
                          The problem is that innodb does not keep auto_increment across SQL server restarts (it is only set in memory).  | 
            
            
              | 119 | 
                          So on server startup the auto_increment values are set to max(table.id)+1.  | 
            
            
              | 120 | 
                          </p>  | 
            
            
              | 121 | 
                          <p>  | 
            
            
              | 122 | 
                          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.  | 
            
            
              | 123 | 
                          </p>  | 
            
            
              | 124 | 
                          [% IF ai_patrons %]  | 
            
            
              | 125 | 
                              <h3>Patrons</h3>  | 
            
            
              | 126 | 
                              The following ids exist in both the borrowers and deletedborrowers table:  | 
            
            
              | 127 | 
                              [% FOR p IN ai_patrons %][% p.borrowernumber %][% UNLESS loop.last %], [% END %][% END %]  | 
            
            
              | 128 | 
                          [% END %]  | 
            
            
              | 129 | 
                          [% IF ai_biblios %]  | 
            
            
              | 130 | 
                              <h3>Biblios</h3>  | 
            
            
              | 131 | 
                              The following ids exist in both the biblio and deletedbiblio table:  | 
            
            
              | 132 | 
                              [% FOR b IN ai_biblios %][% b.biblionumber %][% UNLESS loop.last %], [% END %][% END %]  | 
            
            
              | 133 | 
                          [% END %]  | 
            
            
              | 134 | 
                          [% IF ai_checkouts %]  | 
            
            
              | 135 | 
                              <h3>Checkouts</h3>  | 
            
            
              | 136 | 
                              The following ids exist in both the issues and old_issues table:  | 
            
            
              | 137 | 
                              [% FOR c IN ai_checkouts %][% c.issue_id %][% UNLESS loop.last %], [% END %][% END %]  | 
            
            
              | 138 | 
                          [% END %]  | 
            
            
              | 139 | 
                          [% IF ai_holds %]  | 
            
            
              | 140 | 
                              <h3>Holds</h3>  | 
            
            
              | 141 | 
                              The following ids exist in both the holds and old_reserves table:  | 
            
            
              | 142 | 
                              [% FOR h IN ai_holds %][% h.issue_id %][% UNLESS loop.last %], [% END %][% END %]  | 
            
            
              | 143 | 
                          [% END %]  | 
            
            
              | 144 | 
                      [% END %]  | 
            
            
              | 145 | 
               | 
            
        
          | 114 | 
                  [% IF warnPrefBiblioAddsAuthorities || warnPrefEasyAnalyticalRecords || warnPrefAnonymousPatron || warnPrefAnonymousPatron_PatronDoesNotExist ||  | 
          146 | 
                  [% IF warnPrefBiblioAddsAuthorities || warnPrefEasyAnalyticalRecords || warnPrefAnonymousPatron || warnPrefAnonymousPatron_PatronDoesNotExist ||  | 
        
        
          | 115 | 
                        warnNoActiveCurrency || QueryParserError || AutoSelfCheckPatronDoesNotHaveSelfCheckPerm || AutoSelfCheckPatronHasTooManyPerm || warnStatisticsFieldsError || warnNoTemplateCaching %]  | 
          147 | 
                        warnNoActiveCurrency || QueryParserError || AutoSelfCheckPatronDoesNotHaveSelfCheckPerm || AutoSelfCheckPatronHasTooManyPerm || warnStatisticsFieldsError || warnNoTemplateCaching %]  | 
        
        
          | 116 | 
                      <h2>Warnings regarding the system configuration</h2>  | 
          148 | 
                      <h2>Warnings regarding the system configuration</h2>  | 
        
            
              | 117 | 
              -   | 
               | 
               |