[Koha] Unable to Check-In Error

[Alvaro Cornejo]

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 at 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 at gmail.com
>
>
>
>
>
>
>
>
>
> --
> Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>