Hi Prassanth, Good you were able to fix your checking issue; however, in your about capture I see that you have a lot of duplicate records. You must fix it as soon as possible as per the instructions in the link shown in that page. BTW, you shouldn't need to restart mysql at the end of your procedure but reindex koha db with zebra. Regards, Alvaro |-----------------------------------------------------------------------------------------------------------------| Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier celular y Nextel en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS y GPRS online Visitenos en www.perusms.com 2018-09-19 5:38 GMT-05:00 kpkkprasanth <kpkkprasanth@gmail.com>:
Hi am cleared my checkin problem in koha Version 18.05
My problem Image 1 : https://ibb.co/mOmUez
Some Koha Installation & Supporting Gurus Said its fine policy , Clear Increase Max fine.
k dude i cleard see image 2 : https://ibb.co/gKGHXK
Again Check in Error ji
None of this work for me. Because the promble in sql file. Today we clear that problem. I'm mentioned here with clear step please follow dude.
Step 1 : Go to the About Koha -> System Information
See my Image 3 : https://ibb.co/hsKkme
Step 2 : Copy the ID's under *Checkouts*
Example : 12926,39936
Step 3 : Open Terminal Ctrl+Alt+T
Step 4 : sudo su
Step 5 : enter your login password
Step 6 : mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 39 Server version: 5.7.23-0ubuntu0.18.04.1 (Ubuntu)
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
Step 7 : show databases; +--------------------+ | Database | +--------------------+ | information_schema | | koha_library | | mysql | | performance_schema | | sys | +--------------------+ 5 rows in set (0.07 sec)
Step 8 : mysql> use koha_library; [my database name: koha_library] Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A
Step 9 : mysql> Select * from old_issues where issue_id IN (12926,39936);
change the check out numbers as yours in that backet and type the above in mysql cmd
It Shows :
+----------------+------------+---------------------+------- -----+---------------------+-----------------+----------+--- ---------+------------------+---------------------+--------- ------------+-----------------+------+----------+----------+ | borrowernumber | itemnumber | date_due | branchcode | returndate | lastreneweddate | renewals | auto_renew | auto_renew_error | timestamp | issuedate | onsite_checkout | note | notedate | issue_id | +----------------+------------+---------------------+------- -----+---------------------+-----------------+----------+--- ---------+------------------+---------------------+--------- ------------+-----------------+------+----------+----------+ | 471 | 3935 | 2015-08-07 23:59:00 | IIITDM | 2015-07-20 15:29:40 | NULL | NULL | 0 | NULL
| 2015-07-20 15:29:40 | 2015-06-25 16:48:00 | 0 | NULL | NULL | 12926 | | 1045 | 28993 | 2018-04-24 23:59:00 | IIITDM | 2018-03-12 20:53:50 | NULL | NULL | 0 | NULL
| 2018-03-12 20:53:50 | 2018-03-12 20:53:37 | 0 | NULL | NULL | 39936 | +----------------+------------+---------------------+------- -----+---------------------+-----------------+----------+--- ---------+------------------+---------------------+--------- ------------+-----------------+------+----------+----------+ 2 rows in set (0.02 sec)
Step 10 : Delete from old_issues where issue_id IN (12926,39936); Query OK, 2 rows affected (0.13 sec)
Restart mysql
Step 11 : mysql> sudo /etc/init.d/mysql restart
See Image : https://ibb.co/eHMZCK
Successfully we done dude.
Regards,
K.Prasanth M.L.I.Sc.,B.Sc.,C.L.I.Sc.,HDCHN.,PGDLAN Library Trainee Indian Institue of Information Technology, Design and Manufacturing Kancheepuram
Contact : kpkkprasanth@gmail.com
-- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha