MARKAZ CENTRAL LIBRARY CATALOGUE

PLEASE CLICK ON THE FOLLOWING LINK TO BROWSE MARKAZ CENTRAL LIBRARY KARANTHUR

1. OPAC CENTRAL LIBRARY

KOHA - Auto increment problem

To fix the Auto increment problem in koha use the following steps

1. Install phpmyadmin and remove the affected tables
(If there is an issue in loading of phpmyadmin after successful installation, use the following steps to change in Apache configuration)
    1. gedit /etc/apache2/apache2.conf
   2. Add the following to the bottom of the file:
    
    # phpMyAdmin Configuration
    Include /etc/phpmyadmin/apache.conf
  check using localhost/phpmyadmin  or yourip/phpmyadmin

2. Edit the my.cnf file
    sudo gedit /etc/mysql/my.cnf
find out the [mysqld] section or create new one and add the following line

           init-file=/var/lib/mysql/init-file_library.sql 

3. Create a file /var/lib/mysql/init-file_library.sql  ( Assuming that the "library" is the instance name or otherwise replace with library with your instance name)

$sudo gedit /var/lib/mysql/init-file_library.sql

4. Add the following text in the file

USE koha_library;
 
SET @new_AI_borrowers = ( SELECT GREATEST( IFNULL( ( SELECT MAX(borrowernumber) FROM borrowers ), 0 ), IFNULL( ( SELECT MAX(borrowernumber) FROM deletedborrowers ), 0 ) ) + 1 );
SET @sql = CONCAT( 'ALTER TABLE borrowers AUTO_INCREMENT = ', @new_AI_borrowers );
PREPARE st FROM @sql;
EXECUTE st;
 
SET @new_AI_biblio = ( SELECT GREATEST( IFNULL( ( SELECT MAX(biblionumber) FROM biblio ), 0 ), IFNULL( ( SELECT MAX(biblionumber) FROM deletedbiblio ), 0 ) ) + 1 );
SET @sql = CONCAT( 'ALTER TABLE biblio AUTO_INCREMENT = ', @new_AI_biblio );
PREPARE st FROM @sql;
EXECUTE st;
 
SET @new_AI_biblioitems = ( SELECT GREATEST( IFNULL( ( SELECT MAX(biblioitemnumber) FROM biblioitems ), 0 ), IFNULL( ( SELECT MAX(biblioitemnumber) FROM deletedbiblioitems ), 0 ) ) + 1 );
SET @sql = CONCAT( 'ALTER TABLE biblioitems AUTO_INCREMENT = ', @new_AI_biblioitems );
PREPARE st FROM @sql;
EXECUTE st;
 
SET @new_AI_items = ( SELECT GREATEST( IFNULL( ( SELECT MAX(itemnumber) FROM items ), 0 ), IFNULL( ( SELECT MAX(itemnumber) FROM deleteditems ), 0 ) ) + 1 );
SET @sql = CONCAT( 'ALTER TABLE items AUTO_INCREMENT = ', @new_AI_items );
PREPARE st FROM @sql;
EXECUTE st;
 
SET @new_AI_issues = ( SELECT GREATEST( IFNULL( ( SELECT MAX(issue_id) FROM issues ), 0 ), IFNULL( ( SELECT MAX(issue_id) FROM old_issues ), 0 ) ) + 1 );
SET @sql = CONCAT( 'ALTER TABLE issues AUTO_INCREMENT = ', @new_AI_issues );
PREPARE st FROM @sql;
EXECUTE st;
 
SET @new_AI_reserves = ( SELECT GREATEST( IFNULL( ( SELECT MAX(reserve_id) FROM reserves ), 0 ), IFNULL( ( SELECT MAX(reserve_id) FROM old_reserves ), 0 ) ) + 1 );
SET @sql = CONCAT( 'ALTER TABLE reserves AUTO_INCREMENT = ', @new_AI_reserves );
PREPARE st FROM @sql;
EXECUTE st;

5. Restart Mysql

$sudo service mysql restart