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.
reindex koha db with zebra.
|-----------------------------------------------------------------------------------------------------------------|
en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS
Post by kpkkprasanthHi 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
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
+----------------+------------+---------------------+-------
-----+---------------------+-----------------+----------+---
---------+------------------+---------------------+---------
------------+-----------------+------+----------+----------+
| 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
--
Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
_______________________________________________
Koha mailing list http://koha-community.org
https://lists.katipo.co.nz/mailman/listinfo/koha