[Koha] Unable to Check-In Error

[kpkkprasanth]

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