Certain records reluctant to Checkin due to DBMS auto increment problem. These cases are not uncommon and the transaction will remain in the tables. The solution is still being worked out by developers. This temporary solution is available. These steps were tested on Koha, Ubuntu 16.04 and Debian 8.9 with MySQL and MariaDB Server.
We can access the Koha database and remove the entries. Only then can we apply DBMS auto-increment fix.
One by one, delete the php Myadmin pages
Check out Koha > About > Information about the System
Record reluctant to check-in.
See the message when try to checkin the book.
You can delete old issues by checking out the Delete Checkout feature
Access to the old_issues database table is required. This table contains all circulation entries. To access the database table, you will need to install phpMyAdmin. To install phpMyAdmin, open a terminal and run the following command.
Open terminal and type the command
sudo apat-get install PHPmyadmin
Delete Checkout following old issues
Apache select and Ok
Enter old mysql Password : mysqlroot
Enter Your Confirmation mysql password
Choose abort or (OK).
Another important configuration file is /etc/phpmyadmin/apache.conf, this file is symlinked to /etc/apache2/conf-available/phpmyadmin.conf, and, once enabled, is used to configure Apache2 to serve the phpMyAdmin site. This file contains directives to load PHP and directory permissions. A terminal type:
Open terminal and type the following command
sudo ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf-available/phpmyadmin.conf
sudo a2enconf phpmyadmin.conf
sudo systemctl reload apache2.service
You can ignore any error mysql passwords by following the below instructions
Follow the Mysql Update Change
PASSWORD UPDATE HTML (Mysql).
Mysql has called the “unix_socket”. This may have been due to partial migration of mariadb database to mysql. For all things to work again, su:
/etc/init.d/mysql stopmysqld_safe –skip-grant-tables &mysql -uroot
This will stop mysql completely, bypass user authentication (no password required) and allow you to connect to mysql using user root
Go to mysql console and use mysql administrative database:
To reset root password to mynewpassword (change at your will), just to be certain
update user set password=PASSWORD(\"mynewpassword\") where User=\'root\';
This will overwrite the authentication method, remove unix_socket requests (and everything else), and restore a normal and functioning password method.
update user set plugin=\"mysql_native_password\";
Exit mysql console:
All things related to mysql should be stopped and restarted:
Kill -9 $(pgrepmysql)
Do not forget to quit the su mode
Now, mySQL server has been up and running. It can be logged in with root
mysql root -p
Please enter your Password to make it operative.
Login to phpMyAdmin
1.Search the koha_library database for the old_issues table.
Look for the ID.
2.Click on the old_issues table for a deeper dive into the table.
3. To delete the circulatory entry that is not allowed to be checked-in, search the ID Number.
For the checkout issue ID, a compiled delete
4.Finally, Book Your Return Successfully