Hello Katrin Thanks for the info. Indeed I was able to solve the staff login problem because in the borrowers table there was a duplicate in the field 'userid' which should not have been. I edited the duplicate userid (same student but with a different student card number). There were also problems with the old field 'privacy' as 128 rows had a value of '2' instead of either '0' or '1'. I did an update sql query to put all those '2' values to '1' and after that upgrading was OK. Instead of using the web interface to do the database upgrade, I followed the advice of (sorry, I forgot the name) of running the upgrade in a terminal (koha-upgrade-schema library) which pointed at the two problems met above. The problem of searching the OPAC (an other post I made) after the upgrade was solved by running in a terminal 'koha-rebuild-zebra -v -f library), which is something that should be done after each upgrade from an older database to a newer version of Koha. Best regards Quynh ================= M. Vũ Đỗ Quỳnh (Ph.D) Trường Đại học Thăng Long - Université de Thang Long - Thang Long University (Hanoi, Vietnam) Phó Hiệu Trưởng, phụ trách HTQT - Vice-recteur chargé de la coopération internationale - Vice-Rector in charge of International Cooperation Web: http://thanglong.edu.vn/ Vào Th 2, 18 thg 5, 2020 vào lúc 04:31 Katrin Fischer < katrin.fischer.83@web.de> đã viết:
Hi,
misc/batchRebuildBiblioTables.pl has to be run from command line, there is no option to make this change from the GUI.
The database user and the superlibrarian accounts are separate things. If you don't remember the password for the superlibrarian, you can create another with a different userid/cardnumber and use that to get back into the system.
Then you can also use it to reset the password on your old superlibrarian account or to delete it.
Hope that helps,
Katrin
On 16.05.20 10:19, Quỳnh Vũ Đỗ wrote:
Hi Jason I did it as you instructed to note all the information output to the terminal. I was able to fix the main errors (two actually) and at the second run, all went rather smoothly and I could display the login window. Still some issues to be fixed through library maintenance with some perl scripts, which I believe might be the source of the OPAC still not returning search results on the catalog. For example I had messages like this one: Upgrade to 19.06.00.018 done (Bug 11529: Add medium, subtitle and part information to biblio table) NOTE: misc/batchRebuildBiblioTables.pl should be run to populate the fields introduced in bug 11529. It may take some time for larger databases.
I understand that either I should be able to log in as staff administrator to perform that task OR get into a koha shell to run that script. Is that correct?
I am now trying to find how to reset the superlibrarian password to be able to log in to perform that maintenance.
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha