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