Thank you, I will do that. On Wed, Sep 19, 2018 at 7:37 PM Alvaro Cornejo <[email protected]> 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 <[email protected]>: > >> 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 >> > > _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
