Hi Clint, It worked. Thanks!!
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> Libre de virus. www.avast.com <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> |-----------------------------------------------------------------------------------------------------------------| 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-01-10 17:41 GMT-05:00 clint.deckard <[email protected]>: > Alvaro, > details about this issue can be found here > https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix > > At this stage probably the best way to correct the immediate problem would > be to delete the entry in the old_issues table. > Pedro Amorin recently posted the following which may assist you; > "1) Copy the ID's under *Checkouts* from About Koha -> System Information > > 2) *Select * from old_issues where issue_id IN (<paste ID's here>)* > Confirm the listed rows are the ones you want to delete; > > 3) *Delete from old_issues where issue_id IN (<paste ID's here>);* > > 4) Check in items and be happy." > > Thank you to Pedro. > > Although this fixes the immediate problem you will still have to address > the reason that it occurred and that will depend on the version and install > method of your Koha. > > Clint Deckard. > > > Alvaro Cornejo wrote: > >> Hi >> >> I have an item that I can not return (Check in) . It gaves me the error >> ¨Unable to check in¨ >> >> If I go to About/System information I have the following note: >> >> The following ids exist in both issues and old_issues tables: 1 >> >> How can I fix this? >> >> Thanks, >> >> >> 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-01-09 8:04 GMT-05:00 Jonathan Druart < >> [email protected]>: >> >> Hi Daniel, >>> >>> Take a look at /etc/mysql/koha-common.cnf, you should see the credentials >>> koha-create is going to use to create the Koha database (not root). >>> >>> Regards, >>> Jonathan >>> >>> On Tue, 9 Jan 2018 at 03:28 Daniel Owens <[email protected]> wrote: >>> >>> I am moving our library to a new server with Ubuntu 16.04. Following the >>>> instructions at >>>> https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages, I >>>> installed MariaDB instead of MySQL. >>>> >>>> When I run: sudo koha-create --create-db koha_library >>>> >>>> The result is: ERROR 1045 (28000): Access denied for user >>>> 'root'@'localhost' (using password: NO) >>>> >>>> I'd been wrestling with this problem for awhile before I got to this >>>> point because I got similar messages when trying to configure >>>> phpmyadmin. I can run "mysql -u root -p". However, just "mysql -u root" >>>> fails with the above message as well. Is there a way to tell koha-create >>>> to run using a password? Or am I missing something? >>>> >>>> I am hoping someone has a quick solution. >>>> >>>> Daniel >>>> _______________________________________________ >>>> 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 >>> >>> >> >> <https://www.avast.com/sig-email?utm_medium=email&utm_source >> =link&utm_campaign=sig-email&utm_content=webmail> >> Libre >> de virus. www.avast.com >> <https://www.avast.com/sig-email?utm_medium=email&utm_source >> =link&utm_campaign=sig-email&utm_content=webmail> >> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> >> _______________________________________________ >> 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
