[Koha] Unable to Check-In Error

Thu Sep 20 02:15:30 NZST 2018

Thank you, I will do that.

On Wed, Sep 19, 2018 at 7:37 PM Alvaro Cornejo <cornejo.alvaro at gmail.com>
wrote:

> 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
>>
>
>